node package manager
Loosely couple your services. Use Orgs to version and reuse your code. Create a free org »

waterline-pg-json-import

waterline-pg-json-import

Construct a Waterline ORM from a Postgres Schema.

NPM version Build status Dependency Status

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

License

MIT