def add_student():
if current_user.admin:
form = SelectForm()
form.student_list.choices = DB.student_list_form()
form.class_list.choices = DB.class_list_form()
form.school_list.choices = DB.list_school_form()
form.student_list2.choices = DB.student_list_form()
form.class_list2.choices = DB.class_list_form()
if form.submit.data:
DB.add_student(form.school_list.data, form.class_list.data,
form.name.data, form.surname.data,
form.patronymic.data, form.sex.data,
form.password.data)
return "Данные для " + str(form.name.data) + " " + str(
form.surname.data
) + " " + str(form.patronymic.data) + " Логин:пароль " + str(
DB.get_last_added_userid()
) + " : " + form.password.data + """ <a href="/add_student" font-size="16">ок</a>"""
if form.submit3.data:
DB.update_student(id=form.student_list2.data,
class_id=form.class_list2.data,
sex=form.sex2.data,
name=form.name2.data,
surname=form.surname2.data,
patronymic=form.patronymic2.data,
password=form.password2.data)
return redirect(url_for("add_student"))
if form.submit2.data:
student = db.session.query(Students).filter_by(
id=form.student_list.data)
student = student.all()
user_id = student[0].id_user
db.session.query(User).filter_by(id=user_id).delete()
db.session.query(Students).filter_by(
id=form.student_list.data).delete()
db.session.commit()
return redirect(url_for("add_student"))
return render_template("add_student2.html",
form=form,
rows=DB.student_list())
else:
return redirect(url_for("index"))
