/backend-starter-server

backend-server for Authentication & authorization with NodeJs & TypesCript powered by ExpressJs & PostgresSQL

Primary LanguageTypeScript

Authorization & authentication Backend server Project

Getting Started

  • how to setup and connect to the database
  • what ports the backend and database are running on
  • package installation instructions

API Description

The Server is Built to make an Authorization Layer for the users can be used as a start for any project or can be used seperatly to be an autorization & authentication layer for any upcoming project or group of projects at the same time

the project can be easy editing the datbase rules & update db-migration Ups in the files & tested localy first before deploying & integrations...

API Endpoints

Users

# Method Endpoint Route Authorization Located
1 GET Index(GET All Users) /users required userController
2 GET Show(GET user by ID) /users/:id required userController
3 POST Create(User Register) /users/register not required userController
4 GET Read(User Login) /users/login not required userController
5 GET Auth(User Check Authorization) /users/auth not required userController

Data Shapes

User

# Column Name Type Description
1 id SERIAL PRIMARY KEY indexing
2 userid VARCHAR(50) Uniqe Id for the user
3 firstName VARCHAR(30) first of the user
4 lastName VARCHAR(30) last of the user
5 Phone VARCHAR(30) user phone Number
6 email VARCHAR(100) Email of the user
7 username VARCHAR(50) for selecting information
8 password text hash pass for user account

setup project

  • first clone the project to your own machine
  • create the dotenv file containg the following vars :-
POSTGRES_HOST=...
POSTGRES_DB=...
POSTGRES_TEST_DB=...
POSTGRES_USER=...
POSTGRES_PASSWORD=...
ENV=dev
BCRYPT_PASSWORD=...
SALT_ROUNDS=...
ACCESS_TOKEN_SEECRET=...
PORT=...
JWT_EXPIRES=...
  • then start installing the neccessary packages with this command npm install .

database SetUp

  • now we will connect to the database with docker so we will init the container with this command to create the databse docker compose up in the root directory of your project .
  • now we have our databse container run command docker compose down
  • then init it again from the docker GUI
  • now execut the container from the the cli option for this container from the docker dashboard GUI.
  • we need now to create the user & init the db we add it in the .env file:-
  • init command psql postgres to enter the psql environment
  • init command CREATE USER // POSTEGRES_USER WITH PASSWORD POSTGRES_PASSWORD; to create user
  • init commands CREATE DATABSE // POSTGRES_DB; CREATE DATABSE // POSTGRES_TEST_DB;
  • init commands GRANT ALL PRIVILEGES ON DATABASE // POSTGRES_DB TO // POSTGRES_USER; GRANT ALL PRIVILEGES ON DATABASE // POSTGRES_TEST_DB TO // POSTGRES_USER ;
  • connect to db by initing command \c // POSTGRES_DB Or \c // POSTGRES_TEST_DB
  • your database is ready for deveolpment now
  • look for the scripts in the package.json and start testing...

Project Ports

  • for the backend port i leave it optional to you to add the port you like... in the PORT variable.

  • for the database port in the docker-compose file it runs on '5432:5432'

Packages installation

  • an easy command we use it to install the dev and the producations packages in parallel way is npm install .

DotEnv file Setup

POSTGRES_HOST=localhost
POSTGRES_DB=postgres
POSTGRES_TEST_DB=postgres
POSTGRES_USER=postgres
POSTGRES_PASSWORD=12345
ENV=dev
BCRYPT_PASSWORD=bebars
SALT_ROUNDS=12
ACCESS_TOKEN_SEECRET=bebars
PORT=5000
JWT_EXPIRES=1d