جواب «New High Score» چالش 2 از جلسهی 19
سؤال
مسیر PATCH /players/<int:pid> را بساز: امتیاز (score) را از بدنه بگیر، با UPDATE و ? عوض کن، اگر .changed صفر بود 404 با {"error": "no player with id 9"} (با همان شماره) بده، وگرنه ردیف کامل تازه را برگردان. خروجی:
````
PATCH /players/2 → 200 OK
{"id": 2, "name": "Ali", "level": 4, "score": 1000}
PATCH /players/9 → 404 Not Found
{"error": "no player with id 9"}
راهنما
UPDATE players SET score = ? WHERE id = ?. بعد if done.changed == 0: abort(404, ...) و return db.one("SELECT * FROM players WHERE id = ?", (pid,)).
یک جواب درست
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.patch("/players/<int:pid>")
def change_score(pid):
score = request.json["score"]
done = db.run("UPDATE players SET score = ? WHERE id = ?", (score, pid))
if done.changed == 0:
abort(404, f"no player with id {pid}")
return db.one("SELECT * FROM players WHERE id = ?", (pid,))
ask("PATCH /players/2", {"score": 1000})
ask("PATCH /players/9", {"score": 5})
اول خودت امتحان کن؛ جوابهای دیگر هم قبول است. برگرد و خودت حلش کن