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 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
       

Result

Emacs 29.1 (Org mode 9.6.6)