Sync-in · Sovereign platform for file storage, sharing, synchronization, and collaboration.
TypeScript cloud-alternativecollaborationcollaborative-editingdropboxfile-serverfile-sharingfile-storagefile-syncfull-text-searchhomelabnextcloudon-premiseopen-sourceprivacy-firstprivate-cloudrealtimesecureself-hostedstorage-serverwebdav
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
})