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.

1.8 KB
Raw Blame
#!/usr/bin/env python3
"""
Script to create a database using the installed local-deep-research package.

This script is used by test_backwards_compatibility.py to create a database
with a previous version of the package, which is then tested for compatibility
with the current version.

Usage:
    python create_compat_db.py <db_dir> <username> <password>
"""

import sys
from importlib.metadata import version
from pathlib import Path

# Set up paths
db_dir = Path(sys.argv[1])
username = sys.argv[2]
password = sys.argv[3]

# Patch the data directory before importing
import local_deep_research.config.paths as paths_module  # noqa: E402

original_get_data_directory = paths_module.get_data_directory
paths_module.get_data_directory = lambda: db_dir

from local_deep_research.database.encrypted_db import DatabaseManager  # noqa: E402

# Create a fresh manager with patched path
manager = DatabaseManager()
assert manager.has_encryption, "Predecessor SQLCipher support is unavailable"
manager.data_dir = db_dir / "encrypted_databases"
manager.data_dir.mkdir(parents=True, exist_ok=True)

# Create the database
engine = manager.create_user_database(username, password)

# Add some test data
session = manager.get_session(username)
from local_deep_research.database.models import UserSettings  # noqa: E402

setting = UserSettings(
    key="test.backwards_compat",
    value={
        "version": "previous",
        "test": True,
        "package_version": version("local-deep-research"),
    },
    category="test",
)
session.add(setting)
session.commit()
session.close()

manager.close_user_database(username)
with manager._get_user_db_path(username).open("rb") as database_file:
    header = database_file.read(16)
assert len(header) == 16 and header != b"SQLite format 3\x00", (
    "The predecessor fixture must be an encrypted database"
)
print("Encrypted database created successfully")