import { migrate } from "drizzle-orm/node-postgres/migrator";
import { fileURLToPath } from "node:url";
import path from "node:path";
import { getDb, closeDb } from "./index";

const here = path.dirname(fileURLToPath(import.meta.url));
const migrationsFolder = path.resolve(here, "../drizzle");

async function main() {
  console.log(`[db] migrating from ${migrationsFolder}`);
  await migrate(getDb(), { migrationsFolder });
  console.log("[db] migrations applied");
  await closeDb();
}

main().catch((e) => {
  console.error("[db] migration failed", e);
  process.exit(1);
});