dbConfig.mysql.js

require("dotenv").config();

const mysql = require('mysql2');

// const pool = mysql.createConnection({
//   host: `${process.env.MYhost}`,
//   user: `${process.env.MYuser}`,
//   password: `${process.env.MYpassword}`,
//   database: `${process.env.MYdatabase}`
// });

// pool.connect (function (error) {
//   if(error) throw error;
//   console.log("CONNECTED");
//   console.log(`pool: `, pool);
//   console.log(`process.env.MYhost: `, process.env.MYhost);
//   console.log(`process.env.MYuser: `, process.env.MYuser);
//   console.log(`process.env.MYdatabase: `, process.env.MYdatabase);
// });

const pool = mysql.createPool({
  host: `${process.env.MYhost}`,
  user: `${process.env.MYuser}`,
  password: `${process.env.MYpassword}`,
  database: `${process.env.MYdatabase}`,
  waitForConnections: true,
  connectionLimit: 5,
  queueLimit: 0
});

pool.getConnection(function(err, connection) {
  if(err) throw err;
  console.log(`POOL CONNECTION ESTABLISHED `);
  console.log(`process.env.MYhost: `, process.env.MYhost);
  console.log(`process.env.MYuser: `, process.env.MYuser);
  console.log(`process.env.MYdatabase: `, process.env.MYdatabase);
})

// Attempt to catch disconnects 
pool.on('connection', function (connection) {
  console.log('DB Connection established');

  connection.on('error', function (err) {
    console.error(new Date(), 'MySQL error', err.code);
  });
  connection.on('close', function (err) {
    console.error(new Date(), 'MySQL close', err);
  });

});

module.exports = pool;