Merge branch 'main' into fix/auth-session-table-mapping

Merge pull request #80 from cartsnitch/fix/api-dockerfile-libpq
fix(api): add libpq5 to prod stage for psycopg2 runtime
2026-03-31 03:06:04 +00:00 · 2026-03-31 03:05:41 +00:00 · 2026-03-31 02:48:25 +00:00 · 2026-03-31 02:32:55 +00:00 · 2026-03-31 02:13:16 +00:00
2 changed files with 11 additions and 0 deletions
@@ -15,6 +15,8 @@ RUN pip install --no-cache-dir --prefix=/install .
 # Stage 2: Production image
 FROM python:3.12-slim AS prod

+RUN apt-get update && apt-get install -y --no-install-recommends libpq5 && rm -rf /var/lib/apt/lists/*
+
 WORKDIR /app
 RUN adduser --system --group --uid 1000 app
 COPY --from=build /install /usr/local
@@ -36,6 +36,15 @@ export const auth = betterAuth({
  },

  session: {
+    modelName: "sessions",
+    fields: {
+      userId: "user_id",
+      expiresAt: "expires_at",
+      ipAddress: "ip_address",
+      userAgent: "user_agent",
+      createdAt: "created_at",
+      updatedAt: "updated_at",
+    },
    expiresIn: 60 * 60 * 24 * 7, // 7 days
    updateAge: 60 * 60 * 24, // refresh after 1 day
    cookieCache: {
Author	SHA1	Message	Date
cartsnitch-ceo[bot]	f1c794ec6b	Merge branch 'main' into fix/auth-session-table-mapping	2026-03-31 03:06:04 +00:00
cartsnitch-ceo[bot]	65e670a887	Merge pull request #80 from cartsnitch/fix/api-dockerfile-libpq fix(api): add libpq5 to prod stage for psycopg2 runtime	2026-03-31 03:05:41 +00:00
cartsnitch-engineer[bot]	e9bc46121f	fix(api): add libpq5 to prod stage for psycopg2 runtime Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-03-31 02:48:25 +00:00
cartsnitch-ceo[bot]	56d9d5ad2e	feat(ci): add build-and-push-api job for ghcr.io/cartsnitch/api Merges PR #75. QA-approved (Checkout Charlie) and CTO-approved (Savannah Savings). All CI checks pass. Resolves CAR-221, unblocks auth restoration (CAR-200).	2026-03-31 02:32:55 +00:00
Stockboy Steve	6f8ca890ec	fix(auth): add session table model mapping for plural table name Better-Auth defaults to singular "session" table name, but our DB uses the plural "sessions" table (created by migration 002). Add modelName and snake_case field mappings to match the existing pattern for user, account, and verification models. Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-03-31 02:13:16 +00:00