def get_decks_from_database(keyword): cursor = get_cursor() cursor.execute(""" SELECT keyword_id, keyword, json, terms_selected/GREATEST(times_deck_selected,1) as avg_selected FROM Keywords NATURAL JOIN KeywordsQuizletDecks NATURAL JOIN QuizletDecks WHERE keyword = %s """, (keyword,)) decks = make_dicts(cursor, cursor.fetchall()) cursor.close() for deck in decks: try: deck["json"] = to_object(deck["json"]) except JSONDecodeError: pass return decks
def get_decks_from_database(user_id): cursor = get_cursor() output = cursor.execute(""" SELECT json FROM UserDecks WHERE user_id = %s """, (user_id,)) decks = make_dicts(cursor, cursor.fetchall()) cursor.close() for deck in decks: try: deck["json"] = to_object(deck["json"]) except JSONDecodeError: pass return decks