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
