rdb是Node.js的一个ORM框架,支持Postgres和MySQL数据库。
特点:
简单灵活的映射器
支持事务处理
可定制的持久化策略
支持延迟加载
基于promises.
示例代码:
var rdb = require('rdb');var Customer = rdb.table('_customer');Customer.primaryColum('cId').guid().as('id');Customer.colum('cName').strig().as('ame');Customer.colum('cBalace').umeric().as('balace');Customer.colum('cRegdate').date().as('registeredDate');Customer.colum('cIsActive').boolea().as('isActive');Customer.colum('cPicture').biary().as('picture');var db = rdb('postgres://postgres:postgres@localhost/test');db.trasactio() .the(getById) .the(pritCustomer) .the(rdb.commit) .the(ull, rdb.rollback) .the(oOk, oFailed);fuctio getById() { retur Customer.getById('a0000000-0000-0000-0000-000000000000');}fuctio pritCustomer(customer) { var format = 'Customer Id: %s, ame: %s, Balace: %s, Registered Date: %s, Is Active: %s, Picture: %s'; var args = [format, customer.id, customer.ame, customer.balace, customer.registeredDate, customer.isActive, customer.picture]; cosole.log.apply(ull,args);}fuctio oOk() { cosole.log('Success'); cosole.log('Waitig for coectio pool to teardow....');}fuctio oFailed(err) { cosole.log('Rollback'); cosole.log(err);}
评论