database-utils

Database utils for node.js

  • SqlBuilder
  • ORM
  • notlike, like($field, $match = '', $side = 'both', $op = 'like')
  • replace($table = '', $set = null, $where, $checkexisting = false)
  • [hold] history($updatefields = true, $insertfields = false)
  • selectcase
  • having
  • between
  • collect values as parameters to
  • [hold, need depends on execute] simple getcount
  • [hold, need depends on execute] simple getcountlike
  • [hold, need depends on execute] simple getwhere
  • parametric query with ?
  • write the test/functionality that is needed
  • unit tests
  • [hold] limit in update()
  • [hold] in delete()