missy-postgres

0.0.1 • Public • Published

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

Readme

Keywords

none

Package Sidebar

Install

npm i missy-postgres

Weekly Downloads

0

Version

0.0.1

License

MIT

Last publish

Collaborators

  • kolypto