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

District Table

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.