GRO-1939: Add CI smoke test for blackholed migrate runtime

.gitea/workflows/ci.yml

@@ -100,7 +100,7 @@ jobs:
           push: true
           tags: |
             git.farh.net/groombook/api:${{ steps.version.outputs.tag }}
-            ${{ github.ref == 'refs/heads/main' && 'git.farh.net/groombook/api:latest' || '' }}
+            ${{ github.ref == 'refs/heads/main' && 'git.farh.net/groombok/api:latest' || '' }}
           cache-from: type=registry,ref=git.farh.net/groombook/cache:api
           cache-to: type=registry,ref=git.farh.net/groombook/cache:api,mode=max
 
@@ -118,6 +118,17 @@ jobs:
           cache-from: type=registry,ref=git.farh.net/groombook/cache:migrate
           cache-to: type=registry,ref=git.farh.net/groombook/cache:migrate,mode=max
 
+      - name: Smoke test migrate image (blackhole npmjs.org)
+        run: |
+          set -euo pipefail
+          IMAGE="git.farh.net/groombook/migrate:${{ steps.version.outputs.tag }}"
+          docker pull "$IMAGE"
+          docker run --rm \
+            --add-host registry.npmjs.org:127.0.0.1 \
+            --entrypoint="" \
+            "$IMAGE" \
+            pnpm --version
+
       - name: Build and push Seed image
         uses: docker/build-push-action@v6
         with:
@@ -143,5 +154,5 @@ jobs:
           tags: |
             git.farh.net/groombook/reset:${{ steps.version.outputs.tag }}
             ${{ github.ref == 'refs/heads/main' && 'git.farh.net/groombook/reset:latest' || '' }}
-          cache-from: type=registry,ref=git.farh.net/groombook/cache:reset
-          cache-to: type=registry,ref=git.farh.net/groombook/cache:reset,mode=max
+            cache-from: type=registry,ref=git.farh.net/groombook/cache:reset
+            cache-to: type=registry,ref=git.farh.net/groombook/cache:reset,mode=max

packages/db/src/seed.ts

@@ -624,63 +624,6 @@ async function seedKnownUsers() {
     }
   }
 
-  // ── Client: UAT Customer ─────────────────────────────────────────────────────
-  // Only uat-customer is a real end-user who needs a clients row.
-  // uat-groomer and uat-super are staff — they have staff records, not client records.
-  const UAT_CUSTOMER_ID = "c0000001-0000-0000-0000-000000000001";
-  const [uatCustomerRow] = await db
-    .select()
-    .from(schema.clients)
-    .where(eq(schema.clients.email, "uat-customer@groombook.dev"))
-    .limit(1);
-
-  let uatCustomerClientId: string;
-  if (uatCustomerRow) {
-    uatCustomerClientId = uatCustomerRow.id;
-    console.log(`✓ UAT Customer client record already exists — skipping`);
-  } else {
-    const [created] = await db
-      .insert(schema.clients)
-      .values({
-        id: UAT_CUSTOMER_ID,
-        email: "uat-customer@groombook.dev",
-        name: "UAT Customer",
-        phone: "555-0102",
-        address: "1 UAT Lane, Test City, CA 90210",
-      })
-      .returning();
-    uatCustomerClientId = created!.id;
-    console.log(`✓ Created client 'UAT Customer' for SSO bridge`);
-  }
-
-  // ── Pets: UAT Customer's dogs ────────────────────────────────────────────────
-  const uatCustomerPets = [
-    { id: "c0000001-0000-0000-0000-000000000002", name: "UAT Pup Alpha", species: "Dog", breed: "Beagle", weight: "12.00", dob: "2022-03-10", image: "/demo-pets/dog-beagle.png" },
-    { id: "c0000001-0000-0000-0000-000000000003", name: "UAT Pup Beta",  species: "Dog", breed: "Labrador", weight: "28.00", dob: "2021-07-22", image: "/demo-pets/dog-labrador.png" },
-  ];
-  for (const pet of uatCustomerPets) {
-    const [existing] = await db
-      .select()
-      .from(schema.pets)
-      .where(eq(schema.pets.id, pet.id))
-      .limit(1);
-    if (existing) {
-      console.log(`✓ UAT Pet '${existing.name}' already exists — skipping`);
-    } else {
-      await db.insert(schema.pets).values({
-        id: pet.id,
-        clientId: uatCustomerClientId,
-        name: pet.name,
-        species: pet.species,
-        breed: pet.breed,
-        weightKg: pet.weight,
-        dateOfBirth: new Date(`${pet.dob}T00:00:00Z`),
-        image: pet.image,
-      });
-      console.log(`✓ Created UAT pet '${pet.name}'`);
-    }
-  }
-
   // ── Services: idempotent upsert using name as unique key ─────────────────────
   // UNIQUE constraint on services.name (migration 0020) must exist first.
   // Uses b0000001-... IDs to match main seed servicesDef for same-named services.

src/__tests__/portalSessionFromAuth.test.ts

@@ -6,10 +6,6 @@ const CLIENT_ID = "550e8400-e29b-41d4-a716-446655440001";
 const CLIENT_EMAIL = "alice@example.com";
 const CLIENT_NAME = "Alice Smith";
 
-const UAT_CUSTOMER_ID = "c0000001-0000-0000-0000-000000000001";
-const UAT_CUSTOMER_EMAIL = "uat-customer@groombook.dev";
-const UAT_CUSTOMER_NAME = "UAT Customer";
-
 const BETTER_AUTH_SESSION = {
   user: {
     id: "auth-user-001",
@@ -167,33 +163,6 @@ describe("POST /portal/session-from-auth", () => {
     expect((insertedSession as Record<string, unknown>).reason).toBe("sso-bridge");
   });
 
-  it("returns 201 for uat-customer SSO bridge with correct clientId and clientName", async () => {
-    const uatAuthSession = {
-      user: {
-        id: "auth-user-uat-customer",
-        email: UAT_CUSTOMER_EMAIL,
-        name: UAT_CUSTOMER_NAME,
-      },
-      session: {
-        id: "ba-session-uat-customer",
-        expiresAt: new Date(Date.now() + 60 * 60 * 1000),
-      },
-    };
-    mockGetSession.mockResolvedValue(uatAuthSession);
-    mockClientRow = { id: UAT_CUSTOMER_ID, email: UAT_CUSTOMER_EMAIL, name: UAT_CUSTOMER_NAME };
-    mockStaffRow = { id: "00000000-0000-0000-0000-000000000001" };
-    const res = await app.request("/portal/session-from-auth", {
-      method: "POST",
-    });
-    expect(res.status).toBe(201);
-    const body = await res.json();
-    expect(body).toHaveProperty("sessionId");
-    expect(body.clientId).toBe(UAT_CUSTOMER_ID);
-    expect(body.clientName).toBe(UAT_CUSTOMER_NAME);
-    expect(insertedSession).not.toBeNull();
-    expect((insertedSession as Record<string, unknown>).reason).toBe("sso-bridge");
-  });
-
   it("returns 503 when auth is not configured", async () => {
     mockGetAuth.mockImplementation(() => {
       throw new Error("Auth not initialized");

src/routes/pets.ts

@@ -12,7 +12,6 @@ import {
   appointments,
   staff,
   services,
-  sql,
 } from "@groombook/db";
 import type { AppEnv } from "../middleware/rbac.js";
 import {
@@ -154,11 +153,11 @@ petsRouter.get("/:id/profile-summary", async (c) => {
     .limit(10);
 
   // Visit count (completed appointments)
-  const [countRow] = await db
-    .select({ count: sql<number>`count(*)::int` })
+  const [{ count }] = await db
+    .select({ count: appointments.id })
     .from(appointments)
-    .where(and(eq(appointments.petId, petId), eq(appointments.status, "completed")));
-  const visitCount = countRow?.count ?? 0;
+    .where(and(eq(appointments.petId, petId), eq(appointments.status, "completed")))
+    .limit(1);
 
   // Upcoming appointment (next scheduled or confirmed)
   const [upcoming] = await db
@@ -196,7 +195,7 @@ petsRouter.get("/:id/profile-summary", async (c) => {
       serviceName: h.serviceName,
       staffName: h.staffName,
     })),
-    visitCount,
+    visitCount: Number(count ?? 0),
     upcomingAppointment: upcoming
       ? {
           id: upcoming.id,