🧠 AWS RDS Aurora Cluster access is not consistent - prod.logic.yaml 🟢

• Contextual name: 🧠 prod.logic.yaml 🟢
• ID: /ce/ca/aws/rds/aurora-cluster-access-consistency/prod.logic.yaml
• Located in: 📝 AWS RDS Aurora Cluster access is not consistent 🟢

Flags

• 🟢 Logic test success
• 🟢 Logic with extracts
• 🟢 Logic with test data

Input Type

	Type	API Name	Extracts	Extract Files	Logic Files
🔒	📕 AWS RDS Cluster	CA10__CaAwsDbCluster__c	1	1	1

Uses

• 🔌 AWS RDS Cluster - object.extracts.yaml
• 🔌 AWS RDS Instance - object.extracts.yaml
• 🧪 test-data.json

Test Results 🟢

Generated at: 2025-04-24T23:45:01.599496509Z Open

Result	Id	Condition Index	Condition Text	Runtime Error
🟢	test1	✔️ 99	✔️ isDisappeared(CA10__disappearanceTime__c)	✔️ null
🟢	test2	✔️ 299	✔️ CA10__AWS_RDS_Instances__r.hasNo(COMPLIANT) && CA10__AWS_RDS_Instances__r.hasNo(INCOMPLIANT)	✔️ null
🟢	test3	✔️ 299	✔️ CA10__AWS_RDS_Instances__r.hasNo(COMPLIANT) && CA10__AWS_RDS_Instances__r.hasNo(INCOMPLIANT)	✔️ null
🟢	test4	✔️ 499	✔️ CA10__AWS_RDS_Instances__r.has(COMPLIANT) && CA10__AWS_RDS_Instances__r.hasNo(INCOMPLIANT)	✔️ null
🟢	test5	✔️ 399	✔️ CA10__AWS_RDS_Instances__r.has(INCOMPLIANT) && CA10__AWS_RDS_Instances__r.hasNo(COMPLIANT)	✔️ null
🟢	test6	✔️ 500	✔️ otherwise	✔️ null

Generation

	File	MD5
Open	/ce/ca/aws/rds/aurora-cluster-access-consistency/policy.yaml	79346DCB17FC324055AB6EBE1C389A72
Open	/ce/ca/aws/rds/aurora-cluster-access-consistency/prod.logic.yaml	86D3EF26A0994303F4006B88E8621D0F
Open	/types/CA10__CaAwsDbCluster__c/object.extracts.yaml	F3726ACA49C05970E0F328FFB5CAB41F
Open	/types/CA10__CaAwsDbInstance__c/object.extracts.yaml	FF9B20D94B2A03C8B9A5C755DC5EF3A9
Open	/ce/ca/aws/rds/aurora-cluster-access-consistency/test-data.json	32C9C07967A8FCAD575B495AB19FBB49

Generate FULL script

java -jar repo-manager.jar policies generate FULL /ce/ca/aws/rds/aurora-cluster-access-consistency/prod.logic.yaml

Generate DEBUG script

java -jar repo-manager.jar policies generate DEBUG /ce/ca/aws/rds/aurora-cluster-access-consistency/prod.logic.yaml

Generate CAPTURE_TEST_DATA script

java -jar repo-manager.jar policies generate CAPTURE_TEST_DATA /ce/ca/aws/rds/aurora-cluster-access-consistency/prod.logic.yaml

Generate TESTS script

java -jar repo-manager.jar policies generate TESTS /ce/ca/aws/rds/aurora-cluster-access-consistency/prod.logic.yaml

Execute tests

java -jar repo-manager.jar policies test /ce/ca/aws/rds/aurora-cluster-access-consistency/prod.logic.yaml

Content

Open File

---
inputType: CA10__CaAwsDbCluster__c
importExtracts:
  - file: /types/CA10__CaAwsDbCluster__c/object.extracts.yaml
testData:
  - file: "test-data.json"
conditions:
  - status: INAPPLICABLE
    currentStateMessage: This Policy applies only to AWS RDS Aurora clusters.
    check:
      NOT:
        arg:
          STARTS_WITH:
              arg:
                EXTRACT: CA10__engine__c
              prefix:
                TEXT: aurora
  - status: INAPPLICABLE
    currentStateMessage: This AWS RDS Aurora cluster has no related AWS RDS Instances.
    check:
      AND:
        args:
          - RELATED_LIST_HAS_NO:
              relationshipName: CA10__AWS_RDS_Instances__r
              status: COMPLIANT
          - RELATED_LIST_HAS_NO:
              relationshipName: CA10__AWS_RDS_Instances__r
              status: INCOMPLIANT        
  - status: COMPLIANT
    currentStateMessage: This AWS RDS Aurora cluster's accessibility is consistent. 
      All RDS Aurora Instances within the cluster are publicly accessible.
    check:
      AND:
        args:
          - RELATED_LIST_HAS:
              relationshipName: CA10__AWS_RDS_Instances__r
              status: INCOMPLIANT
          - RELATED_LIST_HAS_NO:
              relationshipName: CA10__AWS_RDS_Instances__r
              status: COMPLIANT              
  - status: COMPLIANT
    currentStateMessage: This AWS RDS Aurora cluster's accessibility is consistent. 
      All RDS Aurora Instances within the cluster are private.
    check:
      AND:
        args:
          - RELATED_LIST_HAS:
              relationshipName: CA10__AWS_RDS_Instances__r
              status: COMPLIANT
          - RELATED_LIST_HAS_NO:
              relationshipName: CA10__AWS_RDS_Instances__r
              status: INCOMPLIANT               
otherwise:
  status: INCOMPLIANT
  currentStateMessage: This AWS RDS Aurora cluster's accessibility is not consistent.
  remediationMessage: Consider modifying the accessibility of all AWS RDS Instances within the cluster
    to be either public or private.
relatedLists:
  - relationshipName: CA10__AWS_RDS_Instances__r
    importExtracts:
      - file: /types/CA10__CaAwsDbInstance__c/object.extracts.yaml
    conditions:
      - status: INAPPLICABLE
        currentStateMessage: This Policy applies only to AWS RDS Aurora Instances.
        check:
          NOT:
            arg:
              STARTS_WITH:
                arg:
                  EXTRACT: CA10__engine__c
                prefix:
                  TEXT: aurora
      - status: INCOMPLIANT
        currentStateMessage: This AWS RDS Instance is publicly accessible.
        remediationMessage: N/A
        check:
          IS_EQUAL:
            left:
              EXTRACT: CA10__publiclyAccessible__c
            right:
              BOOLEAN: true 
    otherwise:
      status: COMPLIANT
      currentStateMessage: This AWS RDS Instance is private.