Self managed connections
@amochin is already working on this.
Since Oct 21, 2025.
Assessment
This issue has not been assessed yet.
Description
One of the major problems with using libraries like DatabaseLibrary is managing the connection. If we implement #149, it could cause additional problems. Typically QA need to implement following logic:
Connect To Database (...)
Query
[Teardown] Disconnect Connection
But often Disconnect Connection is not in teardown (so the connection can remain open after test fails), we could several long running connections even if we're not querying for anything. For that reason we could add optional option for 'self managed connection' - in short, we could open and close connection each time we perform an query.
The default behaviour of the library will not change, it will be only extra option that will open/close connection if it doesn't exist.
*** Settings ***
Library DatabaseLibrary auto_connect=${True}
Suite Setup Configure Connection ${params} # need to configure default connection
*** Test Cases ***
Test 1
Query SELECT * FROM table1 # will open and close connection on its own
Test 2
Query SELECT * FROM table2 # will open and close connection on its own
- Dominant language
- Python
- Stars
- 179
- Forks
- 178
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
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.
More from MarketSquare/Robotframework-Database-Library
-
new_client
Difficulty 3/5 1-2 days Newbie friendliness 48/100
MarketSquare/Robotframework-Database-Library#260 · 1 comment ·
-
docs
Difficulty 2/5 1-3 hours Newbie friendliness 35/100
-
Difficulty 3/5 1-2 days Newbie friendliness 52/100
MarketSquare/Robotframework-Database-Library#256 · 4 comments ·
-
improvement
Difficulty 5/5 Over a week Newbie friendliness 45/100
MarketSquare/Robotframework-Database-Library#255 · 2 comments ·
-
improvement
Difficulty 5/5 Over a week Newbie friendliness 25/100
All issues in MarketSquare/Robotframework-Database-Library
Similar issues
-
agent-ready documentation needs-triage
Difficulty 1/5 1-3 hours Newbie friendliness 88/100
-
documentation
Difficulty 1/5 Under an hour Newbie friendliness 91/100
-
workflow-status page template still says reusable workflows are "triggered only by workflow_call:" Open
Difficulty 1/5 Under an hour Newbie friendliness 92/100
-
instance instance add
Difficulty 1/5 Under an hour Newbie friendliness 72/100
searxng/searx-instances#939 · 1 comment ·
-
area-deployment area-integrations triage:bot-seen
Difficulty 2/5 Half a day Newbie friendliness 86/100