rapid_it coding assignment

This project contains the backend code for the rapid_it 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

| key | Type | Description | | :--------- | :------- | :---------------------------------| | database | string | Your postgres database name. | | username | string | Your username | | password | string | Your password. |

• 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/rapid_it-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/rapid_it-.git

Go to the project directory

  cd rapid_itBackedn

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

| Body Payload | Type | Description | | :----------- | :------- | :----------------------------------------- | | username | string | Required. | | email | string | Required. | | password | string | Required. | | role | array of strings | OPTIONAL: Admin/Company/user. Defaults. GUEST |

Signin user

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

| Body Payload | Type | Description | | :----------- | :------- | :------------ | | username | string | Required. | | password | string | Required. |

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

| Body Payload | Type | Description | | :----------- | :------- | :------------ | | name | string | Required. | | email | string | Required. | | phone | string | OPTIONAL. | | website | string | OPTIONAL. |

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Get all companies

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

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Get company by company id.

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

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Update company by company id.

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

| Body Payload | Type | Description | | :----------- | :------- | :------------ | | name | string | OPTIONAL. | | email | string | OPTIONAL. | | phone | string | OPTIONAL. | | website | string | OPTIONAL. |

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Delete company by company id.

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

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

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

| Body Payload | Type | Description | | :----------- | :------- | :------------ | | cmpID | string | Required. | | firstName | string | Required. | | lastName | string | Required. | | email | string | Required. | | phone | string | OPTIONAL. |

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Get all employees

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

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Get employee by employee id.

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

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Get employee by company id.

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

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Update employee by employee id.

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

| Body Payload | Type | Description | | :----------- | :------- | :------------ | | firstName | string | OPTIONAL. | | lastName | string | OPTIONAL. | | email | string | OPTIONAL. | | phone | string | OPTIONAL. |

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Delete employee by employee id.

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

| Headers | Type | Description | | :-------------- | :------- | :------------ | | Content-Type | string | Required. | | Authorization | string | Required. |

Author

• XXXXXXXX ()