Given two files app.js and a database file covid19India.db consisting of two tables state and district.
Write APIs to perform CRUD operations on the tables state, district containing the following columns,
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 |
Returns a list of all states in the state table
[
{
stateId: 1,
stateName: "Andaman and Nicobar Islands",
population: 380581
},
...
]
Returns a state based on the state ID
{
stateId: 8,
stateName: "Delhi",
population: 16787941
}
Create a district in the district table, district_id is auto-incremented
{
"districtName": "Bagalkot",
"stateId": 3,
"cases": 2323,
"cured": 2000,
"active": 315,
"deaths": 8
}
District Successfully Added
Returns a district based on the district ID
{
districtId: 322,
districtName: "Haveri",
stateId: 36,
cases: 2816,
cured: 2424,
active: 172,
deaths: 220,
}
Deletes a district from the district table based on the district ID
District Removed
Updates the details of a specific district based on the district ID
{
"districtName": "Nadia",
"stateId": 3,
"cases": 9628,
"cured": 6524,
"active": 3000,
"deaths": 104
}
District Details Updated
Returns the statistics of total cases, cured, active, deaths of a specific state based on state ID
{
totalCases: 724355,
totalCured: 615324,
totalActive: 99254,
totalDeaths: 9777
}
Returns an object containing the state name of a district based on the district ID
{
stateName: "Maharashtra"
}
Use npm install to install the packages.
Export the express instance using the default export syntax.
Use Common JS module syntax.