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
• insert
• update
• delete
• sum
• count
• avg
• max
• min
• fetchSql
• transaction

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: '[email protected]',
    password: '8*********sdfsdfsd',
    name: '"test"',
    tel: 333333333,
  })

update

  yield dbInstance.table('account').where({account: '[email protected]', status: 2}).update({name: 'dddddd', group_id: 33, permission: 111})

delete

  yield dbInstance.table('account').where({account: '[email protected]'}).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()