def saveEditCourse(course_id, teacher_id): """process course edit form""" form = CourseForm(request.form) course = {} if request.method == 'POST' and form.validate(): course['title'] = request.form['title'] course['section'] = request.form['section'] course['department'] = request.form['department'] course['description'] = request.form['description'] course['units'] = request.form['units'] db_conn = db_pool.getconn() cursor = db_conn.cursor() cursor.execute( f"UPDATE course SET title = %s, section = %s, department = %s, " f"description = %s, units = %s WHERE course_id = %s;", (course['title'], course['section'], course["department"], course["description"], course["units"], course_id)) db_conn.commit() cursor.close() db_pool.putconn(db_conn) return redirect(url_for('renderTeachers', teacher_id=teacher_id))