1.4.12 • Published 1 year ago
@ikoala/node-mysql-promise v1.4.12
node-mysql-promise
Node.js MySQL library promise wrapper
Initialization
npm install @ikoala/node-mysql-promise
Usage
const db = require('@ikoala/node-mysql-promise')
const mysqlConfig = {
"host": "127.0.0.1",
"user": "root",
"password": "abc@123",
"database": "test"
}
db.create('master', mysqlConfig)
const query = async (val) => {
const sql = 'SELECT NOW(), ?, 1'
const params = [val]
const rs = await db.query(sql, params)
console.log(rs) // 2020-02-01 15:56:00,foo,1
}
query('foo')
Helper Functions
const select = helper.createSelect('table_name', 'primary_key_field');
(async () => {
await select({ all: true }) // Select all records
await select(1) // Select primary key id 1
// Select field `foo` with value `bar`
await select({ where: {
foo: 'bar'
}})
})()
const insert = helper.createInsert('table_name', 'primary_key_field', {
defaultFields: {
ctime: () => new Date()
}
});
(async () => {
await insert({
field1: 'foo',
field2: 'bar'
}) // foo,bar,[ctime date]
})()
Testing
# Setup DB Connection and Login Credential
export DB_HOST=127.0.0.1
export DB_USER=root
export DB_PASSWORD=abc@123
export DB_VERBOSE=1 # Optional, enable query log
npm run test
Dependencies:
1.4.11
1 year ago
1.4.12
1 year ago
1.4.6
2 years ago
1.4.2
2 years ago
1.4.8
2 years ago
1.4.10
2 years ago
1.3.8
3 years ago
1.3.7
3 years ago
1.3.6
3 years ago
1.3.5
3 years ago
1.3.4
4 years ago
1.3.3
4 years ago
1.3.2
4 years ago
1.2.0
4 years ago
1.2.3
4 years ago
1.3.1
4 years ago
1.2.2
4 years ago
1.3.0
4 years ago
1.2.1
4 years ago
1.1.4
5 years ago
1.1.3
5 years ago
1.1.2
5 years ago
1.1.1
5 years ago
1.1.0
5 years ago
1.0.2
6 years ago
1.0.0
6 years ago