Storefront-Backend

Required Technologies

The application must make use of the following libraries:

• postgres as the database
• express for running the server
• dotenv for environment variables
• db-migrate for migrations
• jsonwebtoken for authentication purpose
• jasmine for testing

Running scripts

# Installing dependencies
npm i

# To transpile the TypeScript
npm run build

# To clear the build file
npm run clean

# To start the server
npm start

# To format files using prettier
npm run prettier

# To check for errors
npm run lint

# To run test suite
npm run test

Plan to meet requirements (Endpoints & database schema)

In this repo there is a REQUIREMENTS.md document which outlines what this API needs to supply for the frontend, as well as the agreed upon data shapes to be passed between front and backend. This is much like a document you might come across in real life when building or extending an API.

Database creation

# Create user
CREATE USER nourbeh WITH PASSWORD '123456789';

# Create database
CREATE DATABASE storefront_dev;
CREATE DATABASE storefront_test;

# Grant all database privileges to the user
GRANT ALL PRIVILEGES ON DATABASE storefront_dev TO nourbeh;
GRANT ALL PRIVILEGES ON DATABASE storefront_test TO nourbeh;

Database migrations

# To create the data schema tables run this command
db-migrate up

# To drop the data schema tables run this command
db-migrate down

# To drop all database tables with single command
db-migrate reset

# Migrations used in the project
db-migrate create users-table --sql-file
db-migrate create products-table --sql-file
db-migrate create orders-table --sql-file
db-migrate create orders_products-table --sql-file

.env

# To connect with the database, use the following .env variables
SERVER_PORT=8000
DATABASE_PORT=5432
POSTGRES_HOST=127.0.0.1
POSTGRES_DB=storefront_dev
POSTGRES_DB_TEST=storefront_test
POSTGRES_USER=nourbeh
POSTGRES_PASSWORD=123456789
ENV=dev
SALT_ROUNDS=10
SECRET_TOKEN=helloworld