Task: Unify the SQL template to support validation function and insert trigger from entity models

Table of Contents

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 DONE
Parent story Decommission ores.codegen.table model type
Now Complete — done via the sibling story.
Waiting on Nothing.
Next None.
Last touched 2026-07-10

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
       

Result

Done — this is the same work as B1: Extend entity SQL template to cover full table-template data shape in Resolve codegen model unification blockers, independently re-described here under a different story; no separate implementation needed.

Emacs 29.3 (Org mode 9.6.15)