Skip to content

Sync-in · Sovereign platform for file storage, sharing, synchronization, and collaboration.

1002 B
Raw Blame
import { sql } from 'drizzle-orm'
import { DrizzleQueryError } from 'drizzle-orm/errors'
import { migrate } from 'drizzle-orm/mysql2/migrator'
import { DB_SESSION_INIT_QUERIES, MIGRATIONS_PATH } from '../constants.js'
import { getDB } from './db.js'

async function applyMigrations(): Promise<void> {
  const db = await getDB()

  try {
    for (const query of DB_SESSION_INIT_QUERIES) {
      await db.execute(sql.raw(query))
    }
    await migrate(db, { migrationsFolder: MIGRATIONS_PATH })
    console.log('Database migrations applied successfully!')
  } finally {
    await db.$client.end()
  }
}

applyMigrations().catch((error: unknown) => {
  console.error('Database migration failed!')

  if (error instanceof DrizzleQueryError) {
    console.error(`Failed SQL query:\n${error.query}`)
    if (error.params.length > 0) {
      console.error('Parameters:', error.params)
    }
    console.error('Database error:', error.cause)
  } else {
    console.error(error)
  }

  process.exitCode = 1
})