const mysql = require("mysql");

// Create a connection pool to manage multiple connections
const pool = mysql.createPool({
  host: "127.0.0.1",
  user: "idmc_user",
  password: "99XB0yuKSRAaab8%",
  database: "IDMC_db",
  options: {
    encrypt: true, // Use encryption
    enableArithAbort: true, // Required setting
  },
  connectionLimit: 10, // Adjust the pool size based on your needs
});

// Export the pool for use in other modules
module.exports = pool;