openvax / datacache

75%

master: 79%

LAST BUILD ON BRANCH fix-45-sqlite-cross-thread

branch: fix-45-sqlite-cross-thread

CHANGE BRANCH

x

Reset

• fix-45-sqlite-cross-thread
• adding-timeout-parameter-and-removing-fasta-helpers
• fix-17-quote-sql-identifiers
• fix-40-assert-to-raise
• fix-49-streaming-download
• fix-flaky-download-test
• fix-lint
• fix-releasing-docs
• master
• migrate-pyproject-toml
• modernize-py3
• release-1.6.0
• try-using-wget

Build # 27777600153

Build Type

Pull #50

github

Committed by iskandr

Commit Message

Fix #45: allow cached SQLite connection to be reused across threads

Open the sqlite3 connection with check_same_thread=False so that
long-running / interactive consumers (e.g. pyensembl) can issue queries
from a different thread than the one which opened the connection without
hitting "SQLite objects created in a thread can only be used in that same
thread". datacache databases are written once and read-only thereafter,
so cross-thread reuse is safe.

Adds a regression test that queries a connection from a second thread.

Claude-Session: https://claude.ai/code/session_011bzfZPTzWnhAMVD7msyMg1

Pull Request Pull Request #50: Fix #45: allow cached SQLite connection to be reused across threads

Coverage Stats

1 of 0 new or added lines in 0 files covered. (NaN%)

10 existing lines in 1 file now uncovered.

313 of 419 relevant lines covered (74.7%)

2.24 hits per line