json2mysql

json2mysql

[![Code Style][standard-image][standard-url]]

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

1. docker-compose up -d will create database container
2. 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;

1. npm test

License

MIT © [chopperlee]