游戏内容导表不能只有一道校验：结构、业务与运行时语义如何分权

# tools/content_validate.py · validate
def validate(conn: sqlite3.Connection) -> list:
    conn.row_factory = sqlite3.Row
    errors: list = []
    _validate_categories(conn, errors)
    _validate_rarities(conn, errors)
    _validate_item_definitions(conn, errors)
    _validate_equipment(conn, errors)
    _validate_heroes(conn, errors)
    _validate_monsters(conn, errors)
    _validate_levels(conn, errors)
    _validate_drops(conn, errors)
    return errors

# scripts/content/content_database.gd · export_content_tables
func export_content_tables() -> Dictionary:
    var tables := _item_catalog.export_tables()
    tables.merge(_world_catalog.export_tables())
    return tables

# scripts/content/content_validator.gd · validate
func validate(content) -> Dictionary:
    var tables: Dictionary = content.export_content_tables()
    var errors: Array[String] = []
    _validate_required_tables(tables, errors)
    if not errors.is_empty():
        return _result(errors)
    _validate_categories(tables, errors)
    _validate_rarities(tables, errors)
    _validate_item_definitions(tables, errors)
    _validate_equipment(tables, errors)
    _validate_world(tables, errors)
    _validate_progression_shape(content, tables, errors)
    return _result(errors)

# tools/xlsx_to_db.py · check / run
def check(conn: sqlite3.Connection) -> list:
    errors = []
    fk_failures = conn.execute("PRAGMA foreign_key_check").fetchall()
    for fail in fk_failures:
        errors.append("FOREIGN_KEY_VIOLATION_%s" % str(fail[0]).upper())
    errors.extend(content_validate.validate(conn))
    return errors

def run(xlsx_path: Path, out_path: Path, content_version) -> int:
    tmp_path = out_path.with_suffix(".db.tmp")
    if tmp_path.exists():
        tmp_path.unlink()
    conn = sqlite3.connect(tmp_path)
    try:
        build(conn, xlsx_path, content_version)
        errors = check(conn)
        if errors:
            conn.close()
            tmp_path.unlink()
            return 1
        conn.commit()
    except BuildError:
        if tmp_path.exists():
            tmp_path.unlink()
        return 1
    finally:
        conn.close()
    tmp_path.replace(out_path)
    return 0

# tools/roundtrip_test.py · test_error_detection（节选）
wb = load_workbook(tmp_xlsx)
ws = wb["monsters"]
hp_col = [ws.cell(2, c).value for c in range(
    1, ws.max_column + 1
)].index("max_hp") + 1
ws.cell(cs.HEADER_ROWS + 1, hp_col, "abc")
wb.save(tmp_xlsx)
r1 = run_cmd(["xlsx_to_db.py", "--xlsx", str(tmp_xlsx),
              "--out", str(tmp_db)])

wb = load_workbook(tmp_xlsx)
ws = wb["levels"]
mid_col = [ws.cell(2, c).value for c in range(
    1, ws.max_column + 1
)].index("monster_id") + 1
ws.cell(cs.HEADER_ROWS + 1, mid_col, "ghost_monster")
wb.save(tmp_xlsx)
r2 = run_cmd(["xlsx_to_db.py", "--xlsx", str(tmp_xlsx),
              "--out", str(tmp_db)])

# 当天固定坏样本：仅修改内存副本
src = sqlite3.connect("data/content/content.db")
mem = sqlite3.connect(":memory:")
src.backup(mem)
mem.execute(
    "UPDATE levels SET next_id='missing_level' WHERE id='level_1'"
)
errors = validate(mem)
assert errors == ["LEVEL_NEXT_INVALID_LEVEL_1"]

cd "$PROJECT_ROOT"
/usr/bin/time -p python3 tools/roundtrip_test.py
/usr/bin/time -p Godot --headless --path . \
  --script scripts/dev/content_validation_smoke_test.gd
/usr/bin/time -p python3 - <<'PY'
import sqlite3
from tools.content_validate import validate
src = sqlite3.connect("data/content/content.db")
mem = sqlite3.connect(":memory:")
src.backup(mem)
mem.execute(
    "UPDATE levels SET next_id='missing_level' WHERE id='level_1'"
)
errors = validate(mem)
print("FIXED_OUTPUT", ",".join(errors))
assert errors == ["LEVEL_NEXT_INVALID_LEVEL_1"]
PY

round-trip: 13 tables matched
invalid type: monsters!E4 expected int, got 'abc'
dangling ref: levels!D4 ghost_monster not in monsters
result: round-trip passed, error interception passed
real 6.70

CONTENT_VALIDATION_SMOKE_OK
real 2.00

FIXED_INPUT level_1.next_id=missing_level
FIXED_OUTPUT LEVEL_NEXT_INVALID_LEVEL_1
FIXED_ASSERT_OK errors=1
real 0.11

exit=0  passed=3  failed=0  skipped=0  process_time=8.81s