~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
"""Tests for metrics database module."""
import pytest
from unittest.mock import MagicMock, Mock, patch # noqa: E402
from local_deep_research.metrics.database import MetricsDatabase # noqa: E402
class TestMetricsDatabaseInit:
"""Tests for MetricsDatabase initialization."""
def test_initializes_with_no_credentials(self):
"""Should initialize without credentials."""
db = MetricsDatabase()
assert db.username is None
assert db.password is None
def test_initializes_with_username(self):
"""Should store username if provided."""
db = MetricsDatabase(username="testuser")
assert db.username == "testuser"
assert db.password is None
def test_initializes_with_credentials(self):
"""Should store both username and password."""
db = MetricsDatabase(username="testuser", password="testpass")
assert db.username == "testuser"
assert db.password == "testpass"
class TestMetricsDatabaseGetSession:
"""Tests for get_session method."""
def test_yields_none_when_no_username_available(self):
"""Should yield None when no username available."""
db = MetricsDatabase()
with patch(
"local_deep_research.metrics.database.get_current_username",
return_value=None,
):
with db.get_session() as session:
assert session is None
def test_uses_provided_username(self):
"""Should use username provided to get_session."""
db = MetricsDatabase()
mock_session = MagicMock()
mock_cm = MagicMock()
mock_cm.__enter__ = Mock(return_value=mock_session)
mock_cm.__exit__ = Mock(return_value=None)
with patch(
"local_deep_research.metrics.database.get_user_db_session",
return_value=mock_cm,
):
with db.get_session(username="testuser") as session:
assert session == mock_session
def test_uses_stored_username_as_fallback(self):
"""Should use stored username if not provided."""
db = MetricsDatabase(username="stored_user")
mock_session = MagicMock()
mock_cm = MagicMock()
mock_cm.__enter__ = Mock(return_value=mock_session)
mock_cm.__exit__ = Mock(return_value=None)
with patch(
"local_deep_research.metrics.database.get_user_db_session",
return_value=mock_cm,
):
with db.get_session() as session:
assert session == mock_session
def test_uses_context_username_as_fallback(self):
"""Falls back to the request-context username when none provided."""
db = MetricsDatabase()
mock_session = MagicMock()
mock_cm = MagicMock()
mock_cm.__enter__ = Mock(return_value=mock_session)
mock_cm.__exit__ = Mock(return_value=None)
with patch(
"local_deep_research.metrics.database.get_current_username",
return_value="flask_user",
):
with patch(
"local_deep_research.metrics.database.get_user_db_session",
return_value=mock_cm,
):
with db.get_session() as session:
assert session == mock_session
def test_uses_thread_safe_access_with_password(self):
"""Should use thread metrics writer when password provided."""
db = MetricsDatabase(username="testuser", password="testpass")
mock_session = MagicMock()
mock_writer = MagicMock()
mock_cm = MagicMock()
mock_cm.__enter__ = Mock(return_value=mock_session)
mock_cm.__exit__ = Mock(return_value=None)
mock_writer.get_session.return_value = mock_cm
with patch(
"local_deep_research.database.thread_metrics.metrics_writer",
mock_writer,
):
with db.get_session() as session:
mock_writer.set_user_password.assert_called_with(
"testuser", "testpass"
)
assert session == mock_session
def test_overrides_stored_username(self):
"""Should use provided username over stored one."""
db = MetricsDatabase(username="stored")
mock_session = MagicMock()
mock_cm = MagicMock()
mock_cm.__enter__ = Mock(return_value=mock_session)
mock_cm.__exit__ = Mock(return_value=None)
with patch(
"local_deep_research.metrics.database.get_user_db_session",
return_value=mock_cm,
) as mock_get_session:
# Provide override username
with db.get_session(username="override"):
mock_get_session.assert_called_with("override")
def test_yields_none_when_context_username_missing(self):
"""Yields None (no raise) when no username is resolvable."""
db = MetricsDatabase()
with patch(
"local_deep_research.metrics.database.get_current_username",
return_value=None,
):
with db.get_session() as session:
assert session is None
class TestMetricsDatabaseContextManager:
"""Tests for context manager behavior."""
def test_context_manager_returns_session(self):
"""Context manager should yield a session."""
db = MetricsDatabase(username="testuser")
mock_session = MagicMock()
mock_cm = MagicMock()
mock_cm.__enter__ = Mock(return_value=mock_session)
mock_cm.__exit__ = Mock(return_value=None)
with patch(
"local_deep_research.metrics.database.get_user_db_session",
return_value=mock_cm,
):
with db.get_session() as session:
assert session is not None
def test_context_manager_handles_exceptions(self):
"""Context manager should handle exceptions properly."""
db = MetricsDatabase(username="testuser")
mock_cm = MagicMock()
mock_cm.__enter__ = Mock(side_effect=Exception("DB Error"))
mock_cm.__exit__ = Mock(return_value=None)
with patch(
"local_deep_research.metrics.database.get_user_db_session",
return_value=mock_cm,
):
with pytest.raises(Exception, match="DB Error"):
with db.get_session():
pass