ANIALLATOR114 / SimplyTransport

SimplyTransport - API - Website - Ingesting and presenting Transport Information
https://simplytransport.ie
Apache License 2.0
2 stars 3 forks source link

Add timescale database #138

Closed ANIALLATOR114 closed 1 month ago

ANIALLATOR114 commented 1 month ago

Summary by Sourcery

Add support for TimescaleDB, update database connection functions and healthcheck endpoint to handle both PostgreSQL and TimescaleDB, and update documentation and docker-compose configuration accordingly.

New Features:

Enhancements:

Build:

Documentation:

sourcery-ai[bot] commented 1 month ago

Reviewer's Guide by Sourcery

This pull request adds support for TimescaleDB alongside the existing Postgres database. Key changes include the addition of async_timescale_engine for TimescaleDB operations, updates to the database service functions to handle both databases, and modifications to the documentation, Docker configuration, and settings to reflect the new TimescaleDB support.

File-Level Changes

Files Changes
SimplyTransport/lib/db/services.py
SimplyTransport/lib/db/timescale_database.py
Integrated TimescaleDB support by adding async_timescale_engine and updating database service functions to handle both Postgres and TimescaleDB connections.
README.md
docker-compose.yaml
SimplyTransport/lib/settings.py
Updated documentation, Docker configuration, and settings to include TimescaleDB support.

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.