~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/session_context.py.
Focuses on uncovered branches that exercised Flask-`g` paths
(`g.db_session`, `g.user_password`) — those branches are gone after
the migration to contextvars; what remains here drives the contextvar
code paths directly.
"""
from unittest.mock import MagicMock, patch
import pytest # noqa: E402
MODULE = "local_deep_research.database.session_context"
# ---------------------------------------------------------------------------
# Constants
# ---------------------------------------------------------------------------
class TestConstants:
def test_unencrypted_placeholder_is_string(self):
from local_deep_research.database.session_context import ( # noqa: E402
UNENCRYPTED_DB_PLACEHOLDER,
)
assert isinstance(UNENCRYPTED_DB_PLACEHOLDER, str)
assert len(UNENCRYPTED_DB_PLACEHOLDER) > 0
def test_database_session_error_is_exception(self):
from local_deep_research.database.session_context import ( # noqa: E402
DatabaseSessionError,
)
assert issubclass(DatabaseSessionError, Exception)
# ---------------------------------------------------------------------------
# get_user_db_session – happy paths
# ---------------------------------------------------------------------------
class TestGetUserDbSessionHappyPaths:
def test_yields_thread_local_session(self):
"""get_user_db_session yields the per-user thread-local session.
The old Flask ``g.db_session`` shortcut is gone post-migration —
every call resolves a password and opens (or reuses) the user's
thread-local SQLCipher session via get_metrics_session.
"""
from local_deep_research.database.session_context import ( # noqa: E402
get_user_db_session,
)
mock_sess = MagicMock()
with (
patch(
f"{MODULE}.get_search_context",
return_value={"user_password": "pw"},
),
patch(f"{MODULE}.db_manager") as mock_db,
patch(
"local_deep_research.database.thread_local_session.thread_session_manager.get_session",
return_value=mock_sess,
),
):
mock_db.has_encryption = True
with get_user_db_session(username="alice") as sess:
assert sess is mock_sess
def test_unencrypted_db_uses_placeholder_password( # DevSkim: ignore DS101155
self,
):
"""When no password and db is unencrypted, placeholder password is used.""" # DevSkim: ignore DS101155
from local_deep_research.database.session_context import ( # noqa: E402
get_user_db_session,
)
mock_sess = MagicMock()
with (
patch(f"{MODULE}.get_search_context", return_value=None),
patch(f"{MODULE}.db_manager") as mock_db,
patch(
"local_deep_research.database.thread_local_session.thread_session_manager.get_session",
return_value=mock_sess,
),
):
mock_db.has_encryption = False
with get_user_db_session(username="alice") as sess:
assert sess is mock_sess
def test_password_from_thread_context(self):
"""Password is retrieved from thread search context."""
from local_deep_research.database.session_context import ( # noqa: E402
get_user_db_session,
)
mock_sess = MagicMock()
with (
patch(
f"{MODULE}.get_search_context",
return_value={"user_password": "thread_pw"},
),
patch(f"{MODULE}.db_manager") as mock_db,
patch(
"local_deep_research.database.thread_local_session.thread_session_manager.get_session",
return_value=mock_sess,
),
):
mock_db.has_encryption = True
with get_user_db_session(username="alice") as sess:
assert sess is mock_sess
# ---------------------------------------------------------------------------
# get_user_db_session – error paths
# ---------------------------------------------------------------------------
class TestGetUserDbSessionErrors:
def test_no_username_raises(self):
from local_deep_research.database.session_context import ( # noqa: E402
get_user_db_session,
DatabaseSessionError,
)
with pytest.raises(DatabaseSessionError, match="No authenticated user"):
with get_user_db_session():
pass
def test_encrypted_db_no_password_raises(self):
from local_deep_research.database.session_passwords import (
SessionPasswordStore,
)
from local_deep_research.database.session_context import ( # noqa: E402
get_user_db_session,
DatabaseSessionError,
)
with (
patch(f"{MODULE}.get_search_context", return_value=None),
patch(f"{MODULE}.db_manager") as mock_db,
# The missing-password premise also requires no active session.
# Other tests may have populated the process-wide store for alice.
patch(
"local_deep_research.database.session_passwords.session_password_store",
SessionPasswordStore(),
),
):
mock_db.has_encryption = True
with pytest.raises(DatabaseSessionError, match="requires password"):
with get_user_db_session(username="alice"):
pass
def test_failed_session_raises(self):
"""When get_metrics_session returns None, DatabaseSessionError is raised."""
from local_deep_research.database.session_context import ( # noqa: E402
get_user_db_session,
DatabaseSessionError,
)
with (
patch(f"{MODULE}.get_search_context", return_value=None),
patch(f"{MODULE}.db_manager") as mock_db,
patch(
"local_deep_research.database.thread_local_session.thread_session_manager.get_session",
return_value=None,
),
):
mock_db.has_encryption = False
with pytest.raises(
DatabaseSessionError, match="Could not establish session"
):
with get_user_db_session(username="alice"):
pass
# ---------------------------------------------------------------------------
# with_user_database decorator
# ---------------------------------------------------------------------------
class TestWithUserDatabase:
def test_injects_session_as_first_arg(self):
from local_deep_research.database.session_context import ( # noqa: E402
with_user_database,
)
mock_sess = MagicMock()
@with_user_database
def my_func(db_session, x, y=0):
return (db_session, x + y)
with patch(f"{MODULE}.get_user_db_session") as mock_ctx:
mock_ctx.return_value.__enter__ = MagicMock(return_value=mock_sess)
mock_ctx.return_value.__exit__ = MagicMock(return_value=False)
result = my_func(10, y=5)
assert result == (mock_sess, 15)
def test_passes_username_and_password_from_kwargs(self):
from local_deep_research.database.session_context import ( # noqa: E402
with_user_database,
)
@with_user_database
def my_func(db_session):
return db_session
mock_sess = MagicMock()
with patch(f"{MODULE}.get_user_db_session") as mock_ctx:
mock_ctx.return_value.__enter__ = MagicMock(return_value=mock_sess)
mock_ctx.return_value.__exit__ = MagicMock(return_value=False)
result = my_func(_username="alice", _password="pw")
mock_ctx.assert_called_once_with("alice", "pw")
assert result is mock_sess
# ---------------------------------------------------------------------------
# DatabaseAccessMixin
# ---------------------------------------------------------------------------
class TestDatabaseAccessMixin:
def test_get_db_session_raises_deprecation_warning(self):
from local_deep_research.database.session_context import ( # noqa: E402
DatabaseAccessMixin,
)
class MyService(DatabaseAccessMixin):
pass
svc = MyService()
with pytest.raises(DeprecationWarning):
svc.get_db_session()
def test_get_db_session_message_content(self):
from local_deep_research.database.session_context import ( # noqa: E402
DatabaseAccessMixin,
)
svc = DatabaseAccessMixin()
try:
svc.get_db_session()
except DeprecationWarning as e:
assert "deprecated" in str(
e
).lower() or "get_user_db_session" in str(e)