csv-sql-gen

This tool generate sql from csv file.

First, install the package.

$ npm install csv-sql-gen

You can easily run on CLI with csv-sql-gen.

$ csv-sql-gen

So you can set this command in your docker-compose command or build task.

Set csv-sql-gen.config.json

csv-sql-gen needs setting file named csv-sql-gen.config.json

Make json file named csv-sql-gen.config.json in your project root folder, Then fill it.

The rule is simple, please look below

[
  {
    "csv": "ken_all_rome.csv",
    "sql": "10_ken_all_r2ome.sql",
    "tableName": "ken_mst"
  },
  {
    "csv": "subway_stations.csv",
    "sql": "11_subway_stations.sql",
    "tableName": "subway_station_mst"
  }
]

Then write properties inside each of them.

Key and Value is meaning

| Key | Value | | --------- | ----------------------------------------- | | csv | Path to csv | | sql | Path to sql what generated from this tool | | tableName | Name of the table (Insert target) |