`UC006`: Implement Endpoint for Analyzing Average Trip Durations in `Bixi-Api`

[k-allagbe]

Feature Request

Description:

Add an endpoint to Bixi-Api for getting average trip times in the Bixi network over specific periods.

Use Case:

• https://github.com/Monitoring-Mtl/Frontend/issues/114

Proposed Solution:

Develop a GET /api/trip-durations/average endpoint that takes startTime and endTime as input, with options to filter by start and end stations and arrondissements.

Alternative Solutions:

1. AWS Analytics Services: Using AWS services such as Amazon QuickSight or AWS Glue DataBrew might introduce higher costs and complexity beyond the requirements of this project's scope.

2. Third party Bixi APIs or Microservices: We didn't find any ready-made solutions that fit our exact needs for analyzing trip times, so making our own seems best.

Additional Information:

The feature should prioritize performance for fast data retrieval, scalability to support data growth, and ease of maintenance for future updates.

Checklist

• [x] Checked for similar feature requests.
• [x] Clearly described the feature.
• [x] Outlined the use case.
• [x] Reviewed possible ways to do it.

Tasks

• [x] endpoint
• [x] db connection
• [x] logic to calculate average trip duration
• [x] tests
• [x] documentation