IU Core MVP — 11 Final Report

Date: 2026-05-21 Macro: v0.6-iu-core-mvp-pg-native-parent-child-structure-ops-authoring Result: IU_CORE_MVP_AUTHORING_PASS Production mutation: NONE · DDL executed: NO · DB write: NO · Deploy: NO

Outcome

IU_CORE_MVP_AUTHORING_PASS — a repo-backed, author-only IU Core MVP package: PG-native IU↔SQL link, two-way event/route model, multi-level parent-child containment, and add/split/merge/delete structure operations with lineage.

What changed

• Repo: /Users/nmhuyen/iu-cutter-build/repo/iu-cutter, branch main.
• HEAD before f111d4a → HEAD after d22e361 (commit d22e361, parent f111d4a, 16 files, +1609, additive-only).
• New sql/iu-core/ — 5 forward migrations + 5 rollbacks + README.
  • 001 iu_sql_link · 002 routes (iu_sql_event_route, iu_outbound_route, iu_route_attempt) · 003 parent-child (iu_tree_path + view v_iu_tree) · 004 lineage (iu_structure_operation, iu_relation) · 005 functions + view v_iu_sql_link_resolved (no trigger attached).
• New cutter_agent/iu_core/ — pure helpers: idempotency.py, tree.py, structure_ops.py.
• New tests/test_iu_core_ddl.py — 33 tests.

Branch outcomes

Branch	Result
B0 Precheck + live survey	PASS — host/repo/KB/DB confirmed; briefs reconciled, zero contradiction
B1 Discover-first inventory	PASS — REUSE/EXTEND/REJECT recorded for every candidate
B2 Architecture lock + gap matrix	PASS — 8 FACT, 8 PROPOSAL, 7 NEEDS_RULING
B3 DDL migration + rollback	PASS — 5 forward + 5 rollback authored
B4 Parent-child multi-level	PASS — iu_tree_path + v_iu_tree + 3-layer cycle prevention
B5 Structure ops contract	PASS — 6 ops, lineage, governance, idempotency, status machine
B6 PG-native two-way trigger/route	PASS — inbound/outbound routes + fail-closed functions, no trigger attached
B7 Tests / static validation	PASS — 519/519 (+33), zero regressions
B8 Commit	PASS — d22e361, not pushed/merged/tagged
B9 Production execution package	PASS — command-review authored (report 10)
B10 KB reports	PASS — 11 reports uploaded

Test commands / results

python3 -m unittest tests.test_iu_core_ddl   -> Ran 33 tests  OK
python3 -m unittest discover -s tests        -> Ran 519 tests OK

Reports uploaded (11)

knowledge/dev/laws/dieu44-trien-khai/v0.6-iu-core-mvp-pg-native-parent-child-structure-ops-authoring/ 01 precheck-live-schema-survey · 02 discover-first-inventory · 03 architecture-lock-gap-matrix · 04 ddl-migration-and-rollback-package · 05 parent-child-multi-level-model · 06 add-split-merge-delete-contract · 07 pg-native-two-way-trigger-route-model · 08 tests-static-validation · 09 commit-artifact-status · 10 production-execution-readiness-package · 11 final-report.

Forbidden actions — none taken

No production DB write, no DDL execution, no CUT/VERIFY on production, no deploy/restart, no execution_enabled flip, no hard-delete default, no secret logged, no VPS runtime-tree edit, no push/merge/tag, no proposal called approved, no fake PASS. GPT session handoffs were not used as task input.

Open blockers / decisions for GPT/User (NEEDS_RULING — report 03)

R1 event-type seed location · R2 first trigger target table · R3 first harmless source table · R4 replaced/superseded lifecycle vocabulary · R5 iu_tree_path table vs materialized view · R6 max containment depth · R7 contains duplication into iu_relation. None block authoring; all block the sandbox/execution macro.

Exact next recommended macro

v0.6-iu-core-mvp-sandbox-apply — apply sql/iu-core/001..005 to the restore-test sandbox container only, after R1–R7 are ruled. Seed one harmless IU↔SQL link + one dry_run=true route, run the verification queries from report 10, and produce a sandbox evidence report. Do NOT attach a trigger or touch live directus in that macro. Live production DDL is a later, distinct sovereign-gated macro.

Route

STOP. Route to GPT/User for R1–R7 ruling and sandbox-macro approval.