جواب «Step 3: The Leaderboard in Key-Value» چالش 6 از جلسهی 16
سؤال
(سختتر) قدم ۳: زیر کد قدم ۲، همهی ردیفهای scores را با sql("SELECT player, game, score FROM scores ORDER BY id") بخوان. برای هر ردیف کلید "best:" + game + ":" + player را بساز و فقط اگر امتیاز از kv.get(key, 0) بیشتر بود، با kv.set نگهش دار. بعد روی kv.keys("best:Snake:") حلقه بزن و هر کدام را مثل best:Snake:Ali = 95 چاپ کن (۶ خط، به ترتیب الفبای کلیدها). آخر از همه دقیقاً این را چاپ کن:SQL was the shortest: one query did the whole job.
راهنما
for player, game, score in sql(...): → key = "best:" + game + ":" + player → if score > kv.get(key, 0): kv.set(key, score). بعد for key in kv.keys("best:Snake:"): print(key, "=", kv.get(key)).
یک جواب درست
from db import show, sql, docs, kv
# Step 1: SQL
show("SELECT player, MAX(score) AS best FROM scores WHERE game = 'Snake' GROUP BY player ORDER BY best DESC, player")
# Step 2: documents
rows = sql("SELECT player, MAX(score) AS best FROM scores WHERE game = 'Snake' GROUP BY player ORDER BY best DESC, player")
for player, best in rows:
docs["board"].insert({"player": player, "best": best})
show(docs["board"].find().sort("best", -1).limit(3))
# Step 3: key-value
for player, game, score in sql("SELECT player, game, score FROM scores ORDER BY id"):
key = "best:" + game + ":" + player
if score > kv.get(key, 0):
kv.set(key, score)
for key in kv.keys("best:Snake:"):
print(key, "=", kv.get(key))
print("SQL was the shortest: one query did the whole job.")
اول خودت امتحان کن؛ جوابهای دیگر هم قبول است. برگرد و خودت حلش کن