kysely.config.ts

import { defineConfig } from 'kysely-ctl'
import { CamelCasePlugin, PostgresDialect } from 'kysely'
import { Pool } from 'pg'

export default defineConfig({
  // Database connection using dialect instance with CamelCasePlugin
  dialect: new PostgresDialect({
    pool: new Pool({
      connectionString: process.env.DATABASE_URL,
      max: 10,
      ssl: process.env.NODE_ENV === 'production' ? { rejectUnauthorized: false } : undefined,
    }),
  }),

  plugins: [new CamelCasePlugin()],

  // Migration configuration
  migrations: {
    migrationFolder: 'migrations',
    allowJS: false, // Only allow TypeScript migrations
    getMigrationPrefix: () =>
      `${new Date()
        .toISOString()
        .replace(/[-:T.]/g, '')
        .slice(0, 14)}_`,
  },

  // Seed configuration
  seeds: {
    seedFolder: 'seeds',
    allowJS: false, // Only allow TypeScript seeds
  },

  // Keep connection alive after commands
  destroyOnExit: true,
})