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

جواب «Top Three, Your Way» چالش 6 از جلسه‌ی 19

سؤال

(سخت‌تر) مسیر GET /players/top سه بازیکن اول را می‌دهد (name، level، score، با LIMIT 3)، به ترتیبی که ?sort= می‌گوید. فقط این سه مجازند (در یک دیکشنری بگذارشان):
- name: به ترتیب اسم (ORDER BY name)
- score: بیشترین امتیاز اول (ORDER BY score DESC, name)
- level: بیشترین سطح اول (ORDER BY level DESC, name)

اگر sort نیامده بود، name. هر چیز دیگر: 400 با {"error": "sort must be one of: name, score, level"}. ?sort= را هرگز خودش داخل SQL نگذار. خروجی:
``
GET /players/top?sort=score → 200 OK
[
{"name": "Mina", "level": 9, "score": 2100},
{"name": "Yasmin", "level": 8, "score": 1800},
{"name": "Sara", "level": 7, "score": 1500}
]
GET /players/top?sort=level → 200 OK
[
{"name": "Mina", "level": 9, "score": 2100},
{"name": "Yasmin", "level": 8, "score": 1800},
{"name": "Sara", "level": 7, "score": 1500}
]
GET /players/top → 200 OK
[
{"name": "Ali", "level": 4, "score": 950},
{"name": "Mina", "level": 9, "score": 2100},
{"name": "Nima", "level": 5, "score": 1200}
]
GET /players/top?sort=age → 400 Bad Request
{"error": "sort must be one of: name, score, level"}
``

راهنما

if sort not in SORTS: abort(400, ...). بعد db.all(f"SELECT name, level, score FROM players ORDER BY {SORTS[sort]} LIMIT 3"): متنی که وارد SQL می‌شود از دیکشنری خودت است، نه از sort.

یک جواب درست

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);
''')

SORTS = {
    "name": "name",
    "score": "score DESC, name",
    "level": "level DESC, name",
}

@app.get("/players/top")
def top_players():
    sort = request.args.get("sort", "name")
    if sort not in SORTS:
        abort(400, "sort must be one of: name, score, level")
    return db.all(f"SELECT name, level, score FROM players ORDER BY {SORTS[sort]} LIMIT 3")

ask("GET /players/top?sort=score")
ask("GET /players/top?sort=level")
ask("GET /players/top")
ask("GET /players/top?sort=age")

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