Awesome
json-schema-table
![Coverage Status](https://coveralls.io/repos/github/andrglo/json-schema-table/badge.svg?branch=master)
Creates and maintains a SQL table structure equivalent to a json schema definition. For MSSQL and Postgres
First you create all your tables and then syncronizes then with each other to create the references. You can sync whenever you modify your json schema
Install
$ npm install --save json-schema-table
Usage
var jsonSchemaTable = require('json-schema-table');
var pg = require('pg-cr-layer');
var studentSchema = require('./student.json');
var classSchema = require('./class.json');
// initialize and connect to a database
var studentTable = jsonSchemaTable('person', studentSchema, {db: pg});
var classTable = jsonSchemaTable('student', classSchema, {db: pg});
// First create then sync to build the references
studentTable.create().then(function() {
return classTable.create();
}).then(function() {
return studentTable.sync();
}).then(function() {
return classTable.sync();
}).catch(function(error) {
console.log(error);
});
For the db connection you can use mssql-cr-layer or pg-cr-layer
To more details take a look at the tests
License
MIT © Andre Gloria