import path from "node:path";
import { loadTestConfiguration } from "../src/config";
import Migration from "../src/database/Migration";
import PgDatabase from "../src/database/PgDatabase";
import type { DatabaseInterface } from "../src/database/DatabaseInterface";

export async function initTestDatabase(): Promise<DatabaseInterface> {
  const testConfiguration = loadTestConfiguration();

  const database = PgDatabase.fromOptions(testConfiguration.database);
  await database.ping();

  await database.exec("DROP SCHEMA public CASCADE");
  await database.exec("CREATE SCHEMA public");

  const migration = new Migration(database);
  await migration.execute(path.resolve("migrations"));

  return database;
}