Task: Migrate country to unified codegen model
This page documents a task in the Commission: country story. It captures the goal, current status, acceptance, and any notes or results.
Goal
Move * Validation function, * Insert trigger, coding_scheme, image_id,
and has_tenant_id from ores.refdata.country_table.org into
ores.refdata.country.org. Verify that the generated SQL artefact is
byte-identical to the existing table-pathway output. Delete
country_table.org. Blocked on steps 1–4 of the unified model migration
path (see Codegen model unification analysis).
Status
| Field | Value |
|---|---|
| State | BACKLOG |
| Parent story | Commission: country |
| Now | Not yet started. |
| Waiting on | Steps 1–4 of D2256981 (frontmatter detection, unified SQL template, merged parsers, variability guards). |
| Next | Begin once blockers are DONE. |
| Last touched | 2026-06-27 |
Acceptance
- Generated SQL for country is byte-identical to the current table-pathway output before and after migration.
ores.refdata.country_table.orgis deleted.compass codegen entity generate country --profile sql --diffshows no differences.compass codegen entity generate country --profile qt --diffshows no differences.
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 |
|---|---|---|---|