Given two files app.js and a database file cricketMatchDetails.db consisting of three tables player_details, match_details and player_match_score.
Write APIs to perform operations on the tables player_details, match_details and player_match_score containing the following columns,
Player Details Table
| Column | Type |
|---|---|
| player_id | INTEGER |
| player_name | TEXT |
Match Details Table
| Column | Type |
|---|---|
| match_id | INTEGER |
| match | TEXT |
| year | INTEGER |
Player Match Score Table
| Column | Type |
|---|---|
| player_match_id | INTEGER |
| player_id | INTEGER |
| match_id | INTEGER |
| score | INTEGER |
| fours | INTEGER |
| sixes | INTEGER |
Returns a list of all the players in the player table
[
{
playerId: 1,
playerName: "Ram"
},
...
]
Returns a specific player based on the player ID
{
playerId: 2,
playerName: "Joseph"
}
Updates the details of a specific player based on the player ID
{
"playerName": "Raju"
}
Player Details Updated
Returns the match details of a specific match
{
matchId: 18,
match: "RR vs SRH",
year: 2011
}
Returns a list of all the matches of a player
[
{
matchId: 1,
match: "SRH vs MI",
year: 2016
},
...
]
Returns a list of players of a specific match
[
{
playerId: 2,
playerName: "Joseph"
},
...
]
Returns the statistics of the total score, fours, sixes of a specific player based on the player ID
{
playerId: 1,
playerName: "Ram"
totalScore: 3453,
totalFours: 342,
totalSixes: 98
}
Use npm install to install the packages.
Export the express instance using the default export syntax.
Use Common JS module syntax.