import { env } from "~/env";
import { drizzle } from "drizzle-orm/neon-http";
import { migrate } from "drizzle-orm/neon-http/migrator";
import { neon } from "@neondatabase/serverless";

const sql: ReturnType<typeof neon> | undefined = neon(env.DATABASE_URL);

const db = drizzle(sql);

const main = async () => {
  try {
    console.log("DATABASE URL");
    console.log(env.DATABASE_URL);
    await migrate(db, {
      migrationsFolder: "src/db/global/migrations",
    });

    console.log("Migration complete!");
  } catch (error) {
    console.error("Migration failed", error);
  }
};

await main();

import { env } from "~/env";
import { drizzle } from "drizzle-orm/neon-http";
import { migrate } from "drizzle-orm/neon-http/migrator";
import { neon } from "@neondatabase/serverless";

const sql: ReturnType<typeof neon> | undefined = neon(env.DATABASE_URL);

const db = drizzle(sql);

const main = async () => {
  try {
    console.log("DATABASE URL");
    console.log(env.DATABASE_URL);
    await migrate(db, {
      migrationsFolder: "src/db/global/migrations",
    });

    console.log("Migration complete!");
  } catch (error) {
    console.error("Migration failed", error);
  }
};

await main();