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

const globalForDb = globalThis as unknown as {
  conn: mysql.Pool | undefined;
};

// Crear un pool de conexiones para reutilizarlas de forma óptima
const connection = globalForDb.conn ?? mysql.createPool({
  uri: process.env.DATABASE_URL || "mysql://root:@localhost:3306/cursos_nirgua",
  connectionLimit: 10,
  enableKeepAlive: true,
  keepAliveInitialDelay: 0,
});

if (process.env.NODE_ENV !== "production") globalForDb.conn = connection;

// MariaDB (XAMPP) no soporta LATERAL JOIN; planetscale usa subconsultas compatibles.
export const db = drizzle(connection, { schema, mode: "planetscale" });