An ORM that defines your database models for you.
- Works in node.js
- Supports PostgreSQL
- Extensible
Install using npm: npm install proactive-record
Assume you have a table with the following schema:
Table "public.person"
Column | Type | Modifiers
----------+------------------------+-----------------------------------------------------
id | integer | not null default nextval('person_id_seq'::regclass)
name | character varying(255) | not null
username | character varying(255) | not null
email | character varying(255) | not null
Indexes:
"person_pkey" PRIMARY KEY, btree (id)
MODELS
var Proactive = require('proactive-record');
Proactive.load('person', function(Person) {
var p = new Person({
name: 'Brian Moore',
username: 'bmoore',
email: 'moore.brian.d@gmail.com'
});
p.save();
Person.find({name: "Brian Moore"}, function(brian) {
console.log(brian)
// { name: 'Brian Moore',
// username: 'bmoore',
// email: 'moore.brian.d@gmail.com'}
});
});
- Model.find(finder, success)
- finder can be:
- integer,
- array of integers,
- {column: value} objects
- success parameter is:
- an object when one record is found
- an array when many records are found
- Model.all(success)
- success parameter is:
- an object when one record is found
- an array when many records are found
- .save() // Create and Update
- .delete() // Remove Record
- .children('address', function(addresses){}) // Access Child Table Records
- .parent('company', function(company){}) // Access Parent Table Record