"""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("