Skip to content

Latest commit

 

History

History
36 lines (28 loc) · 1.49 KB

README.md

File metadata and controls

36 lines (28 loc) · 1.49 KB
Raw

Welcome to Flights Service

Project Setup

  • Clone the project on your local
  • Execute npm install on the same path as of your root directory of the downloaded project.
  • Create a .env file in the root directory and add the following environment variable
    • PORT = 3000
    • DB_SYNC = true (Required only once after setting up associations, once done can change it to false).
  • Inside the src/config folder create a new file config.json and then add the following piece of json in it.
{

  "development": {
    "username": <YOUR_DB_USERNAME>,
    "password": <YOUR_DB_PASSWORD>,
    "database": "Flights_Search_DB_Dev",
    "host": "127.0.0.1",
    "dialect": "mysql"
  },
  
}
  • Once you have added you db config as listed above, go to the src folder from your terminal and execute npx sequelize db:create and then execute npx sequelize db:migrate.

Tables

  • City - id, name, updatedAt, createdAt
  • Airport - id, name, address, cityId, updatedAt, createdAt
    • Relationship - City has multiple airports and Airport belongs to a city. (one to many relationship).

  • Airplane - id, modleName, capacity, updatedAt, createdAt

  • Flights - id, flightName, airplaneId, arrivalAirportId, departureAirportId, arrivalTime, departureTime, totalSeats, price, boardingGate, createdAt, updatedAt.