diff --git a/server/tests/test_migration_tooling.py b/server/tests/test_migration_tooling.py new file mode 100644 index 0000000..6924d04 --- /dev/null +++ b/server/tests/test_migration_tooling.py @@ -0,0 +1,88 @@ +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