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