Coding Practice 10

 

Covid-19 India Portal

Given two files

app.js

and a database file

covid19IndiaPortal.db

consisting of three tables

state

,

district

and

user

.

Write APIs to perform operations on the tables

state

,

district

only after authentication of the user.

The columns of the tables are given below,

State Table

Columns	Type
state_id	INTEGER
state_name	TEXT
population	INTEGER

District Table

Columns	Type
district_id	INTEGER
district_name	TEXT
state_id	INTEGER
cases	INTEGER
cured	INTEGER
active	INTEGER
deaths	INTEGER

You can use your previous code if required.

Sample Valid User Credentials

{

"username": "christopher_phillips",

"password": "christy@123"

}

API 1

Path: 

/login/

Method: 

POST

Request

{

"username": "christopher_phillips",

"password": "christy@123"

}

• Scenario 1

  • Description:

    If an unregistered user tries to login

  • Response

    • Status code
      400
    • Body
      Invalid user

• Scenario 2

  • Description:

    If the user provides an incorrect password

  • Response

    • Status code
      400
    • Body
      Invalid password

• Scenario 3

  • Description:

    Successful login of the user

  • Response

    Return the JWT Token

    {

    "jwtToken": "ak2284ns8Di32......"

    }

Authentication with Token

• Scenario 1

  • Description:

    If the token is not provided by the user or an invalid token

  • Response

    • Status code
      401
    • Body
      Invalid JWT Token

• Scenario 2 After successful verification of token proceed to next middleware or handler

API 2

Path: 

/states/

Method: 

GET

Description:

Returns a list of all states in the state table

Response

[

{

"stateId": 1,

"stateName": "Andaman and Nicobar Islands",

"population": 380581

},

...

]

API 3

Path: 

/states/:stateId/

Method: 

GET

Description:

Returns a state based on the state ID

Response

{

"stateId": 8,

"stateName": "Delhi",

"population": 16787941

}

API 4

Path: 

/districts/

Method: 

POST

Description:

Create a district in the district table,

district_id

is auto-incremented

Request

{

"districtName": "Bagalkot",

"stateId": 3,

"cases": 2323,

"cured": 2000,

"active": 315,

"deaths": 8

}

Response

District Successfully Added

API 5

Path: 

/districts/:districtId/

Method: 

GET

Description:

Returns a district based on the district ID

Response

{

"districtId": 322,

"districtName": "Palakkad",

"stateId": 17,

"cases": 61558,

"cured": 59276,

"active": 2095,

"deaths": 177

}

API 6

Path: 

/districts/:districtId/

Method: 

DELETE

Description:

Deletes a district from the district table based on the district ID

Response

District Removed

API 7

Path: 

/districts/:districtId/

Method: 

PUT

Description:

Updates the details of a specific district based on the district ID

Request

{

"districtName": "Nadia",

"stateId": 3,

"cases": 9628,

"cured": 6524,

"active": 3000,

"deaths": 104

}

Response

District Details Updated

API 8

Path: 

/states/:stateId/stats/

Method: 

GET

Description:

Returns the statistics of total cases, cured, active, deaths of a specific state based on state ID

Response

{

"totalCases": 724355,

"totalCured": 615324,

"totalActive": 99254,

"totalDeaths": 9777

}

Use

npm install

to install the packages.

Export the express instance using the default export syntax.

Use Common JS module syntax.