Skip to content

~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.

6.2 KB
Raw Blame
"""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