Skip to main content

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