def add_word():
if request.method == "GET":
return render_template("upload.html", parts=get_parts_dict().values())
word = request.form["word"].lower()
translation = request.form["translation"]
part_id = get_parts_dict(name_to_id=True)[request.form["parts_of_speech"]]
explanation = request.form["explanation"]
if not explanation:
explanation = None
Translations.insert(word=word,
translation=translation,
updated_by=session["mail"],
part_of_speech_id=part_id,
explanation=explanation,
confirmed=False).execute()
return redirect(url_for("search"))
def words_to_confirm():
query = Translations.select().where(Translations.confirmed == 0)
results = list(query)
return results
def delete_word(word, translation):
value = Translations.select().where((Translations.word == word) and (Translations.translation == translation)).get()
value.delete_instance()
return redirect(url_for("check_words"))
def confirm_word(word, translation):
Translations.update({Translations.confirmed: True}).where(
(Translations.word == word) and (Translations.translation == translation)).execute()
return redirect(url_for("check_words"))
def get_translation(word):
word = word.lower()
query = Translations.select().where((Translations.word == word) & (Translations.confirmed == 1))
results = list(query)
return results
def words_to_confirm():
query = Translations.select().where(Translations.confirmed == 0)
results = [result for result in query]
return results