def view_all(): """ View list of students. """ db = DBHandler(DBNAME) students = db.get_all_students() db.close_connection() students = merge_sort(students) return render_template('view_all.html', student_list=students)
def add_student(): """ View add student form. """ form = StudentForm(request.form) if request.method == 'POST' and form.validate(): student = Student(form.roll_number.data, form.name.data, form.rank.data) try: # Try to add student record to database db = DBHandler(DBNAME) db.add_student(student) db.close_connection() except sqlite3.IntegrityError as e: # Primary key constraint: Roll number already exists flash('Roll number already exists.') return render_template('add.html', form=form) return redirect(url_for('view_all')) return render_template('add.html', form=form)