import mysql from 'mysql2/promise';
import dotenv from 'dotenv';

dotenv.config();

export const pool = mysql.createPool({
  host: process.env.DB_HOST || 'localhost',
  user: process.env.DB_USER || 'thiqljmz_banksfindersadmin',
  password: process.env.DB_PASS || 'Yash@21082023',
  database: process.env.DB_NAME || 'thiqljmz_banksfinders',
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0,
});

// export const pool = mysql.createPool({
//   host: process.env.DB_HOST || 'localhost',
//   user: process.env.DB_USER || 'thiqljmz_banksfindersadmin',
//   password: process.env.DB_PASS || 'Yash@21082023',
//   database: process.env.DB_NAME || 'thiqljmz_testdb',
//   waitForConnections: true,
//   connectionLimit: 10,          
//   queueLimit: 0,
// });


// export const pool = mysql.createPool({
//   host: process.env.DB_HOST || 'localhost',
//   user: process.env.DB_USER || 'root',
//   password: process.env.DB_PASS || 'Pa$$word',
//   database: process.env.DB_NAME || 'thiqljmz_banksfinders',
//   waitForConnections: true,
//   connectionLimit: 10,
//   queueLimit: 0,
// });