{
  "python": "3.14.4 (main, Apr  7 2026, 13:13:20) [Clang 21.0.0 (clang-2100.0.123.102)]",
  "sqlite": "3.51.3",
  "platform": "macOS-27.0.1-arm64-arm-64bit-Mach-O",
  "source": "examples/system-design/labs/12/shortlink.py",
  "sha256": "fd7eab28b63bb285eb524f588257b1a39555e8debee92e2b68fc8ecc8f30f17f"
}
$ /opt/homebrew/opt/python@3.14/bin/python3.14 examples/system-design/labs/12/shortlink.py
{"created": 1, "conflicts": 11, "rows": 1, "winner": "https://example.org/0", "revoked_safe": null, "revoked_cached": "https://example.org/0"}
PASS: unique insert never overwrites and authority gate denies revoked link

EXIT_CODE=0
$ /opt/homebrew/opt/python@3.14/bin/python3.14 examples/system-design/labs/12/shortlink.py --unsafe
{"created": 1, "conflicts": 11, "rows": 1, "winner": "https://example.org/11", "revoked_safe": null, "revoked_cached": "https://example.org/11"}
EXPECTED_REJECTION: cached redirect survives revocation

EXIT_CODE=2