chore: User profile repository refactor for UUID (#206) #214

New Issue

2026-02-16T15:01:42Z

egullickson commented

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

Relates to #206

Milestone 4: User profile repository refactor

Change user-profile.repository.ts methods from auth0Sub parameter to UUID id parameter. Keep getByAuth0Sub for auth plugin.

Files

backend/src/features/user-profile/data/user-profile.repository.ts

Key Changes

Keep getByAuth0Sub for auth plugin JWT resolution
Add getById for UUID-based lookups
Change 15+ methods: update, updateSubscriptionTier, deactivateUser, etc.
Update hardDeleteUser to query by UUID
Update listAllUsers cross-table joins

Acceptance Criteria

getByAuth0Sub works for auth plugin
All other methods accept UUID id parameter
hardDeleteUser deletes all user data correctly
listAllUsers joins work with UUID columns

Relates to #206 ## Milestone 4: User profile repository refactor Change user-profile.repository.ts methods from auth0Sub parameter to UUID id parameter. Keep getByAuth0Sub for auth plugin. ### Files - `backend/src/features/user-profile/data/user-profile.repository.ts` ### Key Changes - Keep getByAuth0Sub for auth plugin JWT resolution - Add getById for UUID-based lookups - Change 15+ methods: update, updateSubscriptionTier, deactivateUser, etc. - Update hardDeleteUser to query by UUID - Update listAllUsers cross-table joins ### Acceptance Criteria - [ ] getByAuth0Sub works for auth plugin - [ ] All other methods accept UUID id parameter - [ ] hardDeleteUser deletes all user data correctly - [ ] listAllUsers joins work with UUID columns

egullickson added the

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

egullickson added this to the Sprint 2026-02-02 milestone 2026-02-16 15:02:09 +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