import { drizzle } from "drizzle-orm/node-postgres";
import pg from "pg";
import * as schema from "./schema";
import { ensureDatabaseUrl } from "./db-env";

const { Pool } = pg;

const connectionString = ensureDatabaseUrl();

export const pool = new Pool({ connectionString });
export const db = drizzle(pool, { schema });

export * from "./schema";