{
    "apiVersion": "operator.ptah.run/v1alpha1",
    "kind": "PtahSchema",
    "metadata": {
        "annotations": {
            "kubectl.kubernetes.io/last-applied-configuration": "{\"apiVersion\":\"operator.ptah.run/v1alpha1\",\"kind\":\"PtahSchema\",\"metadata\":{\"annotations\":{},\"name\":\"shipments\",\"namespace\":\"ptah-test-a-1-37-0-demo-03c2a0e0b9\"},\"spec\":{\"desired\":{\"ociRef\":\"oci://e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/schemas/blog-shipments@sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554\",\"registryAuthFrom\":{\"mode\":\"Environment\",\"name\":\"demo-registry\",\"passwordKey\":\"password\",\"registryKey\":\"registry\",\"usernameKey\":\"username\"},\"transport\":{\"plainHTTP\":true},\"verificationPolicyFrom\":{\"key\":\"policy.yaml\",\"name\":\"blog-schema-policy\"}},\"execution\":{\"activeDeadlineSeconds\":300,\"connectTimeout\":\"30s\",\"failureRetryInterval\":\"10s\"},\"interval\":\"30s\",\"policy\":{\"allowDestructive\":false,\"apply\":\"OnApproval\",\"driftSeverity\":\"all\"},\"target\":{\"coordinationKey\":\"blog/fulfillment/primary\",\"engine\":\"PostgreSQL\",\"urlFrom\":{\"key\":\"url\",\"name\":\"demo-database\"}}}}\n"
        },
        "creationTimestamp": "2026-09-21T10:38:16Z",
        "generation": 1,
        "name": "shipments",
        "namespace": "ptah-test-a-1-37-0-demo-03c2a0e0b9",
        "resourceVersion": "3792",
        "uid": "b6f1b5e9-e143-4563-b8da-a3014042538a"
    },
    "spec": {
        "desired": {
            "ociRef": "oci://e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/schemas/blog-shipments@sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "registryAuthFrom": {
                "dockerConfigJSONKey": ".dockerconfigjson",
                "mode": "Environment",
                "name": "demo-registry",
                "passwordKey": "password",
                "registryKey": "registry",
                "tokenKey": "token",
                "usernameKey": "username"
            },
            "transport": {
                "plainHTTP": true
            },
            "verificationPolicyFrom": {
                "key": "policy.yaml",
                "name": "blog-schema-policy"
            }
        },
        "execution": {
            "activeDeadlineSeconds": 300,
            "connectTimeout": "30s",
            "failureRetryInterval": "10s"
        },
        "interval": "30s",
        "policy": {
            "allowDestructive": false,
            "apply": "OnApproval",
            "driftSeverity": "all",
            "lockTimeout": "30s",
            "transactionMode": "file"
        },
        "suspend": false,
        "target": {
            "coordinationKey": "blog/fulfillment/primary",
            "engine": "PostgreSQL",
            "sharedRealm": false,
            "urlFrom": {
                "key": "url",
                "name": "demo-database"
            }
        }
    },
    "status": {
        "conditions": [
            {
                "lastTransitionTime": "2026-09-21T10:38:16Z",
                "message": "Database engine \"PostgreSQL\" is supported",
                "observedGeneration": 1,
                "reason": "SupportedEngine",
                "status": "True",
                "type": "EngineSupported"
            },
            {
                "lastTransitionTime": "2026-09-21T10:38:16Z",
                "message": "Plan is waiting for approval",
                "observedGeneration": 1,
                "reason": "AwaitingApproval",
                "status": "False",
                "type": "Ready"
            },
            {
                "lastTransitionTime": "2026-09-21T10:38:22Z",
                "message": "The latest operation completed",
                "observedGeneration": 1,
                "reason": "Succeeded",
                "status": "False",
                "type": "ReconciliationFailed"
            },
            {
                "lastTransitionTime": "2026-09-21T10:39:12Z",
                "message": "Desired OCI reference resolved to immutable content",
                "observedGeneration": 1,
                "reason": "DigestPinned",
                "status": "True",
                "type": "ArtifactResolved"
            },
            {
                "lastTransitionTime": "2026-09-21T10:39:15Z",
                "message": "Artifact type and verification policy were satisfied",
                "observedGeneration": 1,
                "reason": "PolicySatisfied",
                "status": "True",
                "type": "ArtifactVerified"
            },
            {
                "lastTransitionTime": "2026-09-21T10:38:32Z",
                "message": "Database schema was observed",
                "observedGeneration": 1,
                "reason": "Observed",
                "status": "True",
                "type": "DatabaseReachable"
            },
            {
                "lastTransitionTime": "2026-09-21T10:39:28Z",
                "message": "Managed scope requires 2 schema statements; highest severity safe",
                "observedGeneration": 1,
                "reason": "ScopedChanges",
                "status": "True",
                "type": "DriftDetected"
            },
            {
                "lastTransitionTime": "2026-09-21T10:39:28Z",
                "message": "The authoritative managed scope differs from the verified artifact",
                "observedGeneration": 1,
                "reason": "ScopedChanges",
                "status": "False",
                "type": "InSync"
            },
            {
                "lastTransitionTime": "2026-09-21T10:38:38Z",
                "message": "Create an approval bound to the current plan fingerprint",
                "observedGeneration": 1,
                "reason": "Waiting",
                "status": "True",
                "type": "ApprovalRequired"
            },
            {
                "lastTransitionTime": "2026-09-21T10:39:28Z",
                "message": "Exact plan bytes are stored in immutable chunks",
                "observedGeneration": 1,
                "reason": "Published",
                "status": "True",
                "type": "PlanReady"
            },
            {
                "lastTransitionTime": "2026-09-21T10:38:38Z",
                "message": "Reconciliation is active",
                "observedGeneration": 1,
                "reason": "Active",
                "status": "False",
                "type": "Suspended"
            }
        ],
        "executionBinding": {
            "controllerImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-operator@sha256:43779e7fc26eb3a9b328c671b1dee35fc60b9345a62544d85971d401cd245cb6",
            "controllerRevision": "6d72944c477c851a19d2662eb345ea313c921dd0",
            "controllerStateVersion": 1,
            "epoch": "v1-c237e28bf9ff760f211f283f88698519",
            "executorImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-executor@sha256:7a7dea71ff38cb6947d300552fb47dd8f4bb2bcdfa958f4d792685d3093479a9",
            "ptahVersion": "v0.7.0",
            "runnerImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-runner@sha256:43779e7fc26eb3a9b328c671b1dee35fc60b9345a62544d85971d401cd245cb6",
            "runnerProtocolVersion": 5
        },
        "lastAttemptTime": "2026-09-21T10:39:28Z",
        "nextReconciliationTime": "2026-09-21T10:39:58Z",
        "observedGeneration": 1,
        "phase": "AwaitingApproval",
        "plan": {
            "actualStateFingerprint": "sha256:5cac52535569a9b409ab69f47b6592b18a2f77b2f06075c0e72846bb8b189242",
            "artifactDigest": "sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "contentDigest": "sha256:2f0bf24db2890c475c9426fb35bb6808d74d408127c7414ad90d5cb2f863bf4a",
            "controllerImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-operator@sha256:43779e7fc26eb3a9b328c671b1dee35fc60b9345a62544d85971d401cd245cb6",
            "controllerRevision": "6d72944c477c851a19d2662eb345ea313c921dd0",
            "controllerStateVersion": 1,
            "coordinationDigest": "sha256:ffe501d44834d12840fe8618ae44c598f889b4e114447060fee3f7f1e7af063b",
            "createdAt": "2026-09-21T10:38:38Z",
            "desiredStateFingerprint": "sha256:be149363d48465d91a9849e2c55b3fc78256c9c28164c1de06309d9bb1c9e696",
            "destructive": false,
            "executionBindingID": "v1-c237e28bf9ff760f211f283f88698519",
            "executorImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-executor@sha256:7a7dea71ff38cb6947d300552fb47dd8f4bb2bcdfa958f4d792685d3093479a9",
            "fingerprint": "sha256:bf172ac05a4b865c6bfc1ff9e6be122368513d3824f4fc78c699751497bf0d9b",
            "name": "ptah-plan-bf172ac05a4b865c6bfc1ff9",
            "policyFingerprint": "sha256:d1bbcb8cdc1305ffb48395d7adea21e7210ff3bcf2481cb83d01e1fe73869d61",
            "ptahVersion": "v0.7.0",
            "runnerImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-runner@sha256:43779e7fc26eb3a9b328c671b1dee35fc60b9345a62544d85971d401cd245cb6",
            "runnerProtocolVersion": 5,
            "statementCount": 2,
            "targetIdentityDigest": "sha256:60e6e9da9dece534f03e2609d238924d00a4b30dec2238b49757fdd0cc64737c",
            "uid": "0f0a5b36-a40c-42a9-a730-a1d098d35ebe",
            "verificationPolicyDigest": "sha256:c84039b250125e32f0d51caea6afd1d13ebe4e5e0f90d382ee3be2c027574007",
            "verificationPolicyUID": "46e8fd80-2d1f-45b5-95bf-723cc6977f6b"
        },
        "source": {
            "artifactType": "application/vnd.stokaro.ptah.schema.v1",
            "digest": "sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "mediaType": "application/vnd.oci.image.manifest.v1+json",
            "requestedReference": "oci://e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/schemas/blog-shipments@sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "resolvedAt": "2026-09-21T10:39:12Z",
            "resolvedReference": "oci://e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/schemas/blog-shipments@sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "size": 812,
            "verificationPolicyDigest": "sha256:c84039b250125e32f0d51caea6afd1d13ebe4e5e0f90d382ee3be2c027574007",
            "verificationPolicyUID": "46e8fd80-2d1f-45b5-95bf-723cc6977f6b",
            "verified": true,
            "verifiedAt": "2026-09-21T10:39:15Z"
        },
        "target": {
            "coordinationDigest": "sha256:ffe501d44834d12840fe8618ae44c598f889b4e114447060fee3f7f1e7af063b",
            "driftFindingCount": 1,
            "driftFindings": [
                {
                    "category": "tables_added",
                    "count": 1,
                    "severity": "safe"
                }
            ],
            "driftReportDigest": "sha256:3cb4427c38c33d06c9f0800d20a23ef83efec2e22a83c8cdc5287c0043730341",
            "engine": "PostgreSQL",
            "highestDriftSeverity": "safe",
            "identityDigest": "sha256:60e6e9da9dece534f03e2609d238924d00a4b30dec2238b49757fdd0cc64737c",
            "lastObservedAt": "2026-09-21T10:39:22Z"
        }
    }
}