import { drizzle } from "drizzle-orm/mysql2";
import mysql from "mysql2/promise";
import * as schema from "./schema";

function createPool() {
  const url = process.env.DATABASE_URL;
  if (!url) return null;
  try {
    return mysql.createPool(url);
  } catch {
    return null;
  }
}

const pool = createPool();
export const db = pool ? drizzle(pool, { schema, mode: "default" }) : null;

export function hasDb(): boolean {
  return db !== null;
}
