import { migrate } from 'drizzle-orm/better-sqlite3/migrator'

export default defineTask({
  meta: {
    name: 'db:migrate',
    description: 'Run database migrations',
  },
  async run({ payload, context }) {
    await migrate(useDrizzle(), { migrationsFolder: 'server/database/migrations' })

    return { result: 'Success' }
  },
})