const mysql = require("mysql2/promise")

// Create connection pool
const pool = mysql.createPool({
  host: process.env.DB_HOST1 ,
  user: process.env.DB_USER1 ,
  password: process.env.DB_PASSWORD1 ,
  database: process.env.DB_NAME1 ,
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0,
})

// Test connection
async function testConnection() {
  try {
    const connection = await pool.getConnection()
    console.log("Connected to database")
    connection.release()
  } catch (err) {
    console.error("Database connection error: " + err.stack)
  }
}

testConnection()

module.exports = pool