// Applique les migrations Drizzle (idempotent, journal __drizzle_migrations). Usage : DATABASE_URL=… pnpm db:migrate
import { drizzle } from "drizzle-orm/postgres-js";
import { migrate } from "drizzle-orm/postgres-js/migrator";
import postgres from "postgres";
async function main() {
  const url = process.env.DATABASE_URL; if (!url) { console.error("DATABASE_URL manquante"); process.exit(1); }
  const sql = postgres(url, { max: 1 });
  await migrate(drizzle(sql), { migrationsFolder: "./drizzle" });
  console.log("migrations OK →", url.replace(/:\/\/([^:]+):[^@]+@/, "://$1:***@"));
  await sql.end();
}
main().catch((e) => { console.error(e); process.exit(1); });