Skip to main content

Repository

🧪 test-data.json

  • ID: /ce/ca/google/sql/instance-idle/test-data.json

Used In

LogicPolicyFlags
🧠 prod.logic.yaml🟢🛡️ Google Cloud SQL Instance is idle🟢🟢 x3

Content

Open File

[
{
"expectedResult": {
"status": "DISAPPEARED",
"conditionIndex": "99",
"conditionText": "isDisappeared(CA10__disappearanceTime__c)",
"runtimeError": null
},
"context": {
"snapshotTime": "2025-09-22T23:38:09Z"
},
"Id": "001",
"CA10__disappearanceTime__c": "2025-09-22T23:38:09Z",
"CA10__state__c": "RUNNABLE",
"CA10__createTime__c": "2025-09-12T17:07:12Z",
"CA10__cpuUtilizationAvg30Day__c": 1,
"CA10__cloudSqlConnectionsAvg30Day__c": 0
},
{
"expectedResult": {
"status": "INAPPLICABLE",
"conditionIndex": "199",
"conditionText": "extract('CA10__state__c') != 'RUNNABLE'",
"runtimeError": null
},
"context": {
"snapshotTime": "2025-09-22T23:38:09Z"
},
"Id": "002",
"CA10__disappearanceTime__c": null,
"CA10__state__c": "FAILED",
"CA10__createTime__c": "2025-08-18T18:26:19Z",
"CA10__cpuUtilizationAvg30Day__c": 1,
"CA10__cloudSqlConnectionsAvg30Day__c": 0
},
{
"expectedResult": {
"status": "INAPPLICABLE",
"conditionIndex": "299",
"conditionText": "not(extract('CA10__createTime__c').beyondLastDays(30))",
"runtimeError": null
},
"context": {
"snapshotTime": "2025-09-22T23:38:09Z"
},
"Id": "003",
"CA10__disappearanceTime__c": null,
"CA10__state__c": "RUNNABLE",
"CA10__createTime__c": "2025-09-18T18:26:19Z",
"CA10__cpuUtilizationAvg30Day__c": 1,
"CA10__cloudSqlConnectionsAvg30Day__c": 0
},
{
"expectedResult": {
"status": "UNDETERMINED",
"conditionIndex": "399",
"conditionText": "extract('CA10__cpuUtilizationAvg30Day__c').isEmpty() || extract('CA10__cloudSqlConnectionsAvg30Day__c').isEmpty()",
"runtimeError": null
},
"context": {
"snapshotTime": "2025-09-22T23:38:09Z"
},
"Id": "004",
"CA10__disappearanceTime__c": null,
"CA10__state__c": "RUNNABLE",
"CA10__createTime__c": "2025-08-18T18:26:19Z",
"CA10__cpuUtilizationAvg30Day__c": null,
"CA10__cloudSqlConnectionsAvg30Day__c": null
},
{
"expectedResult": {
"status": "INCOMPLIANT",
"conditionIndex": "499",
"conditionText": "extract('CA10__cpuUtilizationAvg30Day__c') < number(5.0) && extract('CA10__cloudSqlConnectionsAvg30Day__c') <= number(0.0)",
"runtimeError": null
},
"context": {
"snapshotTime": "2025-09-22T23:38:09Z"
},
"Id": "005",
"CA10__disappearanceTime__c": null,
"CA10__state__c": "RUNNABLE",
"CA10__createTime__c": "2025-08-18T18:26:19Z",
"CA10__cpuUtilizationAvg30Day__c": 1,
"CA10__cloudSqlConnectionsAvg30Day__c": 0
},
{
"expectedResult": {
"status": "COMPLIANT",
"conditionIndex": "500",
"conditionText": "otherwise",
"runtimeError": null
},
"context": {
"snapshotTime": "2025-09-22T23:38:09Z"
},
"Id": "006",
"CA10__disappearanceTime__c": null,
"CA10__state__c": "RUNNABLE",
"CA10__createTime__c": "2025-03-24T14:34:15Z",
"CA10__cpuUtilizationAvg30Day__c": 5,
"CA10__cloudSqlConnectionsAvg30Day__c": 1
}
]