Skip to content

Latest commit

 

History

History
70 lines (51 loc) · 1.47 KB

README.md

File metadata and controls

70 lines (51 loc) · 1.47 KB

Airline Reservation System REST API

Completed for the Database Systems module
Swagger REST API:
logo
logo
The modified ER diagram:
db

MySQL

  • Triggers
  • Functions
  • Views
  • Stored procedures
  • Indexing
  • Using transactions where necessary

The API

  • Node Express REST api
  • Using promises
  • API Documentation with Swagger(Open API 2.0)
  • Centralized error handling
  • Passwords hashing using bcrypt
  • Authentication with jwt
  • User input validation using hapi/joi
  • Uses promise-mysql and connection pooling
  • Load balancing using pm2 process management
  • Grafana for Realtime Report generation

Quick Start

  • Import the sql file at dbBackup folder to your mysql server

  • Add your database credentials to db.conf.json

  • Run the project in dev mode with nodemon- > npm run dev OR with node- > npm start

  • Install Grafana and import the dashboards

Install the dependencies

npm install

Run in development

Uses nodemon

npm dev

Deploy

Uses pm2

npm start

Collaborators