بتل کد Battle Codeدارد باز می‌شود…

جواب «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")

اول خودت امتحان کن؛ جواب‌های دیگر هم قبول است. برگرد و خودت حلش کن