def delete_profile(user_id): logout_user() User.remove_user(user_id) u = User.query.get(user_id) db.session().delete(u) db.session().commit() return redirect(url_for("index"))
def update_profile(user_id): form = UpdateForm(request.form) if not form.validate(): return render_template("users/update.html", form=form, user=User.query.get(user_id)) u = User.query.get(user_id) u.firstname = form.firstname.data u.lastname = form.lastname.data db.session().add(u) db.session().commit() return render_template("users/profile.html", user=User.query.get(user_id))
def courses_update(course_id): form = CourseForm(request.form) if not form.validate(): return render_template("courses/update.html", form=form, course=Course.query.get(course_id)) c = Course.query.filter_by(name=form.name.data, content=form.content.data, time=form.time.data).first() t = Teacher.query.filter_by(firstname=form.teacher_firstname.data, lastname=form.teacher_lastname.data).first() completed = form.completed.data planned = form.planned.data User.remove_row(current_user.id, course_id) db.session().commit() return create_or_update(c, t, form.teacher_firstname.data, form.teacher_lastname.data, form.name.data, form.content.data, form.time.data, completed, planned)
def users_create(): form = RegistrationForm(request.form) if not form.validate(): return render_template("users/new.html", form=form) user = User.query.filter_by(username=form.username.data).first() admin = 1 if form.admin.data: admin = 2 if user: return render_template("users/new.html", form=form, error="Käyttäjänimi käytössä") else: user = User(form.firstname.data, form.lastname.data, form.username.data, form.password.data, admin) db.session().add(user) db.session().commit() return render_template("/index.html")
def make_admin(user_id): user = User.query.get(user_id) user.role_id = 2 db.session().add(user) db.session().commit() return redirect(url_for("show_users"))
def courses_delete(course_id): User.remove_row(current_user.id, course_id) db.session().commit() return redirect(url_for("courses_list"))
def create_or_update(c, t, teacher_firstname, teacher_lastname, course_name, course_content, course_time, completed, planned): if t is None: t = Teacher(teacher_firstname, teacher_lastname) db.session().add(t) db.session().commit() if c is None: c = Course(course_name, course_content, course_time) c.teacher_id = t.id db.session().add(c) db.session().commit() uc = UserCourse(current_user.id, c.id, completed, planned) db.session.add(uc) db.session().commit() return redirect(url_for("courses_list")) course_id = Course.check_if_course_and_teacher_exist( t.id, course_name, course_content, course_time) if not course_id: c = Course(course_name, course_content, course_time) c.teacher_id = t.id db.session().add(c) db.session().commit() else: c = Course.query.get(course_id[0]) uc = UserCourse.query.filter_by(user_id=current_user.id, course_id=c.id).first() if uc is None: uc = UserCourse(current_user.id, c.id, completed, planned) db.session().add(uc) db.session().commit() return redirect(url_for("courses_list"))