Dbobject NPM | npm.io

dbobject

initialize

you need to initialize this module with calling mysql or postgresql methods

var db = require('dbobject');

// initialize for mysql
db.mysql('database', 'username', 'password', 'host');

// OR initialize for postgresql
db.postgresql('database', 'username', 'password', 'host');

call anywhere

just require dbobject when you need to reach database

var db = require('dbobject')

methods

mysql(database, user, pass, host)
postgresql(database, user, pass, host)
query(sql, options)
exec(sql, options)
first(sql, options)
value(sql, options)
values(sql, options)
keyValue(sql, options)
dbobject(tablename, options)
end()

dbobject methods

select(query, options)
insert(values)
update(id, values)
delete(id)

Usage

sample usage for database queries

var db = require('dbobject')

// initialize
db.mysql('database', 'username', 'password', 'host')

db.query('select * from employee').then(function(result){
    console.log(result)
}).catch(function(err){
    console.log(err)
}).then(function(){
    db.end()
})

Sample usage with dbobject (simplified crud functions for api services)

var db = require('dbobject')

db.mysql('database', 'username', 'password', 'host')

var dbo = db.dbobject('tablename')

dbo.search({title: 'manager'}).then(function(result){
    console.log(result)
}).catch(function(err){
    console.log(err)
})

Sample nodejs/express module for api services

var express = require('express'),
    router = express.Router(),
    db = require(dbobject),
    dbo = db.dbobject('article')

router.get('/', (req, res, next) => {
	dbo.search(req.query).then(function(result){
		res.json(result)
	}).catch(next)
})

router.get('/:id', (req, res, next) => {
	dbo.get(req.params.id).then(function(result){
		res.json(result)
	}).catch(next)
})

router.post('/', (req, res, next) => {
	dbo.insert(req.body).then(function(result){
		res.json(result)
	}).catch(next)
})

router.put('/:id', (req, res, next) => {
	dbo.update(req.params.id, req.body).then(function(result){
		res.json(result)
	}).catch(next)
})

router.delete('/:id', (req, res, next) => {
	dbo.delete(req.params.id).then(function(result){
		res.json(result)
	}).catch(next)
})

module.exports = router;