Управление транзакциями: явный commit/rollback

Open

#254 opened on May 17, 2026 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty: 4/5
Estimated time: 3-5 days
Newbie friendliness: 38/100

Issue type: Bug
Clarity: Needs clarification
Activity status: Quiet
Tech stack: python, sqlalchemy
Domain: backend, database

Research direction

Review the SQLAlchemy connections and transactions guidance and the linked interviewer_backend/api/routes/user.py example first. Then locate high-load paths in auth-api and define which connection lifecycle changes are in scope; completion should demonstrate explicit commit or rollback without ORM use afterward.

Written by the indexing model from the issue text.

Description

connection закрывать с помощью rollback или commit и не обращаться к бд (ОРМ) после этого
Делать только в нагруженных местах, везде не надо
Пример от Тимура: https://github.com/Western-CSUS-2025-2026/CSUS-Project-25-26/blob/0d555aaf4c864d1c955b98784d9ddd41f4720d30/interviewer_backend/api/routes/user.py#L324https://github.com/Western-CSUS-2025-2026/CSUS-Project-25-26/blob/0d555aaf4c864d1c955b98784d9ddd41f4720d30/interviewer_backend/api/routes/user.py#L324

Проблема сейчас с возможным превышение лимита подключений к бд в высоконагруженных местах, подробнее https://docs.sqlalchemy.org/en/21/errors.html#connections-and-transactions

Dominant language: Python
Stars: 15
Forks: 1
PR merge metrics: No merged PRs in 30d

Contributor guide

Open the contributing guide

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

issue: imported chats all show as unread in the sidebar Open

bug confirmed issue

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

open-webui/open-webui#30750 · 1 comment · Opened Sep 24, 2026
OGS AmBe example has no source.timing block, so every event sits at time zero Open

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

lanl/ScintiPix#61 · Opened Sep 24, 2026
Make Liquid Glass the default theme for the Research build Open

enhancement

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

OpenwaterHealth/openmotion-bloodflow-app#604 · 1 comment · Opened Sep 24, 2026
tests/puppeteer/test_openai_api_key_ui.js targets controls that do not exist and is run by no workflow Open

Difficulty 2/5 1-3 hours Newbie friendliness 70/100

LearningCircuit/local-deep-research#6766 · Opened Sep 23, 2026
Delete unused args argument from main() in Python files Open

good first issue

Difficulty 1/5 Under an hour Newbie friendliness 90/100

ros2/launch#1014 · Opened Sep 23, 2026

More Python issues