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()