Skip to content

Latest commit

 

History

History
37 lines (23 loc) · 995 Bytes

README.md

File metadata and controls

37 lines (23 loc) · 995 Bytes
Raw

Metro-Out-Performance

"Metro Out Performance" is a small engine in which .csv file is read using Express.js and dumped into SQlite3.

1- Creates schema of ORDER table and METRO_AREAS table in SQlite3. 2- Reads from .csv using Node.js and Express.js. 3- Inserts read csv data into mentioned tables.

INSTRUCTIONS:

  • Open cmd in ROOT directory and type:

          npm install

  • Open cmd in "api/" directory and type:

          node server.js

  • Use POSTMAN for APIs calls testing and run below APIs.

          To dump data in  Metro_Area table from .csv to sqlite:
      http://localhost:3007/metro_areas

      To dump data in  ORDER table from .csv to sqlite:
      http://localhost:3007/orders

      To check Metro_Area output from SQlite3
      http://localhost:3007/showMetro

      To check ORDER output from SQlite3
      http://localhost:3007/showOrders

TECHNOLOGIES:

  • Node.js
  • Express.js
  • SQlite3