~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 migration 0025's context-warning dismissal split."""
import json
from importlib import import_module
import pytest
from alembic import command
from sqlalchemy import create_engine, text
from local_deep_research.database.alembic_runner import get_alembic_config
LEGACY = "app.warnings.dismiss_context_reduced"
BELOW = "app.warnings.dismiss_context_below_history"
TRUNCATION = "app.warnings.dismiss_context_truncation_history"
def _migrate(engine, revision, downgrade=False):
config = get_alembic_config(engine)
with engine.begin() as conn:
config.attributes["connection"] = conn
(command.downgrade if downgrade else command.upgrade)(config, revision)
def _seed(engine, key, value):
with engine.begin() as conn:
conn.execute(
text(
"INSERT INTO settings "
"(key, value, type, name, ui_element, visible, editable) "
"VALUES (:key, :value, 'app', :key, 'checkbox', 1, 1)"
),
{"key": key, "value": json.dumps(value)},
)
def _read(engine, key):
with engine.begin() as conn:
value = conn.execute(
text("SELECT value FROM settings WHERE key = :key"), {"key": key}
).scalar_one_or_none()
return None if value is None else json.loads(value)
@pytest.fixture
def engine_at_0024(tmp_path):
engine = create_engine(f"sqlite:///{tmp_path / 'migration_0025.db'}")
_migrate(engine, "0024")
yield engine
engine.dispose()
@pytest.mark.parametrize("dismissed", [False, True])
def test_upgrade_copies_legacy_value_to_both_keys(engine_at_0024, dismissed):
_seed(engine_at_0024, LEGACY, dismissed)
_migrate(engine_at_0024, "0025")
assert _read(engine_at_0024, LEGACY) is None
assert _read(engine_at_0024, BELOW) is dismissed
assert _read(engine_at_0024, TRUNCATION) is dismissed
def test_upgrade_preserves_existing_target_and_fills_missing(engine_at_0024):
_seed(engine_at_0024, LEGACY, True)
_seed(engine_at_0024, BELOW, False)
_migrate(engine_at_0024, "0025")
assert _read(engine_at_0024, BELOW) is False
assert _read(engine_at_0024, TRUNCATION) is True
assert _read(engine_at_0024, LEGACY) is None
def test_upgrade_without_legacy_is_clean_noop(engine_at_0024):
_seed(engine_at_0024, BELOW, True)
_migrate(engine_at_0024, "0025")
assert _read(engine_at_0024, BELOW) is True
assert _read(engine_at_0024, TRUNCATION) is None
def test_upgrade_is_idempotent(engine_at_0024):
_seed(engine_at_0024, LEGACY, True)
_migrate(engine_at_0024, "0025")
_migrate(engine_at_0024, "0025")
assert _read(engine_at_0024, BELOW) is True
assert _read(engine_at_0024, TRUNCATION) is True
def test_copy_supports_legacy_schema_without_metadata_columns(tmp_path):
migration = import_module(
"local_deep_research.database.migrations.versions."
"0025_split_context_warning_dismissals"
)
engine = create_engine(f"sqlite:///{tmp_path / 'legacy_settings.db'}")
try:
with engine.begin() as conn:
conn.execute(
text(
"CREATE TABLE settings ("
"key TEXT PRIMARY KEY, value TEXT NOT NULL)"
)
)
conn.execute(
text("INSERT INTO settings (key, value) VALUES (:key, :value)"),
{"key": LEGACY, "value": json.dumps(True)},
)
migration._copy_setting_if_missing(conn, LEGACY, BELOW)
assert _read(engine, BELOW) is True
finally:
engine.dispose()
def test_downgrade_uses_truncation_value_and_removes_split_keys(engine_at_0024):
_seed(engine_at_0024, LEGACY, False)
_migrate(engine_at_0024, "0025")
with engine_at_0024.begin() as conn:
conn.execute(
text("UPDATE settings SET value = :value WHERE key = :key"),
{"value": json.dumps(True), "key": TRUNCATION},
)
_migrate(engine_at_0024, "0024", downgrade=True)
assert _read(engine_at_0024, LEGACY) is True
assert _read(engine_at_0024, BELOW) is None
assert _read(engine_at_0024, TRUNCATION) is None
def test_0025_chains_to_0024():
from alembic.config import Config
from alembic.script import ScriptDirectory
from local_deep_research.database.alembic_runner import get_migrations_dir
config = Config()
config.set_main_option("script_location", str(get_migrations_dir()))
script = ScriptDirectory.from_config(config)
assert script.get_revision("0025").down_revision == "0024"