mysql-tools.js

const { promisify } = require('util')

/**
 * Mysql tools factory
 * @param {(Connection|Pool|PoolCluster)} db Conection
 * @returns {Object}
 */
module.exports = function tools (db) {
  const query = promisify(db.query).bind(db)
  const end = promisify(db.end).bind(db)
  const q = sql => x => query(sql, x)
  const first = (sql, x) => query(sql, x).then(r => r && r[0])
  const one = sql => x => query(sql, x).then(r => r && r[0])
  return { db, end, q, query, first, one }
}