wormorm

WORM (Worm Object Relational Mapper)

WORM is an ORM for Javascript that enables you to use POJsO's (Plain Old Javascript Objects) mapped against your relationhal database.

It is currently tested against Postgress, but in theory should be possible to make it work against any standard relational database.

====
##Step 1

Define your business objects. Currently there needs to be a one-to-one mapping between your database tables and your business objects. With a well designed database this should be typically the case. You can add methods to define your business logic and validation to these objects as well.

Say we have a customer with multiple addresses:

``
var customer={
id: null,
firstName: '',
lastName: '',
addresses: [],

getHomeAddress: function() {
for (var a in this.addresses) {
if (a.type === 'Home')
return a;
}
}
};

var address={
id: null,
customer_id: null,
street: '',
town: '',
country: '',
postcode: '',
type: 'Home'
};
`
===

##Step 2

Register these objects with WORM and define any relationships.

`
var worm = require('worm');

worm.registerSchema({
table: 'customer',
fields: customer,
relationships: [{field: addresses,
maps_to: 'address',
with_field: 'customer_id'
}]
});

worm.registerSchema({
table: 'address',
fields: address
});
`

===

##Step 3

Setup the connection to the database.
`
var pg = require('pg')

var connection = function() {
return new pg.Client(dbconfig);
};
`
===

##Step 4

Query the database, and play with your objects.
`
var customers = worm.model('customer', connection);
var addresses = worm.model('address', connection);

// Get Mr Smith from the database
var smith = customers.get({where: "firstName = $1", params['Smith']});

// Create a new address
var address = addresses.create({street: '13 Mongle Road',
town: 'Spooton Rabbit',
type: 'Business'});

// Add the address to Mr Smith
smith.addresses.push(address);

// Save the changes
customer.saveModel(smith);
``
====

##Step 5

Sit back and code your apps logic