// const mysql = require("mysql2");
// require("dotenv").config();

// const pool = mysql.createPool({
//   host: process.env.DB_HOST || "localhost",
//   user: process.env.DB_USER || "root",
//   password: process.env.DB_PASS || "",
//   database: process.env.DB_NAME || "mypocketapp",
//   port: process.env.DB_PORT || 3306,
// });

// pool.getConnection((err) => {
//   if (err) {
//     console.error("❌ Database connection failed:", err);
//     return;
//   }
//   console.log("✅ MySQL Connected...");
// });

// module.exports = pool;

const mysql = require("mysql2/promise");
require("dotenv").config();

const pool = mysql.createPool({
  host: process.env.DB_HOST || "localhost",
  user: process.env.DB_USER || "root",
  password: process.env.DB_PASS || "",
  database: process.env.DB_NAME || "mypocketapp",
  port: process.env.DB_PORT || 3306,
});

// Test the database connection
(async () => {
  try {
    const connection = await pool.getConnection();
    console.log("✅ MySQL Connected...");
    connection.release(); // Release the connection back to the pool
  } catch (err) {
    console.error("❌ Database connection failed:", err);
  }
})();

module.exports = pool;