Statistics API

[ANIALLATOR114]

Summary by Sourcery

This pull request introduces a new Statistics API, including endpoints to fetch the most recent statistics and statistics for a specific date. It also enhances the DatabaseStatisticRepository with new methods and updates CI workflows to populate statistics data before running tests. Integration tests for the new API endpoints are also included.

• New Features:
  • Introduced a new Statistics API with endpoints to fetch the most recent statistics and statistics for a specific date.
  • Added a new StatisticsController to handle statistics-related API requests.
• Enhancements:
  • Added max_created_subquery function to generate subqueries for fetching the maximum created_at value for each key in the DatabaseStatisticModel table.
  • Extended DatabaseStatisticRepository with methods to fetch the most recent statistics by key and statistics by key and date.
• CI:
  • Updated CI workflows to include a step for populating statistics data before running tests.
• Tests:
  • Added integration tests for the new Statistics API endpoints to verify fetching the most recent statistics and statistics for a specific date.

[sourcery-ai[bot]]

Reviewer's Guide by Sourcery

This pull request introduces a new Statistics API. The main changes include the addition of methods in the repository to fetch statistics, the creation of a new controller to handle statistics-related endpoints, and the addition of integration tests for these endpoints. Workflow files were also updated to populate statistics data before running tests.

File-Level Changes

Files	Changes
.github/workflows/tests_on_merge_main.yaml .github/workflows/tests_on_pr.yaml	Added steps to populate statistics data before running tests in both workflows.

---

Tips

- Trigger a new Sourcery review by commenting `@sourcery-ai review` on the pull request. - Continue your discussion with Sourcery by replying directly to review comments. - You can change your review settings at any time by accessing your [dashboard](https://app.sourcery.ai): - Enable or disable the Sourcery-generated pull request summary or reviewer's guide; - Change the review language; - You can always [contact us](mailto:support@sourcery.ai) if you have any questions or feedback.