def delete_section_helper(section_id): student_section_manager = StudentSectionRequestManager(Repository(sqldb())) student_section_manager.delete(data={"section_id": section_id}) # Delete section r_manager = SectionRequestManager(Repository(sqldb())) section_success = r_manager.delete(data={"section_id": section_id}) return section_success
def create_course(): success = "Course Creation Failed" if request.method == 'POST': cleaned_data = clean_data(request) r_manager = CourseRequestManager(Repository(sqldb())) # Separate the data into course and section part course_data = {} section_data = {} for key, value in cleaned_data.items(): if key.startswith("courses"): course_data[key] = value else: section_data[key] = value # Add course first course_success = r_manager.add(course_data) if course_success: # Get the course_id course_results, course_field_names = r_manager.read( criteria=course_data) course_info = convert_sql(course_results, course_field_names) course_id = course_info[0]["course_id"] section_data["course_id"] = course_id # add the section to the course section_manager = SectionRequestManager(Repository(sqldb())) section_success = section_manager.add(section_data) if section_success: success = "HOORAY! Course and Section Successfully Created" else: r_manager.delete(course_data) success = "Section Creation Failed, Course Deleted" return {'success': success}
def delete_section(): success = "Section Deletion Failed" if request.method == 'POST': cleaned_data = clean_data(request) section_id = cleaned_data["section_id"] #Find course id of that section r_manager = SectionRequestManager(Repository(sqldb())) results, fieldnames = r_manager.read( criteria={"sections.section_id": section_id}) course_id = results[0][0] # TO DO: delete labs associated with session # Delete all students associated with sections section_id = cleaned_data["section_id"] section_success = delete_section_helper(section_id=section_id) if section_success: success = "Section Delete Succeeded!" # delete all sections related to that course results, fieldnames = r_manager.read( criteria={"sections.course_id": course_id}) if len(results) > 0: for section in results: secion_id = section[5] delete_section_helper(section_id=section_id) success = "Section Delete Succeeded! Also deleted the course" return {'success': success}
def delete_course(): success = "Course Deletion Failed" if request.method == 'POST': cleaned_data = clean_data(request) # Find all sections associated with the course_id course_id = cleaned_data["course_id"] section_manager = SectionRequestManager(Repository(sqldb())) section_results, field_names = section_manager.read( criteria={"sections.course_id": course_id}) # Delete all sections for section in section_results: section_id = section[5] delete_section_helper(section_id=section_id) # Delete the Course r_manager = CourseRequestManager(Repository(sqldb())) course_success = r_manager.delete(data=cleaned_data) if course_success: success = "Course Delete Succeeded!" return {'success': success}
def get_course(): rv_final = jsonify({}) if request.method == 'POST': cleaned_data = clean_data(request) r_manager = SectionRequestManager(Repository(sqldb())) results, field_names = r_manager.read(cleaned_data) if results: rv = convert_sql(results, field_names) rv_final = jsonify(rv) return rv_final
def update_section(): success = "Section Modification Failed" if request.method == 'POST': cleaned_data = clean_data(request) section_id = cleaned_data["section_id"] del cleaned_data["section_id"] r_manager = SectionRequestManager(Repository(sqldb())) course_success = r_manager.modify(new_data=cleaned_data, section_id=section_id) if course_success: success = "Section Modification Succeeded!" return {'success': success}