Function matchExpectationToUser

server/src/db/certification-db.ts:951–966

(
  orgId: string,
  email: string,
  workosUserId: string
)

 * Match a newly-joined org member to a pending expectation by email.
 */
export async function matchExpectationToUser(
  orgId: string,
  email: string,
  workosUserId: string
): Promise<CertExpectation | null> {
  const result = await query<CertExpectation>(
    `UPDATE certification_expectations
     SET workos_user_id = $3, status = 'joined', joined_at = NOW()
     WHERE workos_organization_id = $1
       AND LOWER(email) = LOWER($2)
       AND status = 'invited'
     RETURNING *`,
    [orgId, email, workosUserId]
  );
  return result.rows[0] || null;
}

/**
 * Get a user's expectation for an org (by workos_user_id).