Nominating Presidential Muppets

npm

Ready to take your JavaScript development to the next level? Meet npm Enterprise - the ultimate in enterprise JavaScript.Learn more »

json-schema-table

1.0.12 • Public • Published

json-schema-table NPM version Dependency Status CircleCI Coverage Status

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

install

npm i json-schema-table

Downloadsweekly downloads

62

version

1.0.12

license

MIT

homepage

github.com

repository

Gitgithub

last publish

collaborators

  • avatar
Report a vulnerability