No description
- JavaScript 100%
|
|
||
|---|---|---|
| test | ||
| .gitignore | ||
| .gitlab-ci.yml | ||
| .jshintrc | ||
| .travis.yml | ||
| index.js | ||
| package.json | ||
| README.md | ||
mysql-promise
Small promises wrapper for mysql2,
it's forked and compatible with mysql-promise.
Installation
This module is installed via npm:
$ npm install mysql2-promise --save
Example Usage of query
var db = require('mysql2-promise')();
db.configure({
"host": "localhost",
"user": "foo",
"password": "bar",
"database": "db"
});
db.query('UPDATE foo SET key = ?', ['value']).then(function () {
return db.query('SELECT * FROM foo');
}).spread(function (rows) {
console.log('Look at all the foo', rows);
});
//using multiple databases, giving it a name 'second-db' so it can be retrieved inside other modules/files.
var db2 = require('mysql-promise')('second-db');
db2.configure({
"host": "localhost",
"user": "foo",
"password": "bar",
"database": "another-db"
});
db2.query('SELECT * FROM users').spread(function (users) {
console.log('Hello users', users);
});
Example Usage of execute
execute() function is similar to query but it use prepared-statements.
var db = require('mysql2-promise')();
db.configure({
"host": "localhost",
"user": "foo",
"password": "bar",
"database": "db"
});
db.execute('SELECT * FROM users WHERE LIMIT = ?', [10]).spread(function (users) {
console.log('Hello users', users);
});
Example usage of namedPlaceholders
var db = require('mysql2-promise')();
db.configure({
"host": "localhost",
"user": "foo",
"password": "bar",
"database": "db"
});
db.pool.on('connection', function (poolConnection) {
poolConnection.config.namedPlaceholders = true;
});
db.execute('SELECT * FROM users WHERE LIMIT = :limit', {limit: 10}).spread(function (users) {
console.log('Hello users', users);
});
Credits
This library is forked from mysql-promise