import mysql from "mysql2/promise";

let pool: mysql.Pool | null = null;

export function getPool() {
  if (!pool) {
    pool = mysql.createPool({
      host: "localhost",
      user: "renison",
      password: "oitavA8s3n@crn",
      database: "calculadora_penal",
      waitForConnections: true,
      connectionLimit: 10,
    });
  }
  return pool;
}

// eslint-disable-next-line @typescript-eslint/no-explicit-any
export async function query(sql: string, params: any[] = []) {
  const p = getPool();
  const [rows] = await p.execute(sql, params);
  return rows;
}