def quotes_update(quote_id, child_id):
quote = Quote.query.get(quote_id)
form = QuoteForm(request.form)
# Talletetaan lomakkeelle kategoriavalinnat, tarpeen sivun uudelleennäytössä
cates = Category.query.all()
c_list = [(i.name, i.name) for i in cates]
form = QuoteForm()
form.categories.choices = c_list
if not form.validate():
return render_template("quotes/modifystate.html",
form=form,
quote_id=quote_id,
child_id=child_id)
quote.quotecategory.clear()
db.session().commit()
quote.quote = form.name.data
quote.agesaid = form.age.data
allcategories = form.categories.data
# käydään läpi kaikki valitut kategoriat ja lisätään ne sanonnalle
for category in allcategories:
c = Category.findCategory(category)
quote.quotecategory.append(c)
db.session().commit()
return redirect(url_for("quotes_childquotes", child_id=child_id))
def quotes_create(child_id):
form = QuoteForm(request.form)
cates = Category.query.all()
c_list = [(i.name, i.name) for i in cates]
form = QuoteForm()
form.categories.choices = c_list
if not form.validate():
return render_template("quotes/new.html", form=form, child_id=child_id)
q = Quote(quote=form.name.data, agesaid=form.age.data, child_id=child_id)
# Haetaan valitut kategoriat ja lisätään ne yksitellen sanonnalle
allcategories = form.categories.data
for category in allcategories:
c = Category.findCategory(category)
q.quotecategory.append(c)
db.session.add(q)
db.session().commit()
return redirect(url_for("quotes_childquotes", child_id=child_id))
def quotes_by_category():
#Otataan talteen kategoria id, jotta voidaan hakea oikean kategorian sanonnat
form = CategorySelectForm(request.form)
name = form.selection.data
category = Category.findCategory(name)
category_id = category.getId()
return redirect(
url_for("quotes_by", page=1, category_id=category_id, name=name))