mysql-connection v1.0.2

mysql-connection

An abstraction of mysql2 pooling for simple queries.

Installation

npm install mysql-connection --save

Usage

var Db = require('mysql-connection')
  , mysql = require('mysql2')
  , settings =
    { host: 'localhost'
    , user: 'root'
    , password: ''
    , database: 'test'
    , connectionLimit: 2
    }
  , db = new Db(mysql2, settings)

// Simple query
db.query('sql here', [ 'params' ], function (error, data) {
  console.log(data)
})

// Access node-mysql2 pool
db.pool.getConnection(error, connection) {
  connection.release()
})