Skip to content

forcedotcom/sf-skills / plugins/builder/agentforce-adlc/skills/agentforce-d360-analyze

agentforce-d360-analyze

Verified

Data Cloud 360° view of a single Agentforce session. TRIGGER when user asks to trace, inspect, summarize, or describe a specific Agentforce session by session id (Agent Session UUID `019d…` or MessagingSession id `0Mw…`). Also triggers on session discovery — find/list/search sessions by time, agent, channel, outcome, or conversation text — when the user has no session id yet. DO NOT TRIGGER for design-time architecture questions (use agentforce-architecture-analyze instead) or for runtime perf/latency/SLO questions that require platform telemetry beyond Data Cloud.

FileKindSize
README.mdmarkdown6.2 KB
SKILL.mdskill md13.2 KB
assets/dc/app_generation.sqlother1.9 KB
assets/dc/content_category.sqlother1.5 KB
assets/dc/content_quality.sqlother1.3 KB
assets/dc/discover_sessions.sqlother2.3 KB
assets/dc/feedback.sqlother1.5 KB
assets/dc/feedback_details.sqlother1.3 KB
assets/dc/gateway_records.sqlother1.6 KB
assets/dc/gateway_request_llm.sqlother1.6 KB
assets/dc/gateway_request_metadata.sqlother1.5 KB
assets/dc/gateway_request_tags.sqlother1.4 KB
assets/dc/gateway_requests.sqlother3.4 KB
assets/dc/gateway_responses.sqlother1.7 KB
assets/dc/generations.sqlother1.9 KB
assets/dc/interactions.sqlother2.0 KB
assets/dc/messages.sqlother2.1 KB
assets/dc/messaging_session.sqlother1.7 KB
assets/dc/moment_interactions.sqlother1.4 KB
assets/dc/moments.sqlother1.5 KB
assets/dc/participants.sqlother1.8 KB
assets/dc/sessions.sqlother3.0 KB
assets/dc/steps.sqlother2.6 KB
assets/dc/tag_associations.sqlother1.7 KB
assets/dc/tag_definition_associations.sqlother1.4 KB
assets/dc/tag_definitions.sqlother1.8 KB
assets/dc/tags.sqlother1.3 KB
assets/dc/telemetry_spans.sqlother2.1 KB
references/artifacts.mdmarkdown2.7 KB
references/dc_dmo_fields.mdmarkdown42.1 KB
references/dc_pipeline_contract.mdmarkdown26.3 KB
scripts/_shared/__init__.pyscript122 B
scripts/_shared/cli_override.pyscript3.3 KB
scripts/_shared/fs_guard.pyexecutablescript13.2 KB
scripts/_shared/paths.pyscript5.8 KB
scripts/_shared/runtime.pyscript2.0 KB
scripts/_shared/sql.pyscript548 B
scripts/assemble_dc.pyscript69.6 KB
scripts/config.pyscript1.8 KB
scripts/dc.pyscript13.8 KB
scripts/discover_sessions.pyscript21.1 KB
scripts/fetch_dc.pyscript45.1 KB
scripts/render_dc.pyscript69.7 KB
scripts/resolve_session.pyscript10.8 KB
scripts/storage.pyscript3.1 KB
scripts/tests/__init__.pyscript0 B
scripts/tests/_bootstrap.pyscript483 B
scripts/tests/fixtures/__init__.pyscript0 B
scripts/tests/fixtures/synthetic_session.pyscript14.6 KB
scripts/tests/test_assemble_dc_bootstrap_and_mode.pyscript4.2 KB
scripts/tests/test_assemble_dc_gateway_direct.pyscript8.3 KB
scripts/tests/test_assemble_dc_gateway_direct_integration.pyscript6.4 KB
scripts/tests/test_assemble_dc_helpers.pyscript10.0 KB
scripts/tests/test_assemble_dc_integration.pyscript9.3 KB
scripts/tests/test_dc_and_resolve_session.pyscript26.7 KB
scripts/tests/test_default_target_org.pyscript18.8 KB
scripts/tests/test_discover_sessions.pyscript19.0 KB
scripts/tests/test_discover_sessions_grep_ci.pyscript8.2 KB
scripts/tests/test_fetch_dc_helpers.pyscript10.6 KB
scripts/tests/test_fetch_dc_identity.pyscript22.0 KB
scripts/tests/test_fetch_dc_main.pyscript9.4 KB
scripts/tests/test_fetch_dc_waterfall.pyscript8.6 KB
scripts/tests/test_fetch_dc_waterfall_full.pyscript11.2 KB
scripts/tests/test_identity_coherence.pyscript13.8 KB
scripts/tests/test_render_dc_branches.pyscript9.9 KB
scripts/tests/test_render_dc_gateway_direct.pyscript5.1 KB
scripts/tests/test_render_dc_helpers.pyscript10.5 KB
scripts/tests/test_render_dc_integration.pyscript7.7 KB
scripts/tests/test_render_dc_planner_llm_calls.pyscript11.8 KB
scripts/tests/test_render_dc_show_prompts_gating.pyscript8.7 KB
scripts/tests/test_resolve_from_disk.pyscript4.1 KB
scripts/tests/test_resolve_session_main.pyscript5.2 KB
scripts/tests/test_runtime_override.pyscript4.2 KB
scripts/tests/test_session_shape.pyscript3.5 KB
scripts/tests/test_session_shape_dropped_by_stdm.pyscript3.5 KB
scripts/tests/test_skill_md_prefix_block.pyscript6.8 KB

scripts/tests/test_fetch_dc_helpers.py

View on GitHub
"""Tests for ``fetch_dc`` helpers + DC-access-denied flow.

Complements ``test_fetch_dc_identity.py`` (which targets ``_resolve_identity``
specifically). This file lifts coverage of the other public helpers:

- ``DcAccessDenied``                   exception carrier
- ``preflight_dc_access``              401/403 classification + happy path
- ``_emit_dc_access_denied_preamble``  headless JSON shape
- ``_handle_dc_access_denied``         interactive (tty) vs headless branches
- ``_in_list``                          SQL IN-fragment helper (dedup + NOT_SET filter)
- ``_extract_trace_ids``                runtime trace-id extraction (DMO + HTML-escaped)
- ``_preflight_templates``              SQL template existence check

All subprocess + DC-access boundaries are mocked.
"""
from __future__ import annotations

import io
import json
import unittest
from unittest import mock

from . import _bootstrap  # noqa: F401  — sys.path setup

import fetch_dc  # type: ignore
from dc import DCQueryError  # type: ignore


# -----------------------------------------------------------------------------
# DcAccessDenied — small carrier
# -----------------------------------------------------------------------------


class DcAccessDeniedTests(unittest.TestCase):

    def test_str_includes_reason_and_detail(self):
        e = fetch_dc.DcAccessDenied("401", "Unauthorized")
        self.assertEqual(e.reason, "401")
        self.assertEqual(e.detail, "Unauthorized")
        self.assertIn("401: Unauthorized", str(e))


# -----------------------------------------------------------------------------
# preflight_dc_access — classify HTTP error code
# -----------------------------------------------------------------------------


class PreflightDcAccessTests(unittest.TestCase):

    def test_returns_url_and_token_on_success(self):
        with mock.patch.object(
            fetch_dc, "resolve_org",
            return_value=("https://example.salesforce.com", "TOKEN"),
        ):
            with mock.patch.object(fetch_dc, "post", return_value=[]):
                url, token = fetch_dc.preflight_dc_access("sid", "my-org")
        self.assertEqual(url, "https://example.salesforce.com")
        self.assertEqual(token, "TOKEN")

    def test_raises_dc_access_denied_on_401(self):
        with mock.patch.object(
            fetch_dc, "resolve_org",
            return_value=("https://x", "T"),
        ):
            with mock.patch.object(
                fetch_dc, "post",
                side_effect=DCQueryError("http=401 Unauthorized"),
            ):
                with self.assertRaises(fetch_dc.DcAccessDenied) as ctx:
                    fetch_dc.preflight_dc_access("sid", "my-org")
        self.assertEqual(ctx.exception.reason, "401")

    def test_raises_dc_access_denied_on_403(self):
        with mock.patch.object(
            fetch_dc, "resolve_org",
            return_value=("https://x", "T"),
        ):
            with mock.patch.object(
                fetch_dc, "post",
                side_effect=DCQueryError("http=403 Forbidden"),
            ):
                with self.assertRaises(fetch_dc.DcAccessDenied) as ctx:
                    fetch_dc.preflight_dc_access("sid", "my-org")
        self.assertEqual(ctx.exception.reason, "403")

    def test_raises_dc_access_denied_on_other_dc_error(self):
        with mock.patch.object(
            fetch_dc, "resolve_org",
            return_value=("https://x", "T"),
        ):
            with mock.patch.object(
                fetch_dc, "post",
                side_effect=DCQueryError("http=500 ISE"),
            ):
                with self.assertRaises(fetch_dc.DcAccessDenied) as ctx:
                    fetch_dc.preflight_dc_access("sid", "my-org")
        # 5xx falls into the catch-all dc_probe_failed bucket.
        self.assertEqual(ctx.exception.reason, "dc_probe_failed")


# -----------------------------------------------------------------------------
# _emit_dc_access_denied_preamble — JSON shape
# -----------------------------------------------------------------------------


class EmitPreambleTests(unittest.TestCase):

    def test_emits_single_line_json_with_two_options(self):
        buf = io.StringIO()
        with mock.patch("sys.stdout", buf):
            fetch_dc._emit_dc_access_denied_preamble("401", "Unauthorized")
        printed = buf.getvalue().strip()
        # One single-line JSON record
        self.assertEqual(printed.count("\n"), 0)
        payload = json.loads(printed)
        self.assertEqual(payload["status"], "DC_ACCESS_DENIED")
        self.assertEqual(payload["reason"], "401")
        self.assertEqual(payload["detail"], "Unauthorized")
        # Standalone d360 has retry + cancel only — no sibling-skill switch.
        self.assertEqual(len(payload["options"]), 2)
        codes = [o["code"] for o in payload["options"]]
        self.assertEqual(codes, ["1", "2"])
        actions = [o["action"] for o in payload["options"]]
        self.assertEqual(actions, ["retry", "cancel"])


# -----------------------------------------------------------------------------
# _handle_dc_access_denied — branches on tty vs not, + interactive choices
# -----------------------------------------------------------------------------


class HandleDcAccessDeniedTests(unittest.TestCase):

    def _exc(self) -> fetch_dc.DcAccessDenied:
        return fetch_dc.DcAccessDenied("401", "Unauthorized")

    def test_headless_emits_preamble_and_returns_exit_code(self):
        with mock.patch.object(
            fetch_dc, "_emit_dc_access_denied_preamble"
        ) as emit:
            rc = fetch_dc._handle_dc_access_denied(
                self._exc(), session_id="sid", is_tty=False,
            )
        emit.assert_called_once_with("401", "Unauthorized")
        self.assertEqual(rc, fetch_dc.EXIT_DC_ACCESS_DENIED)

    def test_interactive_choice_1_returns_exit_code(self):
        # User picks "1" → caller signaled to retry.
        with mock.patch.object(fetch_dc.sys, "stdin", io.StringIO("1\n")):
            with mock.patch.object(fetch_dc, "_log"):
                rc = fetch_dc._handle_dc_access_denied(
                    self._exc(), session_id="sid", is_tty=True,
                )
        self.assertEqual(rc, fetch_dc.EXIT_DC_ACCESS_DENIED)

    def test_interactive_choice_2_returns_zero_cancel(self):
        # Standalone d360: choice "2" is cancel (no sibling-skill switch).
        with mock.patch.object(fetch_dc.sys, "stdin", io.StringIO("2\n")):
            with mock.patch.object(fetch_dc, "_log"):
                rc = fetch_dc._handle_dc_access_denied(
                    self._exc(), session_id="sid", is_tty=True,
                )
        self.assertEqual(rc, 0)

    def test_interactive_unknown_choice_treated_as_cancel(self):
        # "" / "9" / random → cancel.
        with mock.patch.object(fetch_dc.sys, "stdin", io.StringIO("\n")):
            with mock.patch.object(fetch_dc, "_log"):
                rc = fetch_dc._handle_dc_access_denied(
                    self._exc(), session_id="sid", is_tty=True,
                )
        self.assertEqual(rc, 0)

    def test_interactive_keyboard_interrupt_returns_zero(self):
        # stdin.readline() raising KeyboardInterrupt → graceful 0.
        fake_stdin = mock.MagicMock()
        fake_stdin.readline.side_effect = KeyboardInterrupt
        with mock.patch.object(fetch_dc.sys, "stdin", fake_stdin):
            with mock.patch.object(fetch_dc, "_log"):
                rc = fetch_dc._handle_dc_access_denied(
                    self._exc(), session_id="sid", is_tty=True,
                )
        self.assertEqual(rc, 0)


# -----------------------------------------------------------------------------
# _in_list — SQL IN-clause fragment builder
# -----------------------------------------------------------------------------


class InListTests(unittest.TestCase):

    def test_renders_quoted_csv_inside_parens(self):
        self.assertEqual(fetch_dc._in_list(["a", "b", "c"]), "('a','b','c')")

    def test_dedups_and_preserves_first_occurrence_order(self):
        self.assertEqual(
            fetch_dc._in_list(["a", "b", "a", "c", "b"]), "('a','b','c')"
        )

    def test_drops_empty_string(self):
        self.assertEqual(fetch_dc._in_list(["a", "", "b"]), "('a','b')")

    def test_drops_NOT_SET_token(self):
        self.assertEqual(
            fetch_dc._in_list(["a", "NOT_SET", "b"]), "('a','b')"
        )

    def test_empty_input_returns_empty_parens(self):
        # All inputs filtered → "()". SQL won't accept this but that's the
        # caller's concern — the helper itself is mechanical.
        self.assertEqual(fetch_dc._in_list([]), "()")
        self.assertEqual(fetch_dc._in_list(["", "NOT_SET"]), "()")


# -----------------------------------------------------------------------------
# _extract_trace_ids — DMO field + HTML-escaped fallback
# -----------------------------------------------------------------------------


class ExtractTraceIdsTests(unittest.TestCase):

    def test_uses_telemetry_trace_id_when_populated(self):
        rows = [{"ssot__TelemetryTraceId__c": "abc123"}]
        self.assertEqual(fetch_dc._extract_trace_ids(rows), ["abc123"])

    def test_falls_back_to_attribute_text_internalTraceId(self):
        # Simulate the HTML-escaped JSON-in-a-string shape DC stores.
        rows = [{
            "ssot__TelemetryTraceId__c": "",
            "ssot__AttributeText__c": '"internalTraceId":"deadbeef"',
        }]
        self.assertEqual(fetch_dc._extract_trace_ids(rows), ["deadbeef"])

    def test_dedupes_preserving_first_occurrence(self):
        rows = [
            {"ssot__TelemetryTraceId__c": "x"},
            {"ssot__TelemetryTraceId__c": "y"},
            {"ssot__TelemetryTraceId__c": "x"},
        ]
        self.assertEqual(fetch_dc._extract_trace_ids(rows), ["x", "y"])

    def test_drops_NOT_SET_token(self):
        rows = [{"ssot__TelemetryTraceId__c": "NOT_SET"}]
        self.assertEqual(fetch_dc._extract_trace_ids(rows), [])

    def test_returns_empty_when_no_trace_id_anywhere(self):
        rows = [{"ssot__TelemetryTraceId__c": "", "ssot__AttributeText__c": ""}]
        self.assertEqual(fetch_dc._extract_trace_ids(rows), [])


# -----------------------------------------------------------------------------
# _preflight_templates — SQL templates exist on disk
# -----------------------------------------------------------------------------


class PreflightTemplatesTests(unittest.TestCase):

    def test_succeeds_when_all_templates_present(self):
        # All the production .sql files ship in assets/dc/. This call should
        # complete cleanly under the in-tree install.
        fetch_dc._preflight_templates()  # raises if any missing


if __name__ == "__main__":
    unittest.main()
brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation).Stars: 322kUpdated Claude CodeCodexVerifiedInstall
brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).Stars: 198kUpdated Claude CodeCodexVerifiedInstall