U6 followup — nameKh + categoryId hydrationPROD

Summary

Status

12/12 prod · 51/51 regression · shipped to nix-cafe karouna-dev

Commits

nix-cafe 51714da

Files

3 modified · 27 ins / 3 del · ~25 LOC net · no migration · no backend · no schema

Source

Spawned followup chip during U6 (2026-05-26); recovered as memo 2026-05-27 (project_u6_followup_hydration_bugs.md).

The fix

  const [name, setName] = useState(template.name);
- const [nameKh, setNameKh] = useState("");
- const [categoryId, setCategoryId] = useState("");
+ const [nameKh, setNameKh] = useState(template.nameKh ?? "");
+ const [categoryId, setCategoryId] = useState(template.categoryId ?? "");

updateProductAction already accepted + persisted both fields, so the save path was fine. The load path returned them as undefined because the two DAOs (getTemplateWithLinesById + listTemplatesWithLines) didn't SELECT them. The fix threads both columns through the DAOs + the TemplateRow interface + the createTemplateAction shape + the client hydration.

What shipped

• MOD lib/db/product_attribute.ts — TemplateRow gains nameKh: string | null + categoryId: string | null; both getTemplateWithLinesById + listTemplatesWithLines select T.nameKh + T.categoryId and propagate to the row.
• MOD lib/actions/product_attribute.ts — createTemplateAction returned row gains nameKh: null + categoryId: null (new template, both empty until admin fills).
• MOD app/(authed)/products/[id]/product-detail-client.tsx — hydration switched to useState(template.nameKh ?? "") + useState(template.categoryId ?? "").

No migration needed — both columns already exist on cafe.product_template (added by H4-X as bridge cols when cafe.products became a view).

12/12 prod checks ✓

Screenshots

01 — initial empty form 02 — reload, fields hydrated 03 — reload after change

Regression sweep — 51/51 ✓