def tehtavat_delete(tehtava_id):
t = Tehtava.query.get(tehtava_id)
db.session().delete(t)
db.session().commit()
return redirect(url_for("tehtavat_index"))
def categories_delete(category_id):
stmt = text('DELETE FROM task_category'
' WHERE task_category.kategoria_id = ' + str(category_id))
db.engine.execute(stmt)
c = Kategoria.query.get(category_id)
db.session().delete(c)
db.session().commit()
return redirect(url_for("categories_index"))
def tehtavat_set_done(tehtava_id):
t = Tehtava.query.get(tehtava_id)
if t.done == True:
t.done = False
else:
t.done = True
db.session().commit()
return redirect(url_for("tehtavat_index"))
def categories_create():
form = CategoryForm(request.form)
if not form.validate():
return render_template("kategoriat/new.html", form=form)
c = Kategoria(form.name.data)
c.account_id = current_user.id
db.session().add(c)
db.session().commit()
return redirect(url_for("categories_index"))
def tehtavat_create():
form = TaskForm(request.form)
form.category.choices = Kategoria.categories_by_user(current_user.id)
if not form.validate():
return render_template("tehtavat/new.html", form = form)
t = Tehtava(form.name.data, Kategoria.all_by_id(form.category.data), form.importance.data)
t.done = form.done.data
t.account_id = current_user.id
db.session().add(t)
db.session().commit()
return redirect(url_for("tehtavat_index"))
def auth_create():
form = RegisterForm(request.form)
if not form.validate():
print("Vikatikki1")
return render_template("auth/register.html", form=form)
if not form.password.data == form.password.data:
print("Vikatikki2")
return render_template("auth/register.html", form=form)
k = User(form.name.data, form.username.data, form.password.data)
db.session().add(k)
db.session().commit()
return render_template("auth/login.html", form=RegisterForm())
def hyvaksy_muutokset(tehtava_id):
form = ModifyForm(request.form)
t = Tehtava.query.get(tehtava_id)
if not form.validate():
return render_template("tehtavat/muokkaus.html", tehtava = t, form = ModifyForm())
t.name = form.name.data
t.done = form.done.data
t.importance = form.importance.data
db.session().commit()
return render_template("tehtavat/infosivu.html/", tehtava = t)
def all_by_ids(ids):
ret = []
for t in db.session().query(Tehtava).filter(Tehtava.id.in_(ids)):
print(t)
ret.append(t)
return ret
def tasks_by_account(id):
return db.session().query(Tehtava).filter_by(account_id=id).all()
def all_by_id(ids):
ret = []
for c in db.session().query(Kategoria).filter(Kategoria.id.in_(ids)):
print(c)
ret.append(c)
return ret
def categories_by_user(id):
return db.session().query(Kategoria.id, Kategoria.name).filter_by(account_id=id).all()
