只是改个名称，为什么关联明细全没了？

"""SQLite replacement vs update: fresh in-memory fixtures, no real records."""
from contextlib import closing
from pathlib import Path
import csv
import json
import sqlite3
import sys


def connect():
    options = {"isolation_level": None}
    if sys.version_info >= (3, 12):
        options["autocommit"] = sqlite3.LEGACY_TRANSACTION_CONTROL
    db = sqlite3.connect(":memory:", **options)
    try:
        db.execute("PRAGMA foreign_keys = ON")
        assert db.execute("PRAGMA foreign_keys").fetchone() == (1,)
        db.execute("CREATE TABLE parent(id INTEGER PRIMARY KEY, name TEXT NOT NULL, note TEXT NOT NULL DEFAULT 'default-note')")
        db.execute("CREATE TABLE child(id INTEGER PRIMARY KEY, parent_id INTEGER NOT NULL REFERENCES parent(id) ON DELETE CASCADE)")
        db.execute("INSERT INTO parent VALUES (?, ?, ?)", (1, "old-name", "keep-note"))
        db.execute("INSERT INTO child VALUES (?, ?)", (10, 1))
        return db
    except BaseException:
        db.close()
        raise


def snapshot(db):
    return {"parents": [list(r) for r in db.execute("SELECT id, name, note FROM parent ORDER BY id")],
            "children": [list(r) for r in db.execute("SELECT id, parent_id FROM child ORDER BY id")],
            "foreign_key_violations": [list(r) for r in db.execute("PRAGMA foreign_key_check")]}


def main():
    assert sqlite3.sqlite_version_info >= (3, 24, 0), "UPSERT requires SQLite 3.24.0+"
    upsert = "INSERT INTO parent(id, name) VALUES (?, ?) ON CONFLICT(id) DO UPDATE SET name=excluded.name"
    cases = [
        ("replace_same_id", "INSERT OR REPLACE INTO parent(id, name) VALUES (?, ?)", (1, "new-name"),
         [[1, "new-name", "default-note"]], []),
        ("upsert_existing", upsert, (1, "new-name"), [[1, "new-name", "keep-note"]], [[10, 1]]),
        ("update_existing", "UPDATE parent SET name=? WHERE id=?", ("new-name", 1),
         [[1, "new-name", "keep-note"]], [[10, 1]]),
        ("upsert_new", upsert, (2, "new-name"),
         [[1, "old-name", "keep-note"], [2, "new-name", "default-note"]], [[10, 1]]),
    ]
    records = []
    for label, statement, parameters, expected_parents, expected_children in cases:
        with closing(connect()) as db:
            before = snapshot(db)
            db.execute(statement, parameters)
            direct_changes = db.execute("SELECT changes()").fetchone()[0]
            after = snapshot(db)
            assert direct_changes == 1
            assert after["parents"] == expected_parents, (label, after)
            assert after["children"] == expected_children, (label, after)
            assert after["foreign_key_violations"] == []
            assert db.execute("PRAGMA foreign_keys").fetchone() == (1,)
            records.append({"case": label, "sql": statement, "parameters": parameters,
                            "direct_changes": direct_changes, "before": before, "after": after})
    report = {"python": sys.version.split()[0], "sqlite": sqlite3.sqlite_version,
              "scope": "four isolated real SQLite in-memory databases, foreign_keys ON throughout; no concurrency or user-defined triggers",
              "cases": records}
    out = Path(__file__).resolve().parent / "replace-output"
    out.mkdir(exist_ok=True)
    (out / "report.json").write_text(json.dumps(report, indent=2) + "\n", encoding="utf-8")
    with (out / "effects.csv").open("w", encoding="utf-8-sig", newline="") as file:
        writer = csv.DictWriter(file, fieldnames=["case", "direct_changes", "parents", "children", "violations"])
        writer.writeheader()
        for row in records:
            writer.writerow({"case": row["case"], "direct_changes": row["direct_changes"],
                "parents": json.dumps(row["after"]["parents"]), "children": json.dumps(row["after"]["children"]),
                "violations": json.dumps(row["after"]["foreign_key_violations"])})
    print(json.dumps(report, indent=2))
    print("PASS: same-ID replacement, cascading children, omitted defaults, upsert branches and direct-change counts")


if __name__ == "__main__":
    main()