then-mysql2

A wrapper for the npm MySQL2 driver to use promises, connection pooling and nicer APIs all round

NPM - (https://www.npmjs.com/package/then-mysql2)

Installation

npm install then-mysql2

API

To construct a new connection pool, simply run:

var pool = new MySql({
  host: 'localhost',
  user: 'me',
  passowrd: 'secret'
});

pool.query('SELECT 1 + 1 AS solution').done(function (result) {
  assert(result[0].solution === 2);
  pool.dispose().done();
});

pool.query(str, values)

Return a promise for an array of objects from a SQL query. The query may optionally contain ?s to be replaced with escaped values from values which should be an array.

pool.call(name, args)

Call a database procedure. If it returns only one set of values, that set of values is returned as an array of objects. If it returns multiple sets of values then they are returned as an array.

e.g.

pool.call(addprocedure, [1, 2]).done(function (result) {
  assert(result[0].solution === 3);
});

License

MIT