import { createPostgresJsClient } from '@platform-modules/db/postgres/postgres-js'

import { getDatabaseUrl, type PressZoneBindings } from './config.js'

export type DbEnv = Pick<PressZoneBindings, 'DATABASE_URL' | 'HYPERDRIVE'>

export function getDb(env: DbEnv) {
  return createPostgresJsClient({ connectionString: getDatabaseUrl(env) })
}