Storefront API using node js connected to a Postgres database.

A storefront backend to support connecting to a database and allow making changes to the database. the database has 4 tables:

• users
• products
• orders
• order_products

The application makes use of the following libraries:

• Postgres for the database
• Node/Express for the application logic
• dotenv from npm for managing environment variables
• db-migrate from npm for migrations
• jsonwebtoken from npm for working with JWTs
• jasmine from npm for testing

1. We use a docker container for the postgreSQL database. To create the container and setup the shopping database, run the docker-compose up --detach command in the terminal.
2. We create tables by running the npx db-migrate up command.
3. To start the server run the npm run start command from the terminal. The backend runs on port 3000, and the database on port 5432.

• Create all tables: npx db-migrate up
• Drop one table at a time: npx db-migrate up
• Drop all tables: npx db-migrate reset

• prettier: npm run prettier
• start: npm run start
• watch: npm run watch
• test: npm run test

1. To connect to the container we run docker exec -i -t storefront-backend_postgres_1 /bin/bash where storefront-backend_postgres_1 is the container name.
2. To connect to the postgreSQL database we run the following command in the terminal: psql shopping -h localhost -U shopping_user postgres where shopping is the POSTGRES_DB and shopping_user is the POSTGRES_USER.
3. To create the testing database run the SQL command CREATE DATABASE shopping_test where shopping_test is the testing database.

POSTGRES_HOST=127.0.0.1
POSTGRES_DB=shopping
POSTGRES_TEST_DB=shopping_test
POSTGRES_USER=shopping_user
POSTGRES_PASSWORD=password123
ENV=dev
BCRYPT_PASSWORD=secret
SALT_ROUNDS=10
TOKEN_SECRET=secrettoken

• PostgreSQL – Data Types
• Default Values
• Routing
• Docker PostgreSQL Tutorial with Persistent Data
• docker-compose up
• frequent-docker-commands.sh

• Shorouk Elkhateeb