~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 query_utils module."""
from sqlalchemy import Column, DateTime, String
from sqlalchemy.orm import declarative_base
from datetime import datetime, timedelta, UTC
from local_deep_research.metrics.query_utils import (
get_period_cutoff,
get_period_days,
get_research_mode_condition,
get_time_filter_condition,
)
# Create a model for SQLAlchemy column testing
Base = declarative_base()
class QueryTestModel(Base):
"""Model for SQLAlchemy column comparisons."""
__tablename__ = "query_test_table"
id = Column(String, primary_key=True)
timestamp = Column(DateTime)
mode = Column(String)
class TestGetPeriodDays:
"""Tests for get_period_days — single period vocabulary (both UIs)."""
def test_all_returns_none(self):
assert get_period_days("all") is None
def test_dashboard_vocabulary(self):
# Main dashboard / context-overflow buttons send these.
assert get_period_days("7d") == 7
assert get_period_days("30d") == 30
assert get_period_days("3m") == 90
assert get_period_days("1y") == 365
def test_link_analytics_vocabulary(self):
# The standalone link-analytics page sends these aliases; they must
# resolve to the same day counts as 3m/1y.
assert get_period_days("90d") == 90
assert get_period_days("365d") == 365
def test_unknown_uses_default(self):
assert get_period_days("nonsense") == 30
assert get_period_days("nonsense", default=7) == 7
class TestGetPeriodCutoff:
"""Tests for get_period_cutoff function."""
def test_returns_none_for_all(self):
assert get_period_cutoff("all") is None
def test_known_periods_map_to_days(self):
now = datetime.now(UTC)
for period, days in [
("7d", 7),
("30d", 30),
("3m", 90),
("90d", 90),
("1y", 365),
("365d", 365),
]:
cutoff = get_period_cutoff(period)
expected = now - timedelta(days=days)
assert abs((cutoff - expected).total_seconds()) < 5, period
def test_unknown_period_defaults_to_30_days(self):
cutoff = get_period_cutoff("month") # old vocabulary, no longer valid
expected = datetime.now(UTC) - timedelta(days=30)
assert abs((cutoff - expected).total_seconds()) < 5
class TestGetTimeFilterCondition:
"""Tests for get_time_filter_condition function."""
def test_returns_none_for_all_period(self):
"""Should return None when period is 'all'."""
result = get_time_filter_condition("all", QueryTestModel.timestamp)
assert result is None
def test_returns_condition_for_7_days(self):
"""Should return a BinaryExpression for 7 days period."""
result = get_time_filter_condition("7d", QueryTestModel.timestamp)
assert result is not None
# Should be a comparison expression
assert hasattr(result, "left") or hasattr(result, "compare")
def test_returns_condition_for_30_days(self):
"""Should return a condition for 30 days period."""
result = get_time_filter_condition("30d", QueryTestModel.timestamp)
assert result is not None
def test_returns_condition_for_3_months(self):
"""Should return a condition for 90 days (3 months)."""
result = get_time_filter_condition("3m", QueryTestModel.timestamp)
assert result is not None
def test_returns_condition_for_1_year(self):
"""Should return a condition for 365 days (1 year)."""
result = get_time_filter_condition("1y", QueryTestModel.timestamp)
assert result is not None
def test_defaults_to_30_days_for_unknown_period(self):
"""Should default to 30 days for unknown period strings."""
result = get_time_filter_condition("unknown", QueryTestModel.timestamp)
# Should return condition (defaults to 30d)
assert result is not None
def test_defaults_to_30_days_for_empty_period(self):
"""Should default to 30 days for empty period string."""
result = get_time_filter_condition("", QueryTestModel.timestamp)
assert result is not None
def test_all_valid_periods(self):
"""All standard periods should return conditions."""
periods = ["7d", "30d", "3m", "1y"]
for period in periods:
result = get_time_filter_condition(period, QueryTestModel.timestamp)
assert result is not None, (
f"Period {period} should return a condition"
)
class TestGetResearchModeCondition:
"""Tests for get_research_mode_condition function."""
def test_returns_none_for_all_mode(self):
"""Should return None when research_mode is 'all'."""
result = get_research_mode_condition("all", QueryTestModel.mode)
assert result is None
def test_returns_condition_for_quick(self):
"""Should return condition for 'quick' mode."""
result = get_research_mode_condition("quick", QueryTestModel.mode)
assert result is not None
def test_returns_condition_for_detailed(self):
"""Should return condition for 'detailed' mode."""
result = get_research_mode_condition("detailed", QueryTestModel.mode)
assert result is not None
def test_returns_none_for_unknown_mode(self):
"""Should return None for unknown mode strings."""
result = get_research_mode_condition("unknown", QueryTestModel.mode)
assert result is None
def test_returns_none_for_empty_mode(self):
"""Should return None for empty mode string."""
result = get_research_mode_condition("", QueryTestModel.mode)
assert result is None
def test_quick_and_detailed_are_valid_modes(self):
"""Only 'quick' and 'detailed' should return conditions."""
# Valid modes
assert (
get_research_mode_condition("quick", QueryTestModel.mode)
is not None
)
assert (
get_research_mode_condition("detailed", QueryTestModel.mode)
is not None
)
# Invalid modes
assert get_research_mode_condition("fast", QueryTestModel.mode) is None
assert get_research_mode_condition("slow", QueryTestModel.mode) is None