pytest-monitor
pytest-monitor copied to clipboard
Add postgres DB handler
Describe the solution you'd like We'd like to keep track of different pipeline results in a dedicated database.
Describe alternatives you've considered
- Implementing a server to collect the pipeline results seemed like a bigger overhead as it also includes more infrastructure to maintain compared to just pushing the results into a database.
- Moving the sqlite database into the CI environment would be another option. This may lead to race conditions, if we have multiple pipelines running in parallel.
Additional context I got a working prototype (see https://github.com/CFMTech/pytest-monitor/pull/78) but would like to discuss the following points:
- How do we want to test the postgres implementation?
- Proposal: add postgres image to pipeline to be able to run the tests against a database in docker
- What version of psychopg (2, 3 or both) do we want to support?
- I'd propose to support both to be future proof
- How do we add this to the requirements?
- Does the implementation proposed match the architecture you envisioned?
- How to ensure people don't need to install uneccessary dependencies? Maybe we could enable people installing pytest-monitor like this
pip install pytest-monitor[postgres]