NodeJS wrapper for MySQL query, based on “mysql” package
Let`s say you have MySQL connection as separated module like this
'use strict'; const mysql = require('mysql'); let mySqlConnection = mysql.createConnection( { host: 'http://example.com', port: 80, user: 'user', password: 'password', database: 'database', timezone: 'UTC', } ); module.exports = mySqlConnection;Then you can use mysql-query like this
'use strict'; const mysqlQuery = require('mysql-query'), mysqlConnection = require('./mysql-connection'); function foo () { const resolveHandler = rows => rows, rejectHandler = err => { console.error('NOOOOOOO', err); return err; }, query = ` SELECT * FROM test WHERE answer = 42 `; return mysqlQuery(mysqlConnection, query, resolveHandler, rejectHandler) .then(rows => console.log); }