import { config } from "dotenv";
import { resolve, dirname } from "path";
import { fileURLToPath } from "url";
import { execSync } from "child_process";

const __filename = fileURLToPath(import.meta.url);
const __dirname = dirname(__filename);

config({ path: resolve(__dirname, "../../../.env") });

const { getDialect } = await import("./dialect.js");
const dialect = getDialect();

const configMap: Record<string, string> = {
  sqlite: "drizzle.config.sqlite.ts",
  mysql: "drizzle.config.mysql.ts",
  postgresql: "drizzle.config.pg.ts",
};

const configFile = configMap[dialect];
console.log(`Generating migrations for dialect: ${dialect}`);

execSync(`npx drizzle-kit generate --config=${configFile}`, {
  cwd: resolve(__dirname, ".."),
  stdio: "inherit",
});