def new_student(): if _login != 0 and _password != '': form = StudentForm() db = PostgresDb() if request.method == 'POST': student_obj = Student( student_id=db.sqlalchemy_session.query(func.max(Student.student_id) + 1), student_name=form.student_name.data, student_surname=form.student_surname.data, student_age=form.student_age.data, student_spec=form.student_spec.data, student_course=form.student_course.data, student_group=form.student_group.data, student_password=form.student_password.data) db = PostgresDb() db.sqlalchemy_session.add(student_obj) db.sqlalchemy_session.commit() return redirect(url_for('student')) return render_template('student_form.html', form=form, form_name="New student", action="new_student") else: return render_template('login_exception.html')
def edit_user(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") form = UserForm() if request.method == 'GET': id = request.args.get('id') db = PostgresDb() user_obj = db.sqlalchemy_session.query(User).filter( User.id == id).one() # fill form and send to user form.id.data = user_obj.id form.name.data = user_obj.name form.surname.data = user_obj.surname form.login.data = user_obj.login form.password.data = user_obj.password return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: form.strip() if not form.validate(): return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: db = PostgresDb() if db.sqlalchemy_session.query(User).filter( User.login == form.login.data, User.id != form.id.data).all(): return render_template( 'user_form.html', form=form, form_name="Edit user", action="edit_user", msg="Cant edit this record. Use another login") # find professor user_obj = db.sqlalchemy_session.query(User).filter( User.id == form.id.data).one() # update fields from form data user_obj.professor_id = form.id.data user_obj.login = form.login.data user_obj.password = form.password.data user_obj.name = form.name.data user_obj.surname = form.surname.data db.sqlalchemy_session.commit() return redirect(url_for('index_user'))
def edit_exercise(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") form = ExerciseForm() if request.method == 'GET': id = request.args.get('id') db = PostgresDb() exercise = db.sqlalchemy_session.query(Exercise).filter( Exercise.id == id).one() # fill form and send to student form.id.data = exercise.id form.title.data = exercise.title form.muscle_type.data = exercise.muscle_type form.description.data = exercise.description return render_template('exercise_form.html', form=form, form_name="Edit exercise", action="edit_exercise") else: form.strip() if not form.validate(): return render_template('exercise_form.html', form=form, form_name="Edit exercise", action="edit_exercise") else: db = PostgresDb() if db.sqlalchemy_session.query(Exercise).filter( Exercise.title == form.title.data, Exercise.id != form.id.data).all(): return render_template( 'exercise_form.html', form=form, form_name="Edit exercise", action="edit_exercise", msg="Cant edit this record. Use another title") exercise = db.sqlalchemy_session.query(Exercise).filter( Exercise.id == form.id.data).one() # update fields from form data exercise.id = form.id.data exercise.title = form.title.data exercise.muscle_type = form.muscle_type.data exercise.description = form.description.data db.sqlalchemy_session.commit() return redirect(url_for('index_exercise'))
def edit_plan(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") form = PlanForm() if request.method == 'GET': id = request.args.get('id') db = PostgresDb() discipline = db.sqlalchemy_session.query(Plan).filter( Plan.id == id).one() # fill form and send to discipline form.id.data = id form.title.data = discipline.title return render_template('plan_form.html', form=form, form_name="Edit plan", action="edit_plan") else: form.strip() if not form.validate(): return render_template('plan_form.html', form=form, form_name="Edit plan", action="edit_plan") else: db = PostgresDb() if db.sqlalchemy_session.query(Plan).filter( Plan.title == form.title.data, Plan.id != form.id.data).all(): return render_template( 'plan_form.html', form=form, form_name="Edit plan", action="edit_plan", msg="Cant edit this record. Use another title") # find plan = db.sqlalchemy_session.query(Plan).filter( Plan.id == int(form.id.data)).one() # update fields from form data plan.id = int(form.id.data) plan.title = form.title.data db.sqlalchemy_session.commit() return redirect(url_for('index_plan'))
def edit_plan_exercises(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") form = PlanExercisesForm() db = PostgresDb() if request.method == 'GET': id = request.args.get('id') db = PostgresDb() plan_obj = db.sqlalchemy_session.query(Plan_exercises).filter( Plan_exercises.id == id).one() # fill form form.id.data = id form.plan_fk.data = plan_obj.plan_fk form.exercise_id.data = plan_obj.exercise_id form.weight.data = plan_obj.weight form.count.data = plan_obj.count return render_template('plan_exercises_form.html', form=form, form_name="Edit plan exercise", action="edit_plan_exercises") else: if not form.validate(): return render_template('plan_exercises_form.html', form=form, form_name="Edit plan exercise", action="edit_plan_exercises") else: # find discipline plan_obj = db.sqlalchemy_session.query(Plan_exercises).filter( Plan_exercises.id == int(form.id.data)).one() # update fields from form data plan_obj.id = int(form.id.data) plan_obj.plan_fk = form.plan_fk.data plan_obj.exercise_id = form.exercise_id.data plan_obj.weight = form.weight.data plan_obj.count = form.count.data db.sqlalchemy_session.commit() return redirect(url_for('index_plan_exercises'))
def new_discipline(): form = DisciplineForm() db = PostgresDb() if request.method == 'POST': if not form.validate(): return render_template('discipline_form.html', form=form, form_name="New discipline", action="new_discipline") else: id = list( db.sqlalchemy_session.query(func.max( Discipline.discipline_id)))[0][0] discipline_obj = Discipline( discipline_id=id + 1, discipline_group=form.discipline_group.data, discipline_name=form.discipline_name.data) db.sqlalchemy_session.add(discipline_obj) db.sqlalchemy_session.commit() return redirect(url_for('index_discipline')) return render_template('discipline_form.html', form=form, form_name="New discipline", action="new_discipline")
def discipline(): if _login != 0 and _password != '': db = PostgresDb() disciplines = db.sqlalchemy_session.query(Discipline).all() return render_template('discipline.html', disciplines=disciplines) else: return render_template('login_exception.html')
def new_house(): form = HouseForm() db = PostgresDb() if request.method == 'POST': if not form.validate(): return render_template('house_form.html', form=form, form_name="New house", action="new_house") else: id = list(db.sqlalchemy_session.query(func.max( House.house_id)))[0][0] house_obj = House(house_id=id + 1, address=form.address.data, price=form.price.data, floor_count=form.floor_count.data, year=form.year.data) db.sqlalchemy_session.add(house_obj) db.sqlalchemy_session.commit() return redirect(url_for('index_house')) return render_template('house_form.html', form=form, form_name="New house", action="new_house")
def search(self, method): db = PostgresDb() result, labels = [], [] query = db.sqlalchemy_session.query(Student.student_university, Student.student_faculty).distinct( Student.student_university, Student.student_faculty) if method == 'POST': if self.university.data and self.university.data != "None": query = query.filter(Student.student_university == self.university.data) if self.faculty.data and self.faculty.data != "None": query = query.filter(Student.student_faculty == self.faculty.data) student_uni_and_faculty_set = query.all() for uni, faculty in student_uni_and_faculty_set: query = db.sqlalchemy_session.query(Student.student_group, func.count(Student.student_group)).group_by( Student.student_group).filter(Student.student_university == uni, Student.student_faculty == faculty) if method == "POST": if self.group.data and self.group.data != "None": query = query.filter(Student.student_group == self.group.data) if self.name.data and self.name.data != "None": query = query.filter(Student.student_name == self.name.data) result.append(query.all()) labels.append(f'university {uni}, faculty {faculty}') return result, labels
def index_training(): if check(admin_page=False): return render_template('login.html', error="no rights, login another way") db = PostgresDb() show = bool(request.args.get("show")) if not show: train_query = db.sqlalchemy_session.query(Training).filter( Training.user_id == session['user_id'], Training.date >= datetime.date.today()).all() else: train_query = db.sqlalchemy_session.query(Training).filter( Training.user_id == session['user_id']).all() train = {} for item in train_query: if item.date not in train: train[item.date] = [item] else: train[item.date].append(item) if request.args.get("msg"): return render_template('training.html', trainings=train, msg=str(request.args.get("msg")), show=show) else: return render_template('training.html', trainings=train, msg=0, show=show)
def new_student(): form = StudentForm() db = PostgresDb() if request.method == 'POST': if not form.validate(): return render_template('student_form.html', form=form, form_name="New student", action="new_student") else: id = list(db.sqlalchemy_session.query(func.max( Student.student_id)))[0][0] student_obj = Student( student_id=id + 1, student_university=form.student_university.data, student_faculty=form.student_faculty.data, student_group=form.student_group.data, student_name=form.student_name.data) db.sqlalchemy_session.add(student_obj) db.sqlalchemy_session.commit() return redirect(url_for('index_student')) return render_template('student_form.html', form=form, form_name="New student", action="new_student")
def install(): db = PostgresDb() uni1 = Univer(name="new_uni_1", address="new_uni_1", year=date.today(), degree="uni") uni2 = Univer(name="new_uni_2", address="new_uni_2", year=date.today(), degree="uni") uni3 = Univer(name="new_uni_3", address="new_uni_3", year=date.today(), degree="uni") session = db.sqlalchemy_session session.add_all([uni1, uni2, uni3]) session.commit() # delete from "Univer" where id=4; # delete from "Univer" where id=5; # delete from "Univer" where id=6; return redirect(url_for('root'))
def new_plan(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") form = PlanForm() if request.method == 'POST': form.strip() if not form.validate(): return render_template('plan_form.html', form=form, form_name="New plan", action="new_plan") else: db = PostgresDb() if db.sqlalchemy_session.query(Plan).filter( Plan.title == form.title.data).all(): return render_template( 'plan_form.html', form=form, form_name="New plan", action="new_plan", msg="Cant add this record. Use another title") plan_obj = Plan(title=form.title.data, user_created=False) db.sqlalchemy_session.add(plan_obj) db.sqlalchemy_session.commit() return redirect(url_for('index_plan')) return render_template('plan_form.html', form=form, form_name="New plan", action="new_plan")
def new_admin(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") form = AdminForm() if request.method == 'POST': form.strip() if not form.validate(): return render_template('admin_form.html', form=form, form_name="New admin", action="new_admin") else: admin_obj = Admin(login=form.login.data, password=form.password.data) db = PostgresDb() db.sqlalchemy_session.add(admin_obj) db.sqlalchemy_session.commit() return redirect(url_for('index_admin')) return render_template('admin_form.html', form=form, form_name="New admin", action="new_admin")
def delete_plan(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") id = request.args.get('id') db = PostgresDb() if db.sqlalchemy_session.query(Training).filter( Training.plan_id == id).all(): return redirect( url_for( 'index_plan', msg= "Cant delete this record. Use this record at Training entity")) if db.sqlalchemy_session.query(Plan_exercises).filter( Plan_exercises.plan_fk == id).all(): db.sqlalchemy_session.query(Plan_exercises).filter( Plan_exercises.plan_fk == id).delete() result = db.sqlalchemy_session.query(Plan).filter(Plan.id == id).one() db.sqlalchemy_session.delete(result) db.sqlalchemy_session.commit() return redirect(url_for('index_plan'))
def new_plan_exercises(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") form = PlanExercisesForm() if request.method == 'POST': if not form.validate(): return render_template('plan_exercises_form.html', form=form, form_name="New plan exercise", action="new_plan_exercises") else: plan_obj = Plan_exercises(plan_fk=form.plan_fk.data, exercise_id=form.exercise_id.data, weight=form.weight.data, count=form.count.data) db = PostgresDb() db.sqlalchemy_session.add(plan_obj) db.sqlalchemy_session.commit() return redirect(url_for('index_plan_exercises')) return render_template('plan_exercises_form.html', form=form, form_name="New plan exercise", action="new_plan_exercises")
def plot(): pie_labels = [] data = {} db = PostgresDb() # scatter plot --------------------------------------------------------------------------------------------------- query = db.sqlalchemy_session.query(func.count(Univer.id), Univer.year).group_by(Univer.year).order_by(Univer.year).all() count, year_l = [], [] i = 0 for count_uni, year in query: i += count_uni count.append(i) year_l.append(year) bar = go.Scatter( x=year_l, y=count # mode='markers' ) data["bar"] = [bar] json_data = json.dumps(data, cls=plotly.utils.PlotlyJSONEncoder) return render_template('plot.html', json=json_data)
def edit_discipline(): form = DisciplineForm() if request.method == 'GET': discipline_university, discipline_faculty, discipline_name = request.args.get('discipline_university'), \ request.args.get('discipline_faculty'), \ request.args.get('discipline_name') db = PostgresDb() discipline = db.sqlalchemy_session.query(Discipline).filter( Discipline.discipline_university == discipline_university, Discipline.discipline_faculty == discipline_faculty, Discipline.discipline_name == discipline_name).one() # fill form and send to discipline form.discipline_university.data = discipline.discipline_university form.discipline_faculty.data = discipline.discipline_faculty form.discipline_name.data = discipline.discipline_name form.discipline_exam.data = discipline.discipline_exam form.discipline_hours_for_semester.data = discipline.discipline_hours_for_semester return render_template('discipline_form.html', form=form, form_name="Edit discipline", action="edit_discipline") else: if not form.validate(): return render_template('discipline_form.html', form=form, form_name="Edit discipline", action="edit_discipline") else: db = PostgresDb() # find discipline discipline = db.sqlalchemy_session.query(Discipline).filter( Discipline.discipline_university == form.discipline_university.data, Discipline.discipline_faculty == form.discipline_faculty.data, Discipline.discipline_name == form.discipline_name.data).one() # update fields from form data discipline.discipline_university = form.discipline_university.data discipline.discipline_faculty = form.discipline_faculty.data discipline.discipline_name = form.discipline_name.data discipline.discipline_exam = form.discipline_exam.data discipline.discipline_hours_for_semester = form.discipline_hours_for_semester.data db.sqlalchemy_session.commit() return redirect(url_for('index_discipline'))
def edit_training(): if check(admin_page=False): return render_template('login.html', error="no rights, login another way") form = TrainingForm(user_id=session['user_id'], edit=True) if request.method == 'GET': id = request.args.get('id') db = PostgresDb() training_obj = db.sqlalchemy_session.query(Training).filter( Training.id == id).one() # fill form form.id.data = id form.plan_id.data = training_obj.plan_id form.date.data = training_obj.date return render_template('training_form.html', form=form, form_name="Edit training", action="edit_training") else: if not form.validate(): return render_template('training_form.html', form=form, form_name="Edit training", action="edit_training") else: db = PostgresDb() # find discipline training_obj = db.sqlalchemy_session.query(Training).filter( Training.id == int(form.id.data)).one() # update fields from form data training_obj.id = int(form.id.data) training_obj.plan_id = form.plan_id.data training_obj.date = form.date.data training_obj.user_id = session['user_id'] db.sqlalchemy_session.commit() return redirect(url_for('index_training'))
def student(): if _login != 0 and _password != '': db = PostgresDb() students = db.sqlalchemy_session.query(Student).filter(Student.student_id != 1001).all() #print(students) return render_template('student.html', students=students) else: return render_template('login_exception.html')
def edit_student(): form = StudentForm() if request.method == 'GET': student_id = request.args.get('student_id') db = PostgresDb() student = db.sqlalchemy_session.query(Student).filter( Student.student_id == student_id).one() # fill form and send to student form.student_id.data = student.student_id form.student_name.data = student.student_name form.student_group.data = student.student_group form.student_university.data = student.student_university form.student_faculty.data = student.student_faculty return render_template('student_form.html', form=form, form_name="Edit student", action="edit_student") else: if not form.validate(): return render_template('student_form.html', form=form, form_name="Edit student", action="edit_student") else: db = PostgresDb() # find student student = db.sqlalchemy_session.query(Student).filter( Student.student_id == form.student_id.data).one() # update fields from form data student.student_id = form.student_id.data student.student_university = form.student_university.data student.student_faculty = form.student_faculty.data student.student_group = form.student_group.data student.student_name = form.student_name.data db.sqlalchemy_session.commit() return redirect(url_for('index_student'))
def edit_admin(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") form = AdminForm() if request.method == 'GET': admin_id = request.args.get('admin_id') db = PostgresDb() admin = db.sqlalchemy_session.query(Admin).filter( Admin.id == admin_id).one() # fill form and send to student form.id.data = admin.id form.login.data = admin.login form.password.data = admin.password return render_template('admin_form.html', form=form, form_name="Edit admin", action="edit_admint") else: form.strip() if not form.validate(): return render_template('admin_form.html', form=form, form_name="Edit admin", action="edit_admin") else: db = PostgresDb() # find student admin = db.sqlalchemy_session.query(Admin).filter( Admin.id == form.id.data).one() # update fields from form data admin.id = form.id.data admin.login = form.login.data admin.password = form.password.data db.sqlalchemy_session.commit() return redirect(url_for('index_admin'))
def edit_house(): form = HouseForm() if request.method == 'GET': house_id = request.args.get('house_id') db = PostgresDb() house = db.sqlalchemy_session.query(House).filter( House.house_id == house_id).one() # fill form and send to house form.house_id.data = house.house_id form.address.data = house.address form.price.data = house.price form.floor_count.data = house.floor_count form.year.data = house.year return render_template('house_form.html', form=form, form_name="Edit house", action="edit_house") else: if not form.validate(): return render_template('house_form.html', form=form, form_name="Edit house", action="edit_house") else: db = PostgresDb() # find house house = db.sqlalchemy_session.query(House).filter( House.house_id == form.house_id.data).one() # update fields from form data house.house_id = form.house_id.data house.address = form.address.data house.price = form.price.data house.floor_count = form.floor_count.data house.year = form.year.data db.sqlalchemy_session.commit() return redirect(url_for('index_house'))
def new_training(): if check(admin_page=False): return render_template('login.html', error="no rights, login another way") db = PostgresDb() form = TrainingForm(user_id=session['user_id']) if request.method == 'POST': if not form.validate(): return render_template( 'training_form.html', form=form, action="new_training", form_name="New training with plan name: {}".format( form.new_plan_name.data)) else: plan_obj = Plan(title=form.new_plan_name.data, user_created=True) db.sqlalchemy_session.add(plan_obj) db.sqlalchemy_session.commit() exercises = db.sqlalchemy_session.query(Plan_exercises).filter( Plan_exercises.plan_fk == form.plan_id.data).all() plan_obj = db.sqlalchemy_session.query(Plan).filter( Plan.title == form.new_plan_name.data).one() for exercise in exercises: plan_exercise = Plan_exercises( plan_fk=plan_obj.id, exercise_id=exercise.exercise_id, weight=exercise.weight, count=exercise.count) db.sqlalchemy_session.add(plan_exercise) training_obj = Training( user_id=session['user_id'], plan_id=plan_obj.id, date=form.date.data.strftime("%d-%b-%y"), ) db.sqlalchemy_session.add(training_obj) db.sqlalchemy_session.commit() return redirect(url_for('index_training')) user = db.sqlalchemy_session.query(User).filter( User.id == session['user_id']).one() new_plan_name = "{}_{}".format( user.login, datetime.datetime.now().strftime("%d/%m/%Y_%H:%M:%S")) form.new_plan_name.data = new_plan_name return render_template( 'training_form.html', form=form, form_name="New training with plan name: {}".format(new_plan_name), action="new_training")
def edit_professor(): form = ProfessorForm() if request.method == 'GET': professor_id = request.args.get('professor_id') db = PostgresDb() professor_obj = db.sqlalchemy_session.query(Professor).filter(Professor.professor_id == professor_id).one() # fill form and send to user form.professor_id.data = professor_obj.professor_id form.professor_university.data = professor_obj.professor_university form.professor_department.data = professor_obj.professor_department form.professor_name.data = professor_obj.professor_name form.professor_surname.data = professor_obj.professor_surname form.professor_birthday.data = professor_obj.professor_birthday form.professor_date_enrollment.data = professor_obj.professor_date_enrollment form.professor_degree.data = professor_obj.professor_degree return render_template('professor_form.html', form=form, form_name="Edit professor", action="edit_professor") else: if not form.validate(): return render_template('professor_form.html', form=form, form_name="Edit professor", action="edit_professor") else: db = PostgresDb() # find professor professor_obj = db.sqlalchemy_session.query(Professor).filter(Professor.professor_id == form.professor_id.data).one() # update fields from form data professor_obj.professor_id = form.professor_id.data professor_obj.professor_university = form.professor_university.data professor_obj.professor_department = form.professor_department.data professor_obj.professor_name = form.professor_name.data professor_obj.professor_surname = form.professor_surname.data professor_obj.professor_birthday = form.professor_birthday.data professor_obj.professor_date_enrollment = form.professor_date_enrollment.data.strftime("%d-%b-%y") professor_obj.professor_degree = form.professor_degree.data db.sqlalchemy_session.commit() return redirect(url_for('index_professor'))
def edit_discipline(): if _login != 0 and _password != '': form = DisciplineForm() if request.method == 'GET': discipline_id = request.args.get('discipline_id') db = PostgresDb() discipline = db.sqlalchemy_session.query(Discipline).filter(Discipline.discipline_id == discipline_id).one() form.discipline_id.data = discipline.discipline_id form.discipline_name.data = discipline.discipline_name form.discipline_data.data = discipline.discipline_data form.programming_tag.data = discipline.tag_programming form.algorithm_tag.data = discipline.tag_algorithm form.graphics_tag.data = discipline.tag_graphics form.databases_tag.data = discipline.tag_databases form.math_tag.data = discipline.tag_math db.sqlalchemy_session.commit() return render_template('discipline_form.html', form=form, form_name="Edit discipline", action="edit_discipline") else: db = PostgresDb() discipline = db.sqlalchemy_session.query(Discipline).filter(Discipline.discipline_id == form.discipline_id.data).one() discipline.discipline_id = form.discipline_id.data discipline.discipline_name = form.discipline_name.data discipline.discipline_data = form.discipline_data.data discipline.tag_programming = form.programming_tag.data discipline.tag_algorithm = form.algorithm_tag.data discipline.tag_graphics = form.graphics_tag.data discipline.tag_databases = form.databases_tag.data discipline.tag_math = form.math_tag.data db.sqlalchemy_session.commit() return redirect(url_for('discipline')) else: return render_template('login_exception.html')
def edit_table(): form = TableForm() if request.method == 'GET': id = request.args.get('id') db = PostgresDb() table_obj = db.sqlalchemy_session.query(Univer).filter(Univer.id == id).one() # fill form and send to user form.id.data = id form.name.data = table_obj.name form.address.data = table_obj.address form.year.data = table_obj.year form.degree.data = table_obj.degree return render_template('new_form.html', form=form, form_name="Edit ", action="edit_table") else: if not form.validate(): # form.job_name.errors.append('vova') return render_template('new_form.html', form=form, form_name="Edit", action="edit_table") else: if form.year.data.year < 2000 or form.year.data.year > 2019: form.year.errors.append('year shoud be in interval [2000-2019]') return render_template('new_form.html', form=form, form_name="Edit", action="edit_table") db = PostgresDb() table_obj = db.sqlalchemy_session.query(Univer).filter(Univer.id == form.id.data).one() # update fields from form data table_obj.name = form.name.data table_obj.address = form.address.data table_obj.year = form.year.data table_obj.degree = form.degree.data db.sqlalchemy_session.commit() return redirect(url_for('index_show'))
def edit_student(): if _login != 0 and _password != '': form = StudentForm() if request.method == 'GET': student_id = request.args.get('student_id') db = PostgresDb() student = db.sqlalchemy_session.query(Student).filter(Student.student_id == student_id).one() form.student_id.data = student.student_id form.student_name.data = student.student_name form.student_surname.data = student.student_surname form.student_age.data = student.student_age form.student_spec.data = student.student_spec form.student_course.data = student.student_course form.student_group.data = student.student_group form.student_password.data = student.student_password db.sqlalchemy_session.commit() return render_template('student_form.html', form=form, form_name="Edit student", action="edit_student") else: db = PostgresDb() student = db.sqlalchemy_session.query(Student).filter(Student.student_id == form.student_id.data).one() student.student_id = form.student_id.data student.student_name = form.student_name.data student.student_surname = form.student_surname.data student.student_age = form.student_age.data student.student_spec = form.student_spec.data student.student_course = form.student_course.data student.student_group = form.student_group.data student.student_password = form.student_password.data db.sqlalchemy_session.commit() return redirect(url_for('student')) else: return render_template('login_exception.html')
def index_admin(): if check(admin_page=True): return render_template('login.html', error="no rights, login another way") db = PostgresDb() result = db.sqlalchemy_session.query(Admin).all() return render_template('admin.html', admins=result)
def delete_student(): student_id = request.args.get('student_id') db = PostgresDb() result = db.sqlalchemy_session.query(Student).filter(Student.student_id == student_id).one() result.student_date_expelled = date.today() db.sqlalchemy_session.commit() return redirect(url_for('index_student'))