import { drizzle, type PostgresJsDatabase } from "drizzle-orm/postgres-js";

import postgres from "postgres";

import * as schema from "./schema";

export * from "./schema";

export { schema };

export type Database = PostgresJsDatabase<typeof schema>;

let _db: Database | undefined;

let _client: ReturnType<typeof postgres> | undefined;

export function getDb(): Database {

  if (!_db) {

    const url = process.env.DATABASE_URL;

    if (!url) {

      throw new Error(

        "DATABASE_URL is not set. Copy .env.example to .env and add your Supabase connection string.",

      );

    }

    _client = postgres(url, { prepare: false });

    _db = drizzle(_client, { schema });

  }

  return _db;

}