import { neon } from '@neondatabase/serverless'
import { drizzle } from 'drizzle-orm/neon-http'
import type { NeonHttpDatabase } from 'drizzle-orm/neon-http'
import type { Schema } from '../index.js'

export function createNeonHttpClient<S extends Schema>(opts: {
  connectionString: string
  schema?: S
}): Omit<NeonHttpDatabase<S>, 'transaction'> {
  const sql = neon(opts.connectionString)
  return drizzle(sql, { schema: opts.schema })
}