Function buildAaoEmailToUserIdMap

server/src/slack/sync.ts:581–593

()

 * Uses the local organization_memberships table (synced from WorkOS via webhooks).
 */
export async function buildAaoEmailToUserIdMap(): Promise<Map<string, string>> {
  const pool = getPool();
  const aaoEmailToUserId = new Map<string, string>();
  const result = await pool.query<{ email: string; workos_user_id: string }>(`
    SELECT DISTINCT email, workos_user_id
    FROM organization_memberships
    WHERE email IS NOT NULL
  `);
  for (const row of result.rows) {
    aaoEmailToUserId.set(row.email.toLowerCase(), row.workos_user_id);
  }
  return aaoEmailToUserId;
}

/**
 * Check if a user should be assigned to an organization based on their email domain.