This is a querybuilder intended to generate SQL queries for postgreSQL while relying on the node-postgres npm package to execute the queries.
git clone https://github.com/maqui7295/node-postgres-querybuilder
cd node-postgres-querybuilder
yarn install
Next, install postgresql on your local machine and on the terminal, create a database using
set PGUSER=postgres
createdb dbname
Or you can use pgAdmin to manage your postgreSQL backend. You can find more information here
To run the application, cd into the root directory and run
yarn start
The above command yarn start creates the tables and populate it with some dummy data because it runs
yarn run initdb
Tests, both unit and integration written with Jasmine and supertest can be run with
yarn test