A wrapper for the MySQL driver to use promises, connection pooling and nicer APIs all round
npm install then-mysql
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();
});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.
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);
});MIT