[Stats Page] - Create Delete Graph Collection Endpoint

Please note, Sherpa may occasionally provide incomplete or inaccurate information. Always verify critical details and double-check suggested changes before implementation.

Summary of the Problem

The issue requires the creation of a new endpoint to soft delete a graph collection within the statistics router of the FinishLine application. The endpoint should be accessible at the route statistics/:graphCollectionId/delete and should accept the graph collection ID as a parameter.

Relevant Files

src/backend/src/routes/statistics.js: This file likely contains the routing logic for the statistics-related endpoints, where the new delete endpoint should be added.
src/backend/src/controllers/statisticsController.js: This file may contain the logic for handling requests to the statistics endpoints, including the implementation of the soft delete functionality.
src/backend/src/models/GraphCollection.js: This file may define the schema for the graph collection, which will be necessary for implementing the soft delete logic.

Suggested Changes

1. src/backend/src/routes/statistics.js

Add a new route for the delete operation:

router.delete('/:graphCollectionId/delete', statisticsController.deleteGraphCollection);

Ensure that this route is defined within the appropriate router context.

2. src/backend/src/controllers/statisticsController.js

Implement the deleteGraphCollection function:

Retrieve the graphCollectionId from the request parameters.
Call a service or model method to perform the soft delete operation.
Return a success response if the operation is successful, or handle errors appropriately.

Example skeleton:

const deleteGraphCollection = async (req, res) => {
  const { graphCollectionId } = req.params;
  try {
      await GraphCollection.softDelete(graphCollectionId); // Implement this method in the model
      res.status(200).json({ message: 'Graph collection deleted successfully.' });
  } catch (error) {
      res.status(500).json({ error: error.message });
  }
};

3. src/backend/src/models/GraphCollection.js

Implement the soft delete logic, which might involve updating a deletedAt timestamp or a isDeleted flag in the database:

static async softDelete(graphCollectionId) {
  // Example implementation
  return await prisma.graphCollection.update({
      where: { id: graphCollectionId },
      data: { deletedAt: new Date() } // or isDeleted: true
  });
}

Conclusion

To implement the soft delete functionality for the graph collection, you will need to add a new endpoint in the statistics router, create a corresponding controller method to handle the request, and implement the soft delete logic in the model. Make sure to include unit tests for the new endpoint and document the expected behavior in Postman for manual testing. This approach will ensure that the new functionality is integrated seamlessly into the existing architecture of the FinishLine application.

giovabattelli / FinishLine