Skip to content

tejaramgv/tej

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Cricket Team

Given two files app.js and a database file cricketTeam.db consisting a table cricket_team.

Write APIs to perform operations on the table cricket_team containing the following columns,

Columns Type
player_id INTEGER
player_name TEXT
jersey_number INTEGER
role TEXT

API 1

Path: /players/

Method: GET

Description:

Returns a list of all players in the team

Response

[
  {
    playerId: 1,
    playerName: "Lakshman",
    jerseyNumber: 5,
    role: "All-rounder"
  },

  ...
]

API 2

Path: /players/

Method: POST

Description:

Creates a new player in the team (database). player_id is auto-incremented

Request

{
  "playerName": "Vishal",
  "jerseyNumber": 17,
  "role": "Bowler"
}

Response

Player Added to Team

API 3

Path: /players/:playerId/

Method: GET

Description:

Returns a player based on a player ID

Response

{
  playerId: 1,
  playerName: "Lakshman",
  jerseyNumber: 5,
  role: "All-rounder"
}

API 4

Path: /players/:playerId/

Method: PUT

Description:

Updates the details of a player in the team (database) based on the player ID

Request

{
  "playerName": "Maneesh",
  "jerseyNumber": 54,
  "role": "All-rounder"
}

Response

Player Details Updated

API 5

Path: /players/:playerId/

Method: DELETE

Description:

Deletes a player from the team (database) based on the player ID

Response

Player Removed

Use npm install to install the packages.

Export the express instance using the default export syntax.

Use Common JS module syntax.

nxt

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published