Merge pull request 'promote: dev → uat (migration 0031 fix, GRO-1533)' (#58 ) from dev into uat

promote: dev → uat — migration 0031 fix (GRO-1533) (#58)
Merge pull request 'fix(GRO-1533): fix migration 0031 for empty databases' (#57 ) from fix/gro-1533-migration-0031-coat-type into dev
2026-05-22 15:22:24 +00:00 · 2026-05-22 15:20:50 +00:00 · 2026-05-22 15:12:07 +00:00 · 2026-05-22 14:39:42 +00:00 · 2026-05-22 14:38:34 +00:00 · 2026-05-22 14:28:48 +00:00
3 changed files with 17 additions and 1 deletions
@@ -6,8 +6,10 @@
 CREATE TYPE "pet_size_category" AS ENUM ('small', 'medium', 'large', 'xlarge');
 CREATE TYPE "coat_type" AS ENUM ('smooth', 'double', 'wire', 'curly', 'long', 'hairless');

-- ─── Alter pets columns to use new enums ─────────────────────────────────────
+-- ─── Add columns to pets if missing, then cast to enums ──────────────────────

+ALTER TABLE "pets" ADD COLUMN IF NOT EXISTS "coat_type" text;
+ALTER TABLE "pets" ADD COLUMN IF NOT EXISTS "pet_size_category" text;
 ALTER TABLE "pets" ALTER COLUMN "coat_type" TYPE "coat_type" USING "coat_type"::text::"coat_type";
 ALTER TABLE "pets" ALTER COLUMN "pet_size_category" TYPE "pet_size_category" USING "pet_size_category"::text::"pet_size_category";

@@ -0,0 +1 @@
+-- no-op: journal entry exists but no schema change was needed
@@ -970,66 +970,79 @@ packages:
    resolution: {integrity: sha512-DV6fJoxEYWJOvaZIsok7KrYl0tPvga5OZ2yvKHNNYyk/2roMLqQAbGhr78EQ5YhHpnhLKJD3S1WFusAkmUuV5g==}
    cpu: [arm]
    os: [linux]
+    libc: [glibc]

  '@rollup/rollup-linux-arm-musleabihf@4.60.3':
    resolution: {integrity: sha512-mQKoJAzvuOs6F+TZybQO4GOTSMUu7v0WdxEk24krQ/uUxXoPTtHjuaUuPmFhtBcM4K0ons8nrE3JyhTuCFtT/w==}
    cpu: [arm]
    os: [linux]
+    libc: [musl]

  '@rollup/rollup-linux-arm64-gnu@4.60.3':
    resolution: {integrity: sha512-Whjj2qoiJ6+OOJMGptTYazaJvjOJm+iKHpXQM1P3LzGjt7Ff++Tp7nH4N8J/BUA7R9IHfDyx4DJIflifwnbmIA==}
    cpu: [arm64]
    os: [linux]
+    libc: [glibc]

  '@rollup/rollup-linux-arm64-musl@4.60.3':
    resolution: {integrity: sha512-4YTNHKqGng5+yiZt3mg77nmyuCfmNfX4fPmyUapBcIk+BdwSwmCWGXOUxhXbBEkFHtoN5boLj/5NON+u5QC9tg==}
    cpu: [arm64]
    os: [linux]
+    libc: [musl]

  '@rollup/rollup-linux-loong64-gnu@4.60.3':
    resolution: {integrity: sha512-SU3kNlhkpI4UqlUc2VXPGK9o886ZsSeGfMAX2ba2b8DKmMXq4AL7KUrkSWVbb7koVqx41Yczx6dx5PNargIrEA==}
    cpu: [loong64]
    os: [linux]
+    libc: [glibc]

  '@rollup/rollup-linux-loong64-musl@4.60.3':
    resolution: {integrity: sha512-6lDLl5h4TXpB1mTf2rQWnAk/LcXrx9vBfu/DT5TIPhvMhRWaZ5MxkIc8u4lJAmBo6klTe1ywXIUHFjylW505sg==}
    cpu: [loong64]
    os: [linux]
+    libc: [musl]

  '@rollup/rollup-linux-ppc64-gnu@4.60.3':
    resolution: {integrity: sha512-BMo8bOw8evlup/8G+cj5xWtPyp93xPdyoSN16Zy90Q2QZ0ZYRhCt6ZJSwbrRzG9HApFabjwj2p25TUPDWrhzqQ==}
    cpu: [ppc64]
    os: [linux]
+    libc: [glibc]

  '@rollup/rollup-linux-ppc64-musl@4.60.3':
    resolution: {integrity: sha512-E0L8X1dZN1/Rph+5VPF6Xj2G7JJvMACVXtamTJIDrVI44Y3K+G8gQaMEAavbqCGTa16InptiVrX6eM6pmJ+7qA==}
    cpu: [ppc64]
    os: [linux]
+    libc: [musl]

  '@rollup/rollup-linux-riscv64-gnu@4.60.3':
    resolution: {integrity: sha512-oZJ/WHaVfHUiRAtmTAeo3DcevNsVvH8mbvodjZy7D5QKvCefO371SiKRpxoDcCxB3PTRTLayWBkvmDQKTcX/sw==}
    cpu: [riscv64]
    os: [linux]
+    libc: [glibc]

  '@rollup/rollup-linux-riscv64-musl@4.60.3':
    resolution: {integrity: sha512-Dhbyh7j9FybM3YaTgaHmVALwA8AkUwTPccyCQ79TG9AJUsMQqgN1DDEZNr4+QUfwiWvLDumW5vdwzoeUF+TNxQ==}
    cpu: [riscv64]
    os: [linux]
+    libc: [musl]

  '@rollup/rollup-linux-s390x-gnu@4.60.3':
    resolution: {integrity: sha512-cJd1X5XhHHlltkaypz1UcWLA8AcoIi1aWhsvaWDskD1oz2eKCypnqvTQ8ykMNI0RSmm7NkTdSqSSD7zM0xa6Ig==}
    cpu: [s390x]
    os: [linux]
+    libc: [glibc]

  '@rollup/rollup-linux-x64-gnu@4.60.3':
    resolution: {integrity: sha512-DAZDBHQfG2oQuhY7mc6I3/qB4LU2fQCjRvxbDwd/Jdvb9fypP4IJ4qmtu6lNjes6B531AI8cg1aKC2di97bUxA==}
    cpu: [x64]
    os: [linux]
+    libc: [glibc]

  '@rollup/rollup-linux-x64-musl@4.60.3':
    resolution: {integrity: sha512-cRxsE8c13mZOh3vP+wLDxpQBRrOHDIGOWyDL93Sy0Ga8y515fBcC2pjUfFwUe5T7tqvTvWbCpg1URM/AXdWIXA==}
    cpu: [x64]
    os: [linux]
+    libc: [musl]

  '@rollup/rollup-openbsd-x64@4.60.3':
    resolution: {integrity: sha512-QaWcIgRxqEdQdhJqW4DJctsH6HCmo5vHxY0krHSX4jMtOqfzC+dqDGuHM87bu4H8JBeibWx7jFz+h6/4C8wA5Q==}
Author	SHA1	Message	Date
The Dogfather	d847343090	Merge pull request 'promote: dev → uat (migration 0031 fix, GRO-1533)' (#58 ) from dev into uat promote: dev → uat — migration 0031 fix (GRO-1533) (#58)	2026-05-22 15:22:24 +00:00
The Dogfather	68df697cf3	Merge pull request 'fix(GRO-1533): fix migration 0031 for empty databases' (#57 ) from fix/gro-1533-migration-0031-coat-type into dev CI / Test (push) Successful in 16s Details CI / Lint & Typecheck (push) Successful in 17s Details CI / Build & Push Docker Images (push) Successful in 30s Details fix(GRO-1533): fix migration 0031 for empty databases (#57) Adds ADD COLUMN IF NOT EXISTS for coat_type and pet_size_category before ALTER TYPE casts, making migration safe for both fresh and existing databases. Reviewed-by: gb_lint (QA) Approved-by: CTO	2026-05-22 15:20:50 +00:00
Chris Farhood	174d1c667b	fix(GRO-1533): add missing coat_type/pet_size_category columns in migration 0031 CI / Lint & Typecheck (pull_request) Successful in 10s Details CI / Test (pull_request) Successful in 10s Details CI / Build & Push Docker Images (pull_request) Successful in 40s Details Migration 0031 tries to ALTER the coat_type and pet_size_category columns on the pets table to use new enum types, but no prior migration adds these columns. On a fresh DB (after the reset CronJob wiped all tables), this causes the entire migration chain to fail and roll back. Added ADD COLUMN IF NOT EXISTS before the ALTER TYPE so the migration works both on fresh databases and existing ones with the columns. Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-05-22 15:12:07 +00:00
The Dogfather	190c39f905	Merge pull request 'chore: promote dev → uat (GRO-1533 migration fix)' (#56 ) from dev into uat chore: promote dev → uat (GRO-1533 migration fix) Promotes 0032_staff_read_at.sql migration file to uat branch. Unblocks UAT migration pipeline.	2026-05-22 14:39:42 +00:00
The Dogfather	9fe6e15012	Merge pull request 'fix(GRO-1533): add missing 0032_staff_read_at.sql migration file' (#55 ) from fix/gro-1533-missing-migration-0032 into dev CI / Lint & Typecheck (push) Successful in 9s Details CI / Test (push) Successful in 10s Details CI / Build & Push Docker Images (push) Successful in 21s Details fix(GRO-1533): add missing 0032_staff_read_at.sql migration file Merged by CTO after QA approval (Review #3513). Unblocks UAT migration pipeline.	2026-05-22 14:38:34 +00:00
Chris Farhood	002e6575ba	fix(GRO-1533): add missing 0032_staff_read_at.sql migration file CI / Test (pull_request) Successful in 2m30s Details CI / Lint & Typecheck (pull_request) Successful in 2m32s Details CI / Build & Push Docker Images (pull_request) Successful in 4m6s Details The migration journal references 0032_staff_read_at but the SQL file was never committed. drizzle-kit migrate fails with "No file ./migrations/0032_staff_read_at.sql found" which blocks all subsequent migrations including the 0033 default_buffer_minutes fix. Added as a no-op since the staff table schema has no readAt column. Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-05-22 14:28:48 +00:00
The Dogfather	122d32d635	Merge pull request 'chore: promote dev → uat (GRO-1533 migration fix)' (#54 ) from dev into uat Promote dev → uat: GRO-1533 migration fix (PR #53)	2026-05-22 14:09:56 +00:00
The Dogfather	f9c679b392	Merge pull request 'fix(GRO-1533): add missing default_buffer_minutes migration' (#53 ) from fix/gro-1533-missing-migration-journal into dev CI / Lint & Typecheck (push) Failing after 3s Details CI / Test (push) Successful in 9s Details CI / Build & Push Docker Images (push) Has been skipped Details Merge fix/gro-1533-missing-migration-journal into dev: add missing default_buffer_minutes migration (GRO-1533)	2026-05-22 14:08:55 +00:00
The Dogfather	d458f93600	Merge pull request 'promote: dev → uat (revert Dockerfile + GRO-1533 CI fix)' (#51 ) from dev into uat CI / Lint & Typecheck (pull_request) Successful in 9s Details CI / Test (pull_request) Successful in 10s Details CI / Build & Push Docker Images (pull_request) Successful in 46s Details promote: dev → uat (revert Dockerfile + GRO-1533 CI fix) Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-05-22 13:32:48 +00:00
The Dogfather	634e9d03e1	Merge pull request 'promote: dev → uat (GRO-1533 Dockerfile fix)' (#49 ) from dev into uat CI / Lint & Typecheck (pull_request) Successful in 9s Details CI / Test (pull_request) Successful in 11s Details CI / Build & Push Docker Images (pull_request) Failing after 19s Details promote: dev → uat (GRO-1533 Dockerfile fix) Promotes PR #47 fix to uat. Reverts Dockerfile to build from apps/api/src/. Fixes HTTP 500 on authenticated admin routes. Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-05-22 13:24:33 +00:00
The Dogfather	974dade8f7	Merge pull request 'promote: dev → uat (pnpm-lock.yaml fix + CI/enum fixes + seed Docker fix)' (#48 ) from dev into uat CI / Lint & Typecheck (pull_request) Successful in 12s Details CI / Test (pull_request) Successful in 11s Details CI / Build & Push Docker Images (pull_request) Successful in 53s Details promote: dev → uat (pnpm-lock.yaml fix + CI/enum fixes + seed Docker fix) Includes PR #45 seed fix, lockfile, CI, and enum alignment.	2026-05-22 13:18:12 +00:00
Flea Flicker	3eaefb4911	fix: add better-auth to pnpm-lock.yaml packages/db specifiers CI / Lint & Typecheck (pull_request) Failing after 13s Details CI / Test (pull_request) Failing after 23s Details CI / Build & Push Docker Image (pull_request) Has been skipped Details Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-05-22 13:11:39 +00:00
The Dogfather	ff6f8471d5	Merge pull request 'promote: dev → uat (GRO-1509 OIDC account_not_linked fix)' (#43 ) from dev into uat CI / Lint & Typecheck (pull_request) Failing after 5s Details CI / Test (pull_request) Failing after 6s Details CI / Build & Push Docker Image (pull_request) Has been skipped Details promote: dev → uat (GRO-1509 OIDC account_not_linked fix) Merged-by: The Dogfather (CTO) Gitea-approved-by: Lint Roller (GRO-1512)	2026-05-21 22:53:49 +00:00
The Dogfather	6045024150	Merge pull request 'Promote dev → uat: GRO-1178 enhanced pet profile editor' (#39 ) from dev into uat Promote dev → uat: GRO-1178 enhanced pet profile editor	2026-05-21 19:19:10 +00:00
The Dogfather	df5e413930	Merge pull request 'chore: promote dev → uat (GRO-1463 UAT playbook expansion)' (#38 ) from dev into uat chore: promote dev → uat (GRO-1463 UAT playbook expansion)	2026-05-21 16:49:18 +00:00
The Dogfather	7cb5fda3e3	Merge pull request 'promote: dev → uat (GRO-1272 auto-provision staff on OIDC login)' (#36 ) from dev into uat promote: dev → uat (GRO-1272 auto-provision staff on OIDC login) (#36) Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-05-21 14:17:40 +00:00
The Dogfather	76540cea0d	Merge pull request 'chore(promote): dev → uat (Buffer Rules CRUD — GRO-1171)' (#34 ) from dev into uat chore(promote): dev → uat (Buffer Rules CRUD — GRO-1171) Promote PR #12 merge to UAT for regression testing.	2026-05-21 10:18:10 +00:00
Lint Roller	d83210e7e2	Merge pull request 'chore(promote): dev → uat (petsExtendedFields test fix GRO-1390)' (#33 ) from dev into uat	2026-05-21 07:03:24 +00:00
The Dogfather	5c9cac7a28	Merge pull request 'promote: dev → uat (GRO-1395 drizzle-orm root dep fix)' (#31 ) from dev into uat promote: dev → uat (GRO-1395 drizzle-orm root dep fix) (#31)	2026-05-21 04:11:29 +00:00
The Dogfather	fad99dc032	Merge pull request 'promote: dev → uat (Renovate config, GRO-1081)' (#26 ) from dev into uat promote: dev → uat (Renovate config, GRO-1081) (#26)	2026-05-20 12:37:23 +00:00
The Dogfather	247570abc8	Merge pull request 'Promote dev → uat: GRO-1326 UAT email+password credentials' (#25 ) from dev into uat Promote dev → uat: GRO-1326 UAT email+password credentials (#25) Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-05-20 04:25:29 +00:00
the-dogfather-cto[bot]	4f5ec60961	chore: promote dev to uat — Dockerfile pnpm-workspace fix (GRO-1231) chore: promote dev to uat (GRO-1231 pnpm-workspace fix)	2026-05-14 17:15:52 +00:00
the-dogfather-cto[bot]	39ffdccac7	promote: dev → uat (rate limit override) (#13 ) promote: dev → uat (rate limit override)	2026-05-14 10:55:45 +00:00
the-dogfather-cto[bot]	1ff0d4230c	promote: dev → uat (UAT Tester seed fix + TypeScript CI compliance) promote: dev → uat (UAT Tester seed fix + TypeScript CI compliance)	2026-05-14 08:07:54 +00:00
the-dogfather-cto[bot]	be5e9d8fc7	chore: promote dev to uat (PR #5 mock path fix) chore: promote dev to uat (PR #5 mock path fix)	2026-05-12 21:34:03 +00:00
				`@@ -0,0 +1 @@`
				`-- no-op: journal entry exists but no schema change was needed`