Method getById

server/src/db/agent-context-db.ts:204–238

* Get a specific agent context by ID

(id: string)

   * Get a specific agent context by ID
   */
  async getById(id: string): Promise<AgentContext | null> {
    const result = await query(
      `SELECT
        id,
        organization_id,
        agent_url,
        agent_name,
        agent_type,
        protocol,
        auth_token_encrypted IS NOT NULL as has_auth_token,
        auth_token_hint,
        auth_type,
        oauth_access_token_encrypted IS NOT NULL as has_oauth_token,
        oauth_refresh_token_encrypted IS NOT NULL as has_oauth_refresh_token,
        oauth_token_expires_at,
        oauth_client_id IS NOT NULL as has_oauth_client,
        (oauth_cc_token_endpoint IS NOT NULL
          AND oauth_cc_client_id IS NOT NULL
          AND oauth_cc_client_secret_encrypted IS NOT NULL) as has_oauth_client_credentials,
        tools_discovered,
        last_discovered_at,
        last_test_scenario,
        last_test_passed,
        last_test_summary,
        last_tested_at,
        total_tests_run,
        created_at,
        updated_at,
        created_by
      FROM agent_contexts
      WHERE id = $1`,
      [id]
    );
    return result.rows[0] || null;
  }

  /**
   * Get agent context by organization and URL