So we close those transactions after we don't need them

Changes proposed ✍️

What

🤖 Generated by Copilot at 1e033d0

Refactored the Repository class in the Python microservice to use scoped sessions for better database concurrency and integrity. Fixed a syntax error in a SQL query.
​

🤖 Generated by Copilot at 1e033d0

The Repository class had a flaw
It used a global session for all
But scoped sessions are better
They keep the data setter
And fix a syntax error so small

Why

How

🤖 Generated by Copilot at 1e033d0

• Refactor Repository class to use scoped sessions instead of a global session object (link, link, link, link, link, link)
• Fix a missing parenthesis in the raw SQL query of the find_all_usernames method (link)

Checklist ✅

• Label appropriately with Feature, Improvement, or Bug.
• Add screehshots to the PR description for relevant FE changes
• New backend functionality has been unit-tested.
• API documentation has been updated (if necessary) (see docs on API documentation).
• Quality standards are met.