def get_user_stats(username): db = sqlite3.connect(db_name) c = db.cursor() username = username.replace("'", "''") command = "SELECT username, pfp, best_img_id, worst_img_id, guesser_score, artist_score FROM users WHERE username = '******';" % username c.execute(command) user_as_tuple = c.fetchone() number_drawings = len(c.execute("SELECT id FROM drawings WHERE username = '******';" % username).fetchall()) db.close() if user_as_tuple != None: user_stats = tuple_to_dictionary(user_as_tuple, ["username", "pfp", "best_image", "worst_image", "guesser_score", "artist_score"]) user_stats["best_image"] = draw.get_image(user_stats["best_image"]) user_stats["worst_image"] = draw.get_image(user_stats["worst_image"]) user_stats["number_drawings"] = number_drawings return user_stats return {}
def get_guess(username, drawing_id): for guess in draw.get_image(drawing_id)["guesses"]: if guess["username"] == username: return guess["guess"] return None
def get_answer(drawing_id): return draw.get_image(drawing_id)["word"]
def who_guessed_it(drawing_id): return draw.get_image(drawing_id)["guesses"][-1]["username"]
def get_num_guesses(drawing_id): image = draw.get_image(drawing_id) if image["solved"] == True: return len(image["guesses"]) - 1 return len(image["guesses"])
def get_artist(drawing_id): return draw.get_image(drawing_id)["artist"]