json2mysql v0.3.3

json2mysql

A tool to load a JSON/JS object file to Mysql.

Install

npm i json2mysql

Usage

import json2mysql from "json2mysql"

const dbconfig = {}
const jm = json2mysql(dbconfig)
jm.load(tableName, file)
jm.replace(tableName, file)

Methods

• load: this will disable foreign key, remove table rows , then load json and enable foreign key
• replace: this will replace table rows with json file, by comparing table id with array index

Test

• docker-compose up -d will create database container
• create a test table in your database:

    CREATE TABLE `user` (
       `id` mediumint(9) NOT NULL AUTO_INCREMENT,
       `name` text,
       `team_id` int(11) DEFAULT NULL,
       PRIMARY KEY (`id`)
     ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 - `npm test`

## License

MIT © [chopperlee]

[npm-url]: https://npmjs.org/package/json2mysql
[npm-image]: https://img.shields.io/npm/v/json2mysql.svg?style=flat-square

[travis-url]: https://travis-ci.org/chopperlee/json2mysql
[travis-image]: https://img.shields.io/travis/chopperlee/json2mysql.svg?style=flat-square

[download-badge]: http://img.shields.io/npm/dm/json2mysql.svg?style=flat-square

[standard-image]: https://img.shields.io/badge/code_style-standard-brightgreen.svg
[standard-url]: https://standardjs.com