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.

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