MySQL Promise Module

db.js

var mysql = require('mysql');
var util = require('util');
var Promise = require('promise');

//New comment for update
var pool = mysql.createPool({
  multipleStatements: true,
  host: '192.168.94.27',
  user: 'root',
  database: 'test',
  password: 'password',
  dateStrings: 'date',
  connectionLimit: 20,
});

exports.execSQL = function(sql){

  return new Promise(function (resolve, reject) {

  pool.getConnection(function(err,connection){

    if (err) reject(err);


    connection.query(sql, function(err, rows, fields) {
      if (err)  reject(err);
        resolve(rows);
    });

    connection.release();
  });
})
}

test.js

var db = require('./db');

var sql = "SELECT * from test";


db.execSQL(sql).then((data) => {

     console.log(data);
  })
  .catch((err) => {

    console.log(err);
  })