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

جواب «Page by Page» چالش 5 از جلسه‌ی 19

سؤال

(سخت‌تر) مسیر GET /players را با صفحه‌بندی بساز: هر صفحه ۳ بازیکن، به ترتیب id، فقط name و score، با LIMIT ? OFFSET ?. صفحه از ?page= می‌آید و اگر نیامده بود 1 است. اگر عدد صحیح نبود: 400 با {"error": "page must be a whole number"}؛ اگر کمتر از ۱ بود: 400 با {"error": "page starts at 1"}. جواب: {"page": ..., "items": [...]}. خروجی:
``
GET /players?page=2 → 200 OK
{"page": 2, "items": [{"name": "Reza", "score": 300}, {"name": "Nima", "score": 1200}, {"name": "Yasmin", "score": 1800}]}
GET /players?page=3 → 200 OK
{"page": 3, "items": [{"name": "Omid", "score": 1100}]}
GET /players → 200 OK
{"page": 1, "items": [{"name": "Sara", "score": 1500}, {"name": "Ali", "score": 950}, {"name": "Mina", "score": 2100}]}
GET /players?page=abc → 400 Bad Request
{"error": "page must be a whole number"}
GET /players?page=0 → 400 Bad Request
{"error": "page starts at 1"}
``

راهنما

try: page = int(request.args.get("page", "1")) و except ValueError: abort(400, ...). بعد if page < 1: abort(400, ...). آخر db.all("SELECT name, score FROM players ORDER BY id LIMIT ? OFFSET ?", (SIZE, (page - 1) * SIZE)).

یک جواب درست

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

SIZE = 3

@app.get("/players")
def list_players():
    try:
        page = int(request.args.get("page", "1"))
    except ValueError:
        abort(400, "page must be a whole number")
    if page < 1:
        abort(400, "page starts at 1")
    rows = db.all("SELECT name, score FROM players ORDER BY id LIMIT ? OFFSET ?", (SIZE, (page - 1) * SIZE))
    return {"page": page, "items": rows}

ask("GET /players?page=2")
ask("GET /players?page=3")
ask("GET /players")
ask("GET /players?page=abc")
ask("GET /players?page=0")

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