Create CRUD Functions for Semester Planning Table

[carlospepin23]

Objective:

Implement CRUD functions for the semester_planning table.

Description:

This task involves creating the necessary CRUD functions for the semester_planning table. These functions will allow users to manage semester planning data efficiently within the application.

Requirements:

• Implement Create, Read, Update, and Delete functions for the semester_planning table.
• Ensure the functions validate data and handle errors appropriately.
• Maintain existing database relationships while integrating the new CRUD functionality.

Time Constraints:

Complete by Friday, October 18.

Completion Criteria:

CRUD functionality for the semester_planning table is implemented and integrated with the Semester Planning class.

Difficulty: 4

The task involves understanding existing database relationships and creating functions that interact with the semester_planningtable.

Priority: 3

This task is important for the Semester Planning feature; however, it has a priority of 3 since there is sufficient time, and it will be worked on after the Semester Planning class is created.

Recommended Assignees:

1x Developer

Database Table:

[carlospepin23]

Completed fully functional CRUD operations for the Semester Planning table.

Here's the SemesterPlanning class with its properties.

• _insert_courses: Inserts courses associated with the semester plan into the planned_courses table, linking the course code with the semester plan. This function was developed with @Jeanpaul-Ortiz to ensure compatibility with the CRUD functions shown below.

• create: Creates a new semester plan in the semester_planning table and inserts the associated courses into the database.

• read_by_id: Retrieves the details of a specific semester plan, including the associated courses, based on the planning_id, and displays the course details.

• update: Updates the details of an existing semester plan and its associated courses by removing old courses and inserting new ones into the database.

• delete: Deletes a semester plan and its associated courses, ensuring both the plan and linked courses are safely removed using a cascading operation.

Here are examples demonstrating the usage of each function.

[nelson-escalona]

LGTM 👍