A method to wrap your node application with a mysql pool.

mysqlConnector.js

/*
Created with refrence from
https://gist.github.com/binki/52662f18ae6fc89b18b020b89aa4e1cd
http://www.madhur.co.in/blog/2016/09/05/nodejs-connection-pooling.html
*/
const mysql = require('mysql'); // import

const pool = mysql.createPool({ // create pool instance
    host: "*",
    user: "*",
    password: "*",
    connectionLimit: 100, //important
});

/*
parse successful queries by converting RowDataPacket to JS Object
*/
const onSuccess = (rows) => {
    return (
        JSON.parse(
            JSON.stringify(rows)
           )
    )
}

const hitQuery = (query) => 
    new Promise((resolve, reject) => {
        pool.query(query, (ex, rows) => {
            (
                (ex) ? reject(ex) :
                resolve(rows)
                )
            });
        })
    .then((rows) => onSuccess(rows));


module.exports = hitQuery;

query.js

const hitQuery = require('./mysqlConnector.js');

query = (` select * from users where username="sam"`);

hitQuery(query)
.then(response => console.log(response))
.catch(e => console.log(e))

For your scenario, it would be better/cleaner to simply use pool.query() as I mentioned. Also, I would recommend rejecting the Promise rather than resolving it if the call returns an error.

const hitQuery = query => new Promise((resolve, reject) => {
  pool.query(query, (ex, rows) => {
    if (ex) {
      reject(ex);
    } else {
      resolve(rows);
    }
  });
}).then(onSuccess);

That way, you don’t need to worry about releasing the connection yourself. The library will take care of it for you.

@binki, thanks for the reply!
jeez I wish I would have just read your comments carefully would have saved me over an hour dealing with async nonsense. ill update my gist incase some one ends up stumbling upon it.

No problem! Thanks for updating your gist!