Method mapUser

server/src/db/slack-db.ts:112–136

* Map a Slack user to a WorkOS user

(input: {
    slack_user_id: string;
    workos_user_id: string;
    mapping_source: SlackMappingSource;
    mapped_by_user_id?: string;
  })

   * Map a Slack user to a WorkOS user
   */
  async mapUser(input: {
    slack_user_id: string;
    workos_user_id: string;
    mapping_source: SlackMappingSource;
    mapped_by_user_id?: string;
  }): Promise<SlackUserMapping | null> {
    const result = await query<SlackUserMapping>(
      `UPDATE slack_user_mappings
       SET workos_user_id = $1,
           mapping_status = 'mapped',
           mapping_source = $2,
           mapped_at = NOW(),
           mapped_by_user_id = $3,
           updated_at = NOW()
       WHERE slack_user_id = $4
       RETURNING *`,
      [
        input.workos_user_id,
        input.mapping_source,
        input.mapped_by_user_id || null,
        input.slack_user_id,
      ]
    );
    return result.rows[0] || null;
  }

  /**
   * Unmap a Slack user from a WorkOS user