backend_repo v1.0.0

EngageXr coding assignment

This project contains the backend code for the EngageXr coding assigment.

Features covered

• Used Typescript in the project
• Implemented Sequelize
• ROle based access JWT authentication for admin, company and user
• Used Node, Express, Sequelize, JWT, ESlint, Winston Logger, express-validator, module aliasing, postrgres
• Created Express routing to demonstrate CRUD functionality (Create / Read / Update / Delete) for two API items: Companies and Employees
• Used Express validation middleware to demonstrate basic payload validation
• Used Express middleware for authorising to enforce authorisation,company or user,
• Companies DB table consists of these fields: Name (required), email, phone, website
• Employees DB table consists of these fields: First name (required), last name (required), Company (foreign key to Companies), email, phone
• User DB table (Additional table to enforce log in as admin functionality)

Important Instructions

• This project is built with postgres as database choice. Please setup postgres in the system before installing and running the project.
• After installing postgres in the system, create a database inside names ad metaseq.
• Once you setup your postgres database you need to set the database name, username, password in src/configs/sequelizeconfig.ts file

• All api reference is given in bellow and to ease API testing there is a POSTMAN api JSON file added in the root of the project (/postman/engagexr-apis.postman_collection.json) directory. Import this file in the POSTMAN application and test the API with pre-loaded data. More info about API's is given in the API Reference section.

• you can find the server logs under consoleLogs folder under the src directory.

Environment Variables

To run this project, you will need to add the following environment variables to your .env file

SECRET="shah@123"

Run Locally

Clone the project

  git clone -b main https://github.com/shahahmedp/engageXR-.git

Go to the project directory

  cd engageXRBackedn

Install dependencies

  yarn install

Run the server locally in development

  yarn run dev

Build

  yarn run build

Start

Run the server after running the build.

  yarn start

Tech Stack

Server: Node, Express, Sequelize, JWT, Eslint, prettier, Winston

API Reference

Auth API

Signup user

  POST http://localhost:3000/api/auth/signup

Signin user

  POST http://localhost:3000/api/auth/signin

Company API

All the company API requires Authorisation header containing Bearer Token(x-access-token)

• use the Signin API shown above to generate the token. | Headers | Type | value | | :-------- | :------- | :------------------------- | | Content-Type | string | application/json. | | Authorization | string | Bearer x-access-token. |

Create a new company

  POST http://localhost:3000/api/post/cmpy

Get all companies

  GET http://localhost:3000/api/get/cmpy

Get company by company id.

  GET http://localhost:3000/api/getbyid/cmpy/:name

Update company by company id.

  PUT http://localhost:3000/api/putbyid/cmpy/:companyId

Delete company by company id.

  DELETE http://localhost:3000/api/deleteById/cmpy:companyId

Employee API

All the employee API requires Authorisation header containing Bearer Token and Content-Type header

• use the Signin API shown above to generate the token. | Headers | Type | value | | :-------- | :------- | :------------------------- | | Content-Type | string | application/json. | | Authorization | string | Bearer x-access-token. |

Create a new employee

  POST http://localhost:3000/api/post/emp

Get all employees

  GET http://localhost:3000/api/get/emp

Get employee by employee id.

  GET http://localhost:3000/api/getbyid/emp/:employeeId

Get employee by company id.

  GET http://localhost:3000/api/company/:companyId/employees

Update employee by employee id.

  put http://localhost:3000/api/putbyid/emp/:employeeId

Delete employee by employee id.

  DELETE http://localhost:3000/api/deleteById/emp/:employeeId

Author

• XXXXXXXX ()