0.1.4 • Published 7 years ago
node-easy-mysql v0.1.4
node-easy-mysql
Installation
npm install node-easy-mysql
Usage
const Db = require('node-easy-mysql')
const co = require('co')
const dbInstance = new Db({
host: 'localhost',
user: 'root',
password: 'root',
database: 'mydb'
})
co(function * () {
let result = yield dbInstance.table('account').field(['a.email', ['b.org_id', 'dddd']]).alias('a').join('left join zy_account_group b on a.group_id=b.id').limit(1).select()
console.log(result)
}).catch((err) => {
console.log(err)
})
API
select
yield dbInstance.table('account').field(['a.email', ['b.org_id', 'dddd']]).alias('a').join('left join zy_account_group b on a.group_id=b.id').limit(1).select()
insert
yield dbInstance.table('account').insert({
email: 'test@111.com',
password: '8*********sdfsdfsd',
name: '"test"',
tel: 333333333,
})
update
yield dbInstance.table('account').where({account: 'ttteeet@jjjj3.com', status: 2}).update({name: 'dddddd', group_id: 33, permission: 111})
delete
yield dbInstance.table('account').where({account: 'test@111.com'}).delete()
find
yield dbInstance.table('account').where({permission: 111}).find()
sum
result = yield dbInstance.table('account').where({pwd: '222222'}).sum('id')
min
result = yield dbInstance.table('account').where({pwd: '222222'}).min('id')
max
result = yield dbInstance.table('account').where({pwd: '222222'}).max('id')
avg
result = yield dbInstance.table('account').where({pwd: '222222'}).avg('id')
count
result = yield dbInstance.table('account').where({pwd: '222222'}).count('id')
fetchSql
This method just output the sql, not execute the sql.
yield dbInstance.table('account').fetchSql(true).field(['a.email', ['b.org_id', 'dddd']]).alias('a').join('left join group b on a.group_id=b.id').limit(1).select()
// 'SELECT `a`.`email`,`b`.`org_id` as dddd FROM `zy_account` a left join zy_account_group b on a.group_id=b.id LIMIT 0,1'
transaction
yield dbInstance.startTrans()
yield dbInstance.table('account1').add({account:'33333', pwd: '22222222222'})
yield dbInstance.table('account1').select()
yield dbInstance.commit()