node-mysql-promise

Node.js MySQL library promise wrapper

Initialization

npm install @ikoala/node-mysql-promise

Usage

1const db = require('@ikoala/node-mysql-promise')
2const mysqlConfig = {
3  "host": "127.0.0.1",
4  "user": "root",
5  "password": "abc@123",
6  "database": "test"
7}
8db.create('master', mysqlConfig)
9
10const query = async (val) => {
11  const sql = 'SELECT NOW(), ?, 1'
12  const params = [val]
13  const rs = await db.query(sql, params)
14  console.log(rs) // 2020-02-01 15:56:00,foo,1
15}
16
17query('foo')

Helper Functions

1const select = helper.createSelect('table_name', 'primary_key_field');
2(async () => {
3  await select({ all: true }) // Select all records
4  await select(1) // Select primary key id 1
5  // Select field `foo` with value `bar`
6  await select({ where: {
7    foo: 'bar'
8  }})
9})()
10
11const insert = helper.createInsert('table_name', 'primary_key_field', {
12  defaultFields: {
13    ctime: () => new Date()
14  }
15});
16(async () => {
17  await insert({
18    field1: 'foo',
19    field2: 'bar'
20  }) // foo,bar,[ctime date]
21})()

Testing

1# Setup DB Connection and Login Credential
2export DB_HOST=127.0.0.1
3export DB_USER=root
4export DB_PASSWORD=abc@123
5export DB_VERBOSE=1 # Optional, enable query log

npm run test

Dependencies:

MySQL2 - Node.js MySQL driver