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

جواب «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.")

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