MySQLHelper

A helper to manage the connection pool for MySQL.

Installing

npm install --save @kevinwang0316/mysql-helper

Usage

// Node
const { initialPool, query, getPool, release } = require('@kevinwang0316/redis-helper');
// ES6
//import {
//  initialPool, query, getPool, release,
//} from '@kevinwang0316/redis-helper';

// Initialize the client before you use other functions (the default connectionLimit is 1 for the Lambda function)
initialPool('host', 'user', 'password', 'database');

// Set values
await setAsync('key', 'value');

// Query
query(sql, paramters, callback);
// Or use the async api
const { rows, fields } = await queryAsync(sql, paramters);

// Get MySQL pool if need
const pool = getPool();

// Release the pool if need (If you are using it in a Lambda function, do not release the pool in ordor to reuse)
release();

License

RedisHelper is licensed under MIT License - see the License file.