from __future__ import annotations
import json
from app.config import Settings
from app.pending_changes import ProposedChangeRequest
from app.storage.cli import main as cli_main
from app.storage.db import Database
from app.storage.importer import verify_import
from app.storage.pending_changes_db import PostgresPendingChangeRepository
def _document(title: str, body: str = "Body.\n") -> str:
return (
"---\n"
"owner: gmikcon\n"
"status: active\n"
"last_reviewed: 2026-11-19\n"
"review_interval: 90d\n"
"confidence: high\n"
"source_of_truth: test\n"
"---\n\n"
f"# {title}\n\n"
f"{body}"
)
def test_verify_import_matches_source(imported: tuple[Settings, Database]) -> None:
settings, database = imported
result = verify_import(settings, database)
assert result["ok"], result["differences"][:3]
assert result["file_manifest_digest"] == result["database_manifest_digest"]
assert result["file_counts"]["documents"] == result["database_counts"]["documents"]
def test_verify_import_detects_database_drift(
imported: tuple[Settings, Database]
) -> None:
settings, database = imported
target = "10-systems/applications/gitbucket.md"
repository = PostgresPendingChangeRepository(database, settings, via="api")
change = repository.create(
ProposedChangeRequest(
kind="doc",
target=target,
summary="Drift the database",
payload={"content": _document("GitBucket", "Drifted.\n")},
)
)
repository.apply(change["id"])
result = verify_import(settings, database)
assert result["ok"] is False
assert any(
difference["key"] == target and difference["issue"] == "hash_mismatch"
for difference in result["differences"]
)
def test_migrate_cli_imports_validates_and_writes_report(
database: Database, tmp_path, capsys
) -> None:
report_path = tmp_path / "migration-report.json"
exit_code = cli_main(
[
"migrate",
"--database-url",
database.url,
"--replace",
"--manifest",
str(report_path),
]
)
assert exit_code == 0
payload = json.loads(report_path.read_text(encoding="utf-8"))
assert payload["verification"]["ok"] is True
assert payload["reconciliation"]["ok"] is True
assert payload["reconciliation"]["difference_count"] == 0
assert payload["database_manifest_digest"]
assert payload["source_revision"]
assert "database_manifest" in payload
captured = capsys.readouterr()
assert '"verification"' in captured.out