Implement DELETE /shows/{id} Endpoint for Deleting a Show by ID

[Lapotor]

Description:

This task involves implementing the DELETE /shows/{id} endpoint, which allows the deletion of a specific show based on its unique identifier (id). This endpoint will handle the removal of the show from the database, ensuring that it is no longer accessible through the API.

Tasks:

• Set up the route and controller method for handling the DELETE request.
• Validate the id parameter to ensure it corresponds to a valid show.
• Implement the logic to delete the show from the database.
• Return the appropriate HTTP response indicating the success of the deletion operation.

Acceptance Criteria:

• A successful DELETE request to /shows/{id} results in the specified show being permanently removed from the database.
• An unsuccessful request (due to invalid id, server error, or other reasons) results in an appropriate error response being returned.

Additional Information:

• Ensure proper error handling and response messages are implemented for various scenarios, such as invalid id, server errors, or any other potential issues.
• Write unit tests to verify the correctness and robustness of the delete operation.