SQL Generation
$ ./CSV_App sql
- This generates the SQL file in
data/db.sql
for the given CSV files - CSV Data is validated against the constraints provided in
schema.json
- Checkout the sample SQL file here
- Run following commands to create database and execute the
db.sql
file
$ psql -h localhost -U postgres -c 'CREATE DATABASE "DB_Name"'
$ psql -h localhost -U postgres -d "DB_Name" -f data/db.sql
data/appConfig.json
is also generated in this step.- Checkout the sample file here