Include drizzle migrations in bundle

import type { BetterSQLite3Database } from 'drizzle-orm/better-sqlite3/driver'
import createLogger from '#shared/utils/logger'
import { migrate } from 'drizzle-orm/better-sqlite3/migrator'

export default defineNitroPlugin(() => {
  const db = useDB() as unknown as BetterSQLite3Database
  const logger = createLogger('migrations')

  try {
    logger.start('Migrating database')

    migrate(
      db,
      { migrationsFolder: '../database/migrations' },
    )

    logger.success('Migrated database')
  }
  catch (e) {
    logger.fatal('There is an error migrating database: ', e)
  }
})