Wondering what’s next for npm?Check out our public roadmap! »

    json-schema-table

    1.0.19 • 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

    6

    Version

    1.0.19

    License

    MIT

    Unpacked Size

    31.7 kB

    Total Files

    5

    Last publish

    Collaborators

    • avatar