25 lines
654 B
TypeScript
25 lines
654 B
TypeScript
import { drizzle } from 'drizzle-orm/postgres-js';
|
|
import { migrate } from 'drizzle-orm/postgres-js/migrator';
|
|
import postgres from 'postgres';
|
|
|
|
const runMigrations = async () => {
|
|
const connectionString = process.env.DATABASE_URL;
|
|
if (!connectionString) {
|
|
throw new Error('DATABASE_URL is not set');
|
|
}
|
|
|
|
const sql = postgres(connectionString, { max: 1 });
|
|
const db = drizzle(sql);
|
|
|
|
console.log('Running migrations...');
|
|
await migrate(db, { migrationsFolder: './drizzle' });
|
|
console.log('Migrations complete!');
|
|
|
|
await sql.end();
|
|
};
|
|
|
|
runMigrations().catch((err) => {
|
|
console.error('Migration failed:', err);
|
|
process.exit(1);
|
|
});
|