def result(): username = request.get_cookie("username") user = User.get(User.id == int(username)) subjects = Subject.select() # result = Result.select().where(Result.username==user, # Result.subject_code==subject) # print(result) return {"subjects": subjects}
def add_grade_(): form = AddGradeForm() if form.validate_on_submit(): try: with db.transaction(): grade = Grade.create( student=Student.get(Student.username == form.student_select.data), subject=Subject.get(Subject.name == form.subject_select.data), teacher=get_current_user(), grade=form.grade.data ) except DatabaseError: flash('An error occurred while adding a grade') else: flash('Grade ' + str(grade.grade) + ' assigned to student ' + str(grade.student)) return redirect(url_for('groups', group=grade.student.username)) flash_errors(form) students = Student.select() subjects = Subject.select() return render_template('add_grade.html', students=students, subjects=subjects, form=form)
def student_profile_foreign_(username): student = Student.get(Student.username == username) subjects = Subject.select() grades = Grade.select().where(Grade.student == student) return render_template('student_profile.html', student=student, subjects=subjects, grades=grades)
def student_profile_(): student = get_current_user() subjects = Subject.select() grades = Grade.select().where(Grade.student == student) return render_template('student_profile.html', student=student, subjects=subjects, grades=grades)
def choosesub(): subject = Subject.select()[0] return {"subject": subject}