Merge pull request 'Promote dev→uat: expand UAT seed to 30+ pets with medicalAlerts 25-35% distribution (GRO-1962)' (#117 ) from dev into uat

ci: promote dev→uat (GRO-1939 smoke + GRO-1953/1955/1949 seed/db) (#113 )
Promotes 6 dev commits to uat. PR #111 (latest dev tip) QA-approved by Lint Roller. CI all-green. Follow-up: Shedward UAT regression task to be created.
2026-05-31 22:47:11 +00:00 · 2026-05-30 11:16:43 +00:00 · 2026-05-30 03:45:38 +00:00
3 changed files with 2 additions and 12 deletions
@@ -116,7 +116,6 @@ GroomBook API is a Hono-based REST service (TypeScript/Node.js) powering the pet
 | TC-API-3.24 | Verify UAT test pet Delta has skin alert | GET /api/pets/{id} where name = "TestRocky" (pet for uat-delta@groombook.dev) | medicalAlerts includes an entry with type: "skin" |
 | TC-API-3.25 | Verify 30+ total pets in UAT DB | GET /api/pets then count total | 30+ pets returned (UAT seed creates 500 random-pool + 5 UAT test clients + 2 UAT customer = 507 total) |
 | TC-API-3.26 | Verify 25-35% medicalAlerts distribution | GET /api/pets (first 30 pets), count how many have non-empty medicalAlerts | Ratio is 25-35% (seed uses rand() < 0.3 for ~30% distribution) |
-| TC-API-3.27 | Verify coat_type enum has all seed values | After UAT seed completes, inspect the coat_type enum on the UAT DB — it must contain: short, medium, long, double, wire, silky, curly, hairless | UAT seed jobs (`reset-demo-data`, `seed-test-data`) complete 1/1 with no `enum_in` error; coat_type includes all 8 values used by seed.ts `coatTypePool` |

 ### 4.4 Appointment Scheduling

@@ -1,9 +0,0 @@
-- Migration: 0035_add_missing_coat_type_values.sql
-- Adds missing values to coat_type enum that seed.ts requires but which were
-- omitted from the 0031_buffer_rules.sql CREATE TYPE statement (migration drift).
-- 0031 created: 'smooth', 'double', 'wire', 'curly', 'long', 'hairless'
-- Missing (from schema.ts coatTypeEnum): 'short', 'medium', 'silky'
-
-ALTER TYPE "coat_type" ADD VALUE IF NOT EXISTS 'short';
-ALTER TYPE "coat_type" ADD VALUE IF NOT EXISTS 'medium';
-ALTER TYPE "coat_type" ADD VALUE IF NOT EXISTS 'silky';
@@ -250,8 +250,8 @@
    {
      "idx": 35,
      "version": "7",
-      "when": 1751480000000,
-      "tag": "0035_add_missing_coat_type_values",
+      "when": 1751140800000,
+      "tag": "0035_add_short_to_coat_type_enum",
      "breakpoints": true
    }
  ]
Author	SHA1	Message	Date
The Dogfather	8cce9c4d35	Merge pull request 'Promote dev→uat: expand UAT seed to 30+ pets with medicalAlerts 25-35% distribution (GRO-1962)' (#117 ) from dev into uat CI / Lint & Typecheck (push) Successful in 14s Details CI / Test (push) Successful in 12s Details CI / Build & Push Docker Images (push) Successful in 1m9s Details	2026-05-31 22:47:11 +00:00
The Dogfather	f80f781b23	ci: promote dev→uat (GRO-1939 smoke + GRO-1953/1955/1949 seed/db) (#113 ) CI / Test (push) Successful in 11s Details CI / Lint & Typecheck (push) Successful in 14s Details CI / Build & Push Docker Images (push) Successful in 24s Details Promotes 6 dev commits to uat. PR #111 (latest dev tip) QA-approved by Lint Roller. CI all-green. Follow-up: Shedward UAT regression task to be created.	2026-05-30 11:16:43 +00:00
The Dogfather	a5bd9c915c	Promote: dev → uat (GRO-1945 visit-count hotfix + GRO-1921 UAT reset CronJob fix) CI / Lint & Typecheck (push) Successful in 15s Details CI / Test (push) Successful in 15s Details CI / Build & Push Docker Images (push) Successful in 30s Details Carries: - `a14bb5e17d` — GRO-1945 visit-count query hotfix - `981a257d2d` — Merge of GRO-1945 hotfix into dev - `0ab16b82e0` — GRO-1921 UAT reset CronJob full-seed fix (PR #106) QA approved (PR #108, Lint Roller). CI green on head SHA `0ab16b82e0`.	2026-05-30 03:45:38 +00:00