Installation Procedures (Local Setup)
- Install node.js, npm and postgres
- Run 'npm install'
- Run the following sql script (setupRole.sql) from sql shell as a superuser using the default account created during setup
- Rerun sql shell and enter as the user "me" with password "password"
- Run the following sql script (setupDatabase.sql) to set up the database and populate with mock data
- Run 'npm start' to start the server
- Update the values in config.ts and database.ts
- Refer to requests.http for some sample requests
Useful Database commands