import { join } from "node:path";
import { migrate } from "drizzle-orm/node-postgres/migrator";

export default defineNitroPlugin(async () => {
	const noDbWrite = useRuntimeConfig().noDbWrite;
	if (noDbWrite) {
		LOGGER.warn("noDbWrite is enabled - not running database migration");
		return;
	}

	LOGGER.info("Running database migration");
	const db = useDrizzle();
	await migrate(db, {
		migrationsFolder: join(process.cwd(), "./server/database/migrations"),
	});
	LOGGER.info("Database migration completed");

	await runTask("analyze");
});