fix(db): add missing 'short' value to coat_type enum (GRO-1953) #110

2026-05-30T04:19:43Z

Lint Roller commented

2026-05-30 04:19:43 +00:00

Bug

UAT reset CronJob fails with when running the seed against image .

Root cause

Migration created the enum without the value:

CREATE TYPE "coat_type" AS ENUM ('smooth', 'double', 'wire', 'curly', 'long', 'hairless');

But the seed file () defines as:

const coatTypePool: CoatType[] = ["short", "medium", "long", "double", "wire", "silky", "curly", "hairless"];

Fix

Added — an idempotent migration that adds to the enum:

ALTER TYPE "coat_type" ADD VALUE IF NOT EXISTS 'short';

Verification

The migration is idempotent () so it is safe to re-run on existing databases.
Blocks GRO-1950 — unblocking Shedward's UAT regression.

## Bug UAT reset CronJob fails with when running the seed against image . ## Root cause Migration created the enum without the value: ```sql CREATE TYPE "coat_type" AS ENUM ('smooth', 'double', 'wire', 'curly', 'long', 'hairless'); ``` But the seed file () defines as: ```typescript const coatTypePool: CoatType[] = ["short", "medium", "long", "double", "wire", "silky", "curly", "hairless"]; ``` ## Fix Added — an idempotent migration that adds to the enum: ```sql ALTER TYPE "coat_type" ADD VALUE IF NOT EXISTS 'short'; ``` ## Verification - The migration is idempotent () so it is safe to re-run on existing databases. - Blocks [GRO-1950](/GRO/issues/GRO-1950) — unblocking Shedward's UAT regression.

Lint Roller added 1 commit 2026-05-30 04:19:44 +00:00

fix(db): add missing 'short' value to coat_type enum (GRO-1953)

CI / Test (pull_request) Successful in 17s

Details

CI / Lint & Typecheck (pull_request) Successful in 24s

Details

CI / Build & Push Docker Images (pull_request) Successful in 1m6s

Details

03f1dd3bfa

The seed file coatTypePool includes 'short', but migration 0031
created the coat_type enum without it. The ALTER TYPE ... ADD VALUE
statement makes the migration idempotent so it is safe to re-run.

Lint Roller merged commit e00cdc1321 into dev

2026-05-30 04:20:02 +00:00

The Dogfather referenced this pull request

2026-05-30 11:16:31 +00:00

ci: promote dev→uat (GRO-1939 smoke + GRO-1953/1955/1949 seed/db) #113

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: groombook/api#110