import { createDBPool, migratePSQL } from "./src/internal/datastore/index";
import * as dotenv from "dotenv";
import path from "path";
dotenv.config({ path: path.resolve(process.cwd(), '../../.env') });

const config = {
  host: process.env.DATABASE_HOST,
  port: parseInt(process.env.DATABASE_PORT || "5432"),
  database: process.env.DATABASE_NAME,
  user: process.env.DATABASE_USER,
  password: process.env.DATABASE_PWD,
  ssl:
    process.env.DATABASE_HOST !== "localhost" &&
      process.env.DATABASE_HOST !== "127.0.0.1"
      ? { rejectUnauthorized: false }
      : undefined,
};

async function check() {
  const db = createDBPool(config);
  try {
    const migrator = await db.selectFrom('kysely_migration' as any).selectAll().execute();
    console.log("Migrations run:");
    console.log(migrator);

    const res = await db.selectFrom('console_features').selectAll().execute();
    console.log("Features in DB:");
    console.log(res);

    await migratePSQL(config);
  } catch (e) {
    console.error(e);
  } finally {
    await db.destroy();
  }
}

check();