Package Exports

openrecord

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (openrecord) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

OpenRecord

ActiveRecord like ORM for nodejs

Installation

npm install openrecord

Features

SQLite3, MySQL, Postgres, REST support
Async schema definition
Automatic field definition loading (SQL)
Relations (hasMany, hasOne, belongsTo with through, polymorph)
Nested Cascade delete
Nested Eager Loading
Nested Creates
Nested Updates
Nested Joins
Validations
Scopes
Before and After Hooks
Events
Chaining
Promises
Migrations
Plugin support
Build in plugins (stampable, paranoid, nested set)
... with almost 900 tests

Roadmap to 1.0.0

better documentation
more examples

Usage

var OpenRecord = require('openrecord');

var sqlite = new OpenRecord({
  type: 'sqlite3',
  file: 'test.sqlite'
});


sqlite.Model('User', function(){
  this.hasMany('posts');
    
  this.scope('active', function(){
    this.where({active: true});
  });
});


sqlite.Model('Post', function(){
  this.belongsTo('user');
});


sql.ready(function(){
  var User = sql.Model('User');

  User.active().where({posts: {title_like:'openrecord' }}).include('posts').exec(function(records){
    console.log(records);
  });
});

Documentation

Contributing

If you've found a bug please report it via the issues page. Please make sure to add a unit test with the bug report! Before submit pull request make sure all tests still passed.