Python Services - CI/CD & Python version upgrades

[thorwolpert]

Upgrading the CI & CD for all of the python based services will have some impacts.

The approach on how to do this will need to be agreed to as a team decision.
Questions like:

• Do we upgrade partially or fully?
• Do we upgrade everything at once
• Do we span it across sprints

Current tasks:

• Code Test Coverage - minimum required for a clean pass is 80%
• Lint - Syntax updates, do we move to ruff & pyright
• SQLAlchemy syntax updates - some big changes when moving to v2
• Do we consolidate the DB creation/migration files to the current version?
• Do we migrate from poetry to uv?

[OlgaPotiagalova]

To help with prioritization, the following needs to be clarified:

• Why the CI/CD upgrade is needed at this time?
• What risks or issues we are mitigating?
• Whether this is required before transition to maintenance mode?
• What the expected effort and impact are? - will be reviewed in the grooming session