json2mysql

A tool for comparing your configure json file with mysql table, then Loaded

Usage no npm install needed!

<script type="module">
  import json2mysql from 'https://cdn.skypack.dev/json2mysql';
</script>

README

json2mysql

NPM version Build Status Downloads Code Style

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]