missy-postgres
v0.0.1
Published
PostgreSQL driver for Missy ORM
Downloads
35
Readme
Missy MongoDB driver
PostgreSQL database driver for Missy.
Usage
Creating a Schema
Simple form:
var missy = require('missy').loadDriver('postgres')
;
var schema = new missy.Schema('postgres://localhost/test');
Full form with manual driver initialization:
var missy = require('missy').loadDriver('postgres'),
pg = require('pg')
;
// Driver
var driver = new MongodbDriver(function(){ // Custom connecter function
// A promise for a client
var client = new pg.Client('postgres://user:pass@host/database');
return function(){
return Q.nmcall(client, 'connect')
.thenResolve(client);
); // -> client
});
// Schema
var schema = new missy.Schema(driver);
Type Handlers
The driver redefines the following standard types:
'object'
: is always JSON-encoded
Tests
In order to run the tests, you need to define the 'MISSY_POSTGRES` environment variable. The tests will work on the provided DB and clean-up the created tables afterwards:
$ MISSY_POSTGRES="postgres://user:pass@localhost/test" npm test