Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var util = require('util');
- var Promise = require('promise');
- //New comment for update
- var pool = mysql.createPool({
- multipleStatements: true,
- host: '192.168.94.27',
- user: 'root',
- database: 'test',
- password: 'password',
- dateStrings: 'date',
- connectionLimit: 20,
- });
- exports.execSQL = function(sql){
- return new Promise(function (resolve, reject) {
- pool.getConnection(function(err,connection){
- if (err) reject(err);
- connection.query(sql, function(err, rows, fields) {
- if (err) reject(err);
- resolve(rows);
- });
- connection.release();
- });
- })
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement