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 keyreplace
: 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;
License
MIT © [chopperlee]