Skip to content

Database Oriented Design For Airline Reservation system

License

Notifications You must be signed in to change notification settings

rumeshmadhusanka/DB-API

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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