"""Offline behavior tests for the read-only migration preflight.""" import contextlib import importlib.util import io import os import tempfile import urllib.error from unittest.mock import patch from pathlib import Path import unittest ROOT = Path(__file__).resolve().parents[2] spec = importlib.util.spec_from_file_location("preflight", ROOT / "scripts/migration-preflight.py") m = importlib.util.module_from_spec(spec) spec.loader.exec_module(m) PREFIX = "server/skillhub-app/src/main/resources/db/migration/" class PreflightTest(unittest.TestCase): def test_status_and_rename_boundaries(self): path = PREFIX + "V001__new.sql" self.assertEqual(m.introduced_version(dict(filename=path, status="added")), 1) for status in ("modified", "removed", "copied"): self.assertIsNone(m.introduced_version(dict(filename=path, status=status))) self.assertIsNone(m.introduced_version(dict(filename=path, status="renamed", previous_filename=PREFIX + "V1__old.sql"))) self.assertEqual(m.introduced_version(dict(filename=path, status="renamed", previous_filename=PREFIX + "V2__old.sql")), 1) for path in ("tests/V1__fake.sql", PREFIX + "V1_2__other.sql", PREFIX + "V1__new.sql/no"): self.assertIsNone(m.introduced_version(dict(filename=path, status="added"))) def test_multiple_collisions_sorted_and_single_pr_not_collision(self): class API: def pages(self, path, limit=None): if path.startswith("/pulls?"): return [dict(number=n, head=dict(sha=str(n)), base=dict(sha="base")) for n in (9, 2)] return [dict(filename=PREFIX + f"V{v}__a.sql", status="added") for v in (20, 3, 3)] def get(self, path): return dict(head=dict(sha=path.split("/")[-1]), state="open", base=dict(sha="base"), changed_files=3) collisions, errors, count = m.scan(API()) self.assertEqual(list(collisions), [3, 20]) self.assertEqual(errors, []) self.assertEqual(count, 2) report = m.summary(collisions, errors, count) self.assertLess(report.index("PR #2"), report.index("PR #9")) self.assertEqual(report.count("PR #2:"), 2) def test_incomplete_never_reports_clearance(self): report = m.summary({}, ["API HTTP 403"], 3) self.assertIn("scan incomplete", report) self.assertNotIn("No cross-PR", report) def test_untrusted_filename_is_text(self): attack = PREFIX + "V1__\n::error::x.sql" report = m.summary({1: {2: [attack], 3: [PREFIX + "V1__a.sql"]}}, [], 2) self.assertNotIn("