Status

DATA REPOSITORY

A simple service that saves JSON object from HTTP to SQL92 relational databases.

Resume

Based on Knexjs and ExpressJS, this service saves every JSON object into SQL92 relational databases. It supports MySQL, PostgreSQL, Sqlite3, MSSQL and Oracle.

Installation

First you need to clone this repository. Then you must install the service's dependencies.

git clone https://github.com/MGDIS/data-repository.git
cd data-repository
npm install

Test

This service comes with a mocha test suite. Run tests with this command :

npm test

Coverage and code analysis

If you want a report on code statistics, feel free to run cibuild command :

npm run-script cibuild

Documentation

Available documentation is in the wiki.

JSON to SQL

It will save JSON's map to named table and array to external table with foreign keys. It supports alter table when a new property is detected in existing table. It does not support dropping property from existing table Follow the wiki to understand basic mapping