missy-postgres

PostgreSQL driver for Missy ORM

Missy MongoDB driver

PostgreSQL database driver for Missy.

Usage

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);

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