def update_flashcard(id):
answer = request.form['answer']
question = request.form['question']
deck = deck_repository.select(request.form['deck_id'])
flashcard = Flashcard(answer, question, deck, id)
flashcard_repository.update(flashcard)
return redirect('/flashcards')
def select(id):
flashcard = None
sql = "SELECT * FROM flashcards WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
deck = deck_repository.select(result['deck_id'])
flashcard = Flashcard(result['answer'], result['question'], deck, result['id'])
return flashcard
def select_all():
flashcards = []
sql = "SELECT * FROM flashcards"
results = run_sql(sql)
for row in results:
deck = deck_repository.select(row['deck_id'])
flashcard = Flashcard(row['answer'], row['question'], deck, row['id'])
flashcards.append(flashcard)
return flashcards
def play_deck(id):
deck = deck_repository.select(id)
flashcards = flashcard_repository.select_all()
return render_template('decks/play.html', deck = deck, flashcards = flashcards)
def edit_deck(id):
deck = deck_repository.select(id)
return render_template('decks/edit.html', deck = deck)
def show_deck(id):
deck = deck_repository.select(id)
return render_template('decks/show.html', deck = deck)