No description
This repository has been archived on 2026-11-17. You can view files and clone it, but you cannot make any changes to its state, such as pushing and creating new issues, pull requests or comments.
  • JavaScript 100%
Find a file
2021-01-25 14:22:34 +00:00
test inital-commit 2015-04-29 12:04:27 +04:00
.gitignore inital-commit 2015-04-29 12:04:27 +04:00
.gitlab-ci.yml Aktualisieren .gitlab-ci.yml 2021-01-25 14:12:21 +00:00
.jshintrc inital-commit 2015-04-29 12:04:27 +04:00
.travis.yml Add npm install to travis 2015-05-13 12:18:32 +04:00
index.js added destroy function 2021-01-25 14:21:04 +00:00
package.json fix package name of fork 2021-01-25 13:54:56 +00:00
README.md Missing a closing bracket 2015-12-03 14:26:44 +00:00

mysql-promise

Small promises wrapper for mysql2, it's forked and compatible with mysql-promise.

build status NPM NPM

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