#!/bin/sh
read -p "Enter migration filename: " FILENAME
[ -f ".env" ] && (
    mv .env .env.tmp
    source .env.tmp
)

make_migration() {
    echo "Creating migrations for $2"
    mkdir "../util/src/migrations/$2"
    npm run build clean logerrors pretty-errors
    THREADS=1 DATABASE="$1" DB_MIGRATE=a npm run start:bundle
    THREADS=1 DATABASE="$1" DB_MIGRATE=a npx typeorm-ts-node-commonjs migration:generate "../util/src/migrations/$2/$FILENAME" -d ../util/src/util/Database.ts -p
    npm run build clean logerrors pretty-errors
    THREADS=1 DATABASE="$1" DB_MIGRATE=a npm run start:bundle
}

npm i sqlite3
make_migration "database.db" "sqlite"

[ -z "$FC_DB_POSTGRES" ] || (
    npm i pg
    make_migration "$FC_DB_POSTGRES" "postgres"
)

[ -z "$FC_DB_MARIADB" ] || (
    npm i mysql2
    make_migration "$FC_DB_MARIADB" "mariadb"
)

[ -f ".env.tmp" ] && mv .env.tmp .env