mysqldb-handler

node.js mysql db handler using async/await

node version > 7.6

To install mysqldb-handler, use npm:

npm install mysqldb-handler --save

example

const MySQLDBHandler = require('mysqldb-handler');
const mysql = new MySQLDBHandler({
    connectionLimit: 100,
    waitForConnections: false,
    multipleStatements: true,
    host: '{HOSTNAME}',
    port: 3306,
    user: '{USERID}',
    password: '{PASSWORD}',
    database: '{DATABASE}'
});

(async () => {

    /**
     * Single Query 1st
     * @type {*}
     */
    let res1 = await mysql.connect(conn => {
        return conn.query(`select *
                           from TEST
                           where NAME = ?`, ['World']);
    });
    console.log(res1);

    /**
     * Single Query 2nd
     * @type {*|Promise<*>}
     */
    let res2 = await mysql.connect(conn => conn.query(`select *
                                                       from TEST
                                                       where NAME = ?`, ['World']));
    console.log(res2);

    /**
     * Transaction Query example
     * @type {T}
     */
    let res3 = await mysql.transaction(async (conn) => {
        await conn.query(`delete
                          from TEST`);
        await conn.query(`insert into TEST (NAME)
                          VALUES (?)`, ['Hello']);
        await conn.query(`update TEST
                          set NAME = 'World'
                          where NAME = ?`, ['Hello']);
        return 'OK';
    });
    console.log(res3);

})().catch(err => {
    console.error(err);
}).finally(() => {
    /**
     * Pool end
     */
    mysql.end();
});