23 lines
692 B
Bash
23 lines
692 B
Bash
|
#!/bin/sh
|
||
|
|
set -e
|
||
|
|
|
||
|
|
if [ -n "$DATABASE_URL" ]; then
|
||
|
|
echo "==> Running database migrations"
|
||
|
|
node -e "
|
||
|
|
const { drizzle } = require('drizzle-orm/postgres-js');
|
||
|
|
const { migrate } = require('drizzle-orm/postgres-js/migrator');
|
||
|
|
const postgres = require('postgres');
|
||
|
|
(async () => {
|
||
|
|
const sql = postgres(process.env.DATABASE_URL, { max: 1 });
|
||
|
|
const db = drizzle(sql);
|
||
|
|
await migrate(db, { migrationsFolder: './lib/db/migrations' });
|
||
|
|
await sql.end();
|
||
|
|
console.log('Migrations completed');
|
||
|
|
})().catch((err) => { console.error('Migration failed:', err); process.exit(1); });
|
||
|
|
"
|
||
|
|
else
|
||
|
|
echo "==> DATABASE_URL not set, skipping migrations"
|
||
|
|
fi
|
||
|
|
|
||
|
|
exec "$@"
|