Waterline-pg-json-import NPM

waterline-pg-json-import

Construct a Waterline ORM from a Postgres Schema.

Install

$ npm install waterline-pg-json-import --save

Usage

Input JSON

First export your Postgres schema using https://www.npmjs.org/package/pg-json-schema-export

Run the Importer

var importer = require('waterline-pg-json-import');
var json = {
  // output from pg-json-schema-export
};
var configuration = {
  adapters: {
    disk: require('sails-disk')
  },
  connections: {
    readme: {
      adapter: 'disk'
    }
  }
};
var orm = importer.initialize(json, 'readme');
var collections;
waterline.initialize(configuration, function (err, orm) {
  if (err) throw err;
  collections = orm.collections;
});

API

`.initialize(json, connection)`

Generate the Waterline ORM

@param	description
`json`	JSON object representing the exported schema
`connection`	name of the Waterline connection to use
@return	description
`Array`	Array of `Waterline.Collection` objects

`.import(json, waterline)`

Import JSON into a Database

@param	description
`json`	JSON object containing the exported data
`waterline`	reference to the Waterline instance used to initialize the ORM
@return	description
`Object`	Report of number of rows inserted into each table