جواب «Step 2: Answers With a Token» چالش 5 از جلسهی 32
سؤال
(سختتر) قدم ۲: کد قدم ۱ را ادامه بده. بالای درخواستها اینها را اضافه کن:
1. db.run("CREATE TABLE answers (user TEXT, qid INTEGER, correct INTEGER)").
2. یک @app.before که فقط برای مسیر /api/v1/answer: اگر request.token در tokens نیست، {"error": "log in first"}, 401 برگرداند؛ وگرنه request.user = tokens[request.token].
3. مسیر POST /api/v1/answer با {"id": ..., "choice": ...}: اگر سؤال نیست، 404 با {"error": "no such question"}؛ اگر این کاربر قبلاً همین سؤال را جواب داده، 409 با {"error": "you already answered this question"}؛ وگرنه یک ردیف (correct برابر ۱ یا ۰) در answers بگذار و {"correct": true/false, "score": ...} برگردان که score مجموع جوابهای درست همین کاربر است (SUM).
بعد آخر برنامه این خطها را اضافه کن:
``python`
sara = {"Authorization": "Bearer " + r.json["token"]}
ask("POST /api/v1/answer", {"id": 1, "choice": 2})
ask("POST /api/v1/answer", {"id": 1, "choice": 2}, headers={"Authorization": "Bearer fake"})
ask("POST /api/v1/answer", {"id": 1, "choice": 2}, headers=sara)
ask("POST /api/v1/answer", {"id": 2, "choice": 3}, headers=sara)
ask("POST /api/v1/answer", {"id": 1, "choice": 1}, headers=sara)
ask("POST /api/v1/answer", {"id": 9, "choice": 1}, headers=sara){"correct": true, "score": 1}
جوابها به ترتیب: 401، 401، ، {"correct": false, "score": 1}`، 409 و 404.
راهنما
در before: if request.path == "/api/v1/answer": و داخلش if request.token not in tokens: return {...}, 401. در مسیر: q = db.one("SELECT answer FROM questions WHERE id = ?", qid)؛ برای تکراری db.one("SELECT qid FROM answers WHERE user = ? AND qid = ?", (request.user, qid))؛ بعد correct = choice == q["answer"]، INSERT با int(correct)، و db.value("SELECT SUM(correct) FROM answers WHERE user = ?", request.user).
یک جواب درست
from server import app, ask, request, abort, db, hash_password, check_password, new_token
db.script("""
CREATE TABLE questions (id INTEGER PRIMARY KEY, text TEXT, c1 TEXT, c2 TEXT, c3 TEXT, answer INTEGER);
INSERT INTO questions (text, c1, c2, c3, answer) VALUES
('Which code means Not Found?', '200', '404', '500', 2),
('Which method makes a new thing?', 'POST', 'GET', 'DELETE', 1),
('What do APIs usually send?', 'Photos', 'Python', 'JSON', 3);
CREATE TABLE users (name TEXT PRIMARY KEY, hash TEXT);
""")
tokens = {}
@app.post("/api/v1/signup")
def signup():
data = request.json or {}
name = data.get("name")
password = data.get("password")
if not name or not password:
abort(400, "name and password are required")
if db.one("SELECT name FROM users WHERE name = ?", name):
abort(409, "this name is taken")
db.run("INSERT INTO users (name, hash) VALUES (?, ?)", (name, hash_password(password)))
return {"name": name}, 201
@app.post("/api/v1/login")
def login():
data = request.json or {}
user = db.one("SELECT name, hash FROM users WHERE name = ?", data.get("name", ""))
if user is None or not check_password(data.get("password", ""), user["hash"]):
abort(401, "wrong name or password")
token = new_token()
tokens[token] = user["name"]
return {"token": token}
db.run("CREATE TABLE answers (user TEXT, qid INTEGER, correct INTEGER)")
@app.before
def guard():
if request.path == "/api/v1/answer":
if request.token not in tokens:
return {"error": "log in first"}, 401
request.user = tokens[request.token]
@app.post("/api/v1/answer")
def answer():
data = request.json or {}
qid = data.get("id")
choice = data.get("choice")
if not isinstance(qid, int) or not isinstance(choice, int):
abort(400, "send id and choice as numbers")
q = db.one("SELECT answer FROM questions WHERE id = ?", qid)
if q is None:
abort(404, "no such question")
if db.one("SELECT qid FROM answers WHERE user = ? AND qid = ?", (request.user, qid)):
abort(409, "you already answered this question")
correct = choice == q["answer"]
db.run("INSERT INTO answers (user, qid, correct) VALUES (?, ?, ?)", (request.user, qid, int(correct)))
score = db.value("SELECT SUM(correct) FROM answers WHERE user = ?", request.user)
return {"correct": correct, "score": score}
ask("POST /api/v1/signup", {"name": "Sara", "password": "cat123"})
ask("POST /api/v1/signup", {"name": "Sara", "password": "dog456"})
ask("POST /api/v1/signup", {"name": "Ali"})
ask("POST /api/v1/login", {"name": "Sara", "password": "nope"})
r = ask("POST /api/v1/login", {"name": "Sara", "password": "cat123"}, quiet=True)
print(r.status, len(r.json["token"]))
sara = {"Authorization": "Bearer " + r.json["token"]}
ask("POST /api/v1/answer", {"id": 1, "choice": 2})
ask("POST /api/v1/answer", {"id": 1, "choice": 2}, headers={"Authorization": "Bearer fake"})
ask("POST /api/v1/answer", {"id": 1, "choice": 2}, headers=sara)
ask("POST /api/v1/answer", {"id": 2, "choice": 3}, headers=sara)
ask("POST /api/v1/answer", {"id": 1, "choice": 1}, headers=sara)
ask("POST /api/v1/answer", {"id": 9, "choice": 1}, headers=sara)
اول خودت امتحان کن؛ جوابهای دیگر هم قبول است. برگرد و خودت حلش کن