جواب «Remove a Player» چالش 3 از جلسهی 19
سؤال
مسیر DELETE /players/<int:pid> را بساز: با DELETE و ? پاک کن؛ اگر .changed صفر بود 404 با {"error": "no player with id 4"}، وگرنه 204 بدون بدنه. مسیر شمارش آماده است. خروجی:
````
DELETE /players/4 → 204 No Content
DELETE /players/4 → 404 Not Found
{"error": "no player with id 4"}
GET /players/count → 200 OK
{"count": 6}
راهنما
done = db.run("DELETE FROM players WHERE id = ?", (pid,))؛ if done.changed == 0: abort(404, ...)؛ return "", 204.
یک جواب درست
from server import app, ask, db, request, abort
db.script('''
CREATE TABLE players (id INTEGER PRIMARY KEY, name TEXT, level INTEGER, score INTEGER);
INSERT INTO players (name, level, score) VALUES ('Sara', 7, 1500), ('Ali', 4, 950), ('Mina', 9, 2100);
INSERT INTO players (name, level, score) VALUES ('Reza', 2, 300), ('Nima', 5, 1200), ('Yasmin', 8, 1800);
INSERT INTO players (name, level, score) VALUES ('Omid', 6, 1100);
''')
@app.get("/players/count")
def count_players():
return {"count": db.value("SELECT COUNT(*) FROM players")}
@app.delete("/players/<int:pid>")
def remove_player(pid):
done = db.run("DELETE FROM players WHERE id = ?", (pid,))
if done.changed == 0:
abort(404, f"no player with id {pid}")
return "", 204
ask("DELETE /players/4")
ask("DELETE /players/4")
ask("GET /players/count")
اول خودت امتحان کن؛ جوابهای دیگر هم قبول است. برگرد و خودت حلش کن