mkdir -p lib/db

cat > lib/db/pool.js <<'JS'
import mysql from "mysql2/promise";

export function getPool() {
  if (!globalThis.__JOBBOND_POOL__) {
    globalThis.__JOBBOND_POOL__ = mysql.createPool({
      host: process.env.DB_HOST || "127.0.0.1",
      port: Number(process.env.DB_PORT || 3306),
      user: process.env.DB_USER,
      password: process.env.DB_PASSWORD,
      database: process.env.DB_NAME_ATS || process.env.DB_NAME || "jobbond_ats",
      waitForConnections: true,
      connectionLimit: 10,
      queueLimit: 0,
    });
  }
  return globalThis.__JOBBOND_POOL__;
}
JS