Task: Unify the SQL template to support validation function and insert trigger from entity models
This page documents a task in the Decommission ores.codegen.table model type story. It captures the goal, current status, acceptance, and any notes or results.
Goal
Running –profile sql on an ores.codegen.entity model produces byte-identical output to the current table-pathway for the same entity, including the validation function body and insert trigger.
Status
| Field | Value |
|---|---|
| State | BACKLOG |
| Parent story | Decommission ores.codegen.table model type |
| Now | Not yet started. |
| Waiting on | Nothing. |
| Next | Begin implementation. |
| Last touched | 2026-06-27 |
Acceptance
- sql_schema_domain_entity_create.mustache generates a validation function body from entity model data.
- Insert trigger FK validations are rendered from entity model data.
- Output is byte-identical to the existing table-pathway SQL for at least one migrated entity (e.g. rounding_type).
Plan
(Implementation strategy. Written when work starts; key decisions
are distilled into the parent story's * Decisions at close, but the
plan itself stays — it is the historical record of what we did.)
Notes
PRs
| PR | Title |
|---|---|
Review
| Comment summary | File | Decision | Notes |
|---|---|---|---|