~95% on SimpleQA (e.g. Qwen3.6-27B on a 3090). Supports all local and cloud LLMs (llama.cpp, Ollama, Google, ...). 10+ search engines - arXiv, PubMed, your private documents. Everything Local & Encrypted.
Python academiaanthropicarxivbravedeep-researchencryptionhome-automationhomeserverlocallocal-deep-researchlocal-llmmistralollamaopenaipubmedresearchresearch-toolretrieval-augmented-generationsearxngself-hosted
"""Deep coverage tests for database/thread_local_session.py.
Focuses on:
- ThreadLocalSessionManager.get_session: session reuse, invalid session recovery,
PendingRollbackError rollback then re-execute fails -> new session
- ThreadLocalSessionManager.cleanup_all
- Module-level helpers: get_metrics_session, get_current_thread_session,
cleanup_current_thread
- _ThreadCleanup: clear_settings_context and clear_search_context exception paths
- ThreadSessionContext: None session handling
"""
import threading
from unittest.mock import MagicMock, patch
import pytest
from sqlalchemy.exc import PendingRollbackError
MODULE = "local_deep_research.database.thread_local_session"
def _make_manager():
from local_deep_research.database.thread_local_session import (
ThreadLocalSessionManager,
)
return ThreadLocalSessionManager()
# ---------------------------------------------------------------------------
# get_session – full coverage of branches
# ---------------------------------------------------------------------------
class TestGetSessionBranches:
def test_reuses_valid_session(self):
"""When an existing valid session is in thread-local, it is reused."""
mgr = _make_manager()
valid_sess = MagicMock()
mgr._local.session = valid_sess
mgr._local.username = "alice"
result = mgr.get_session("alice", "pw")
assert result is valid_sess
valid_sess.execute.assert_called()
def test_pending_rollback_then_re_execute_fails_creates_new(self):
"""PendingRollbackError, rollback succeeds but SELECT 1 again fails."""
mgr = _make_manager()
broken_sess = MagicMock()
broken_sess.execute.side_effect = [
PendingRollbackError("pending"),
Exception("still broken"), # second execute after rollback fails
]
mgr._local.session = broken_sess
mgr._local.username = "alice"
new_sess = MagicMock()
with patch(f"{MODULE}.db_manager") as mock_db:
mock_db.open_user_database.return_value = MagicMock()
mock_db.create_thread_safe_session_for_metrics.return_value = (
new_sess
)
result = mgr.get_session("alice", "pw")
assert result is new_sess
def test_generic_exception_invalidates_session(self):
"""Any exception from execute causes cleanup and new session creation."""
mgr = _make_manager()
broken_sess = MagicMock()
broken_sess.execute.side_effect = OSError("db file locked")
mgr._local.session = broken_sess
mgr._local.username = "alice"
new_sess = MagicMock()
with patch(f"{MODULE}.db_manager") as mock_db:
mock_db.open_user_database.return_value = MagicMock()
mock_db.create_thread_safe_session_for_metrics.return_value = (
new_sess
)
result = mgr.get_session("alice", "pw")
assert result is new_sess
def test_credentials_tracked_after_new_session(self):
mgr = _make_manager()
new_sess = MagicMock()
with patch(f"{MODULE}.db_manager") as mock_db:
mock_db.open_user_database.return_value = MagicMock()
mock_db.create_thread_safe_session_for_metrics.return_value = (
new_sess
)
mgr.get_session("bob", "s3cr3t")
tid = threading.get_ident()
assert mgr._thread_credentials.get(tid) == ("bob", "s3cr3t")
# ---------------------------------------------------------------------------
# cleanup_all
# ---------------------------------------------------------------------------
class TestCleanupAll:
def test_cleanup_all_calls_cleanup_for_all_tracked_threads(self):
mgr = _make_manager()
mgr._thread_credentials[111] = ("a", "pw")
mgr._thread_credentials[222] = ("b", "pw")
called_with = []
def track_cleanup(tid=None):
called_with.append(tid)
mgr.cleanup_thread = track_cleanup
mgr.cleanup_all()
# Both thread IDs should have been cleaned up
assert len(called_with) == 2
# ---------------------------------------------------------------------------
# Module-level helpers
# ---------------------------------------------------------------------------
class TestModuleLevelHelpers:
def test_get_metrics_session_delegates_to_manager(self):
from local_deep_research.database.thread_local_session import (
get_metrics_session,
)
mock_sess = MagicMock()
with patch(f"{MODULE}.thread_session_manager") as mock_mgr:
mock_mgr.get_session.return_value = mock_sess
result = get_metrics_session("alice", "pw")
assert result is mock_sess
mock_mgr.get_session.assert_called_once_with("alice", "pw")
def test_get_current_thread_session_delegates(self):
from local_deep_research.database.thread_local_session import (
get_current_thread_session,
)
mock_sess = MagicMock()
with patch(f"{MODULE}.thread_session_manager") as mock_mgr:
mock_mgr.get_current_session.return_value = mock_sess
result = get_current_thread_session()
assert result is mock_sess
def test_cleanup_current_thread_delegates(self):
from local_deep_research.database.thread_local_session import (
cleanup_current_thread,
)
with patch(f"{MODULE}.thread_session_manager") as mock_mgr:
cleanup_current_thread()
mock_mgr.cleanup_thread.assert_called_once_with()
# ---------------------------------------------------------------------------
# _ThreadCleanup – exception suppression paths
# ---------------------------------------------------------------------------
class TestThreadCleanupExceptionPaths:
def test_clear_settings_context_exception_suppressed(self):
from local_deep_research.database.thread_local_session import (
_ThreadCleanup,
)
with (
patch(f"{MODULE}.cleanup_current_thread"),
patch(
"local_deep_research.config.thread_settings.clear_settings_context",
side_effect=RuntimeError("settings boom"),
create=True,
),
):
with _ThreadCleanup():
pass # Should not raise
def test_clear_search_context_exception_suppressed(self):
from local_deep_research.database.thread_local_session import (
_ThreadCleanup,
)
with (
patch(f"{MODULE}.cleanup_current_thread"),
patch(
"local_deep_research.utilities.thread_context.clear_search_context",
side_effect=RuntimeError("search boom"),
create=True,
),
):
with _ThreadCleanup():
pass # Should not raise
def test_returns_false_from_exit(self):
"""__exit__ returns False to propagate exceptions from the body."""
from local_deep_research.database.thread_local_session import (
_ThreadCleanup,
)
with patch(f"{MODULE}.cleanup_current_thread"):
cm = _ThreadCleanup()
cm.__enter__()
result = cm.__exit__(None, None, None)
assert result is False
# ---------------------------------------------------------------------------
# ThreadSessionContext – None session
# ---------------------------------------------------------------------------
class TestThreadSessionContextNone:
def test_none_session_is_yielded(self):
from local_deep_research.database.thread_local_session import (
ThreadSessionContext,
)
with patch(f"{MODULE}.get_metrics_session", return_value=None):
with ThreadSessionContext("alice", "pw") as sess:
assert sess is None
def test_exception_in_body_propagates(self):
from local_deep_research.database.thread_local_session import (
ThreadSessionContext,
)
mock_sess = MagicMock()
with patch(f"{MODULE}.get_metrics_session", return_value=mock_sess):
with pytest.raises(ValueError, match="body error"):
with ThreadSessionContext("alice", "pw"):
raise ValueError("body error")