-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.js
84 lines (79 loc) · 2.39 KB
/
app.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
const express = require("express");
const { open } = require("sqlite");
const path = require("path");
const sqlite3 = require("sqlite3");
const dbPath = path.join(__dirname, "cricketTeam.db");
const app = express();
app.use(express.json());
let db = null;
const initializeDbAndServer = async () => {
try {
db = await open({
filename: dbPath,
driver: sqlite3.Database,
});
app.listen(3000, () => {
console.log("Server is Running http://localhost:3000");
});
} catch (e) {
console.log(`DB error ${e.message}`);
process.exit(1);
}
};
initializeDbAndServer();
const covertDbIntoResponse=(dbObject)=>{
return {
playerId:dbObject.player_Id,
playerName:dbObject.player_name,
jerseyNumber:dbObject.jerseyNumber,
role:dbObject.role
}
}
//API 1
app.get("/players/", async (request, response) => {
const getAllPlayers = `SELECT * FROM cricket_team`;
const allPlayers = await db.all(getAllPlayers);
response.send(allPlayers.map((eachPlayer)=>
covertDbIntoResponse(eachPlayer)
);
)
});
//API 2
app.post("/players/",async(request,response)=>{
const {playerName,jerseyNumber,role}=request.body
const postPlayerQuery=`
INSERT INTO cricket_team (playerName,jerseyNumber,role)
VALUES ('${playerName}',${jerseyNumber},'${role}')`;
const player = await db.run(postPlayerQuery)
response,send("Player Added to Team")
//API 3
app.get("/players/:playerId/",async(request,response)=>{
const {playerId}=request.params
const getPlayerQuery=`SELECT * FROM cricket_team
WHERE player_id=${playerId}`
const player= await db.get(getPlayerQuery)
response.send(covertDbIntoResponse(player))
//API 4
app.put("/players/:playerId/",async(request,response)=>{
const {playerId}=request.params;
const {playerName,jerseyNumber,role}=request.body
const updatePlayerQuery=`
UPDATE cricket_team
SET
player_name='${playerName}',
jersey_number='${jerseyNumber}',
role=${role}
WHERE player_id=${playerId}`
await db.run(updatePlayerQuery)
response.send ("Player Details Updated")
})
//API 5
app.delete("/players/:playersId/",async(request,response)=>{
const {playerId}=request.params;
const deletePlayerQuery=`
DELETE FROM cricket_team
where player_id=${playerId}`
await db.run(deletePlayerQuery)
response.send("Player Removed")
})
module.exports=app