import path from 'node:path'
import { drizzle } from 'drizzle-orm/bun-sqlite'
import { migrate } from 'drizzle-orm/bun-sqlite/migrator'
import type { Database } from 'bun:sqlite'

export function runMigrations(sqlite: Database, opts?: { migrationsFolder?: string }) {
  const migrationsFolder =
    opts?.migrationsFolder || path.resolve(import.meta.dir, '../drizzle')

  const db = drizzle(sqlite)
  migrate(db, { migrationsFolder })
}