RDX

A simple ORM for Node.js. Currently only supports mysql-libmysqlclient: https://github.com/Sannis/node-mysql-libmysqlclient

Usage

Here is some example usage using the test database present in tests/fixtures/db_schema.sql:

var rdx = require('rdx') var cfg = { adapter: 'mysql-libmysqlclient', host: "localhost", database: "test", };

var cp = new rdx.ConnectionPool(cfg); var User = new rdx.Model(cp, 'users'); var Collection = new rdx.Model(cp, 'collections'); var Item = new rdx.Model(cp, 'items');

User.toMany('collections', Collection, Collection.fields["user_id"]); Collection.belongsTo('user', Collection.fields["user_id"], User); Collection.toMany('items', Item, Item.fields['collection_id']); Item.belongsTo('collections',Item.fields["collection_id"], Collection);

u = User.create({email: "a@b", user_type: 0}, false) u.destroySync()

u = User.find("1", false) u.collections.findOne(false).user.findOne(false) u = User.where('id = 1').findOne(false);

User.find("1", function(err, res) { console.log(res); });

u.collections.where("name like '%book'").all(function(err, res) { console.log(res); })

Installation

Here is how you can install RDX:

npm install rdx

Contributing

Contributions to this project are most welcome, so feel free to fork, improve and submit pull requests. The test suite requires nodeunit https://github.com/caolan/nodeunit and can be run using the command

 node test.js

TODO

• Add tests for object creation, updation, deletion, etc.
• Better error handling
• SQL escaping, improve where clause