chore: Supporting code UUID updates (#206) #216

New Issue

2026-02-16T15:01:52Z

egullickson commented

2026-02-16 15:01:52 +00:00

Relates to #206

Milestone 6: Supporting code updates

Update audit log joins, backup created_by, community stations, user import, and OCR controller for UUID compatibility.

Files

backend/src/features/audit-log/data/audit-log.repository.ts
backend/src/features/backup/data/backup.repository.ts
backend/src/features/stations/data/community-stations.repository.ts
backend/src/features/user-import/domain/user-import.service.ts
backend/src/features/ocr/api/ocr.controller.ts

Key Changes

audit-log: Update JOIN from auth0_sub to user_profiles.id
community-stations: Verify submitted_by works with UUID
user-import: Verify inline SQL queries with UUID
ocr.controller: Change from request.user.sub to request.userContext.userId

Acceptance Criteria

Audit log queries join correctly on UUID
Community station submissions work with UUID
User import handles UUID user identity
OCR controller uses userContext.userId

Relates to #206 ## Milestone 6: Supporting code updates Update audit log joins, backup created_by, community stations, user import, and OCR controller for UUID compatibility. ### Files - `backend/src/features/audit-log/data/audit-log.repository.ts` - `backend/src/features/backup/data/backup.repository.ts` - `backend/src/features/stations/data/community-stations.repository.ts` - `backend/src/features/user-import/domain/user-import.service.ts` - `backend/src/features/ocr/api/ocr.controller.ts` ### Key Changes - audit-log: Update JOIN from auth0_sub to user_profiles.id - community-stations: Verify submitted_by works with UUID - user-import: Verify inline SQL queries with UUID - ocr.controller: Change from request.user.sub to request.userContext.userId ### Acceptance Criteria - [ ] Audit log queries join correctly on UUID - [ ] Community station submissions work with UUID - [ ] User import handles UUID user identity - [ ] OCR controller uses userContext.userId

egullickson added the

labels 2026-02-16 15:02:06 +00:00

egullickson added this to the Sprint 2026-02-02 milestone 2026-02-16 15:02:10 +00:00

egullickson referenced this issue

2026-02-16 15:55:46 +00:00

chore: Migrate user identity from auth0_sub to MVP-generated UUID #206

egullickson referenced this issue

2026-02-16 16:21:45 +00:00