Repository files navigation

Run 'npm install' or yarn

Create Database 'shopping' and 'shopping_test' in postgres

Create a new user in postgresEx: CREATE USER tom WITH PASSWORD 'myPassword';

Grant the new user all privileges on both the databasesEx: GRANT ALL PRIVILEGES ON DATABASE shopping to tom;GRANT ALL PRIVILEGES ON DATABASE shopping_test to tom;

This file will hold the data used to connect to the database as well as some other important variables.Please create one that matches the following example and channge the values to your own:

POSTGRES_HOST=127.0.0.1POSTGRES_DB=shoppingPOSTGRES_TEST_DB=shopping_testPOSTGRES_USER=postgresPOSTGRES_PASSWORD=pass123BCRYPT_PASSWORD=open-sesameSALT_ROUNDS=10TOKEN_SECRET=avadacadabraENV=dev

[note] Please updatedatabase.json accordig to the values in this file

run 'db-migrate up' to automatically create your database schema according to the one inREQUIREMENTS.md.

1. run 'npm run watch' or 'yarn watch' to launch the servver to listen on the API endpoints.
2. run 'npm run test' or 'yarn test' to run all tests of the project, please look at the notes at the end of the document before running this command.

The backend runs on port 3000The database runs on port 5432

Can be found with detailed documentation in theREQUIREMENTS.md file.Below is a link to a postman collection that successfully calls each endpoint of the API[Note:] You might need to generate a different bearer token to the one saved in the collection if you changed the TOKEN_SECRET variable in the .env file

Run in Postman

Please note that:

1. the [ENV] variable in the.env file needs to be manually updated to test before running 'npm run test'
2. If a test fails, please run 'db-migrate db:drop shopping_test' to drop the test database and run the command again.