{
"events": {
"name": "randomEvent",
"leadingDelimiter": "{{",
"trailingDelimiter": "{{",
"actions": [
{
"type": "executeQuerySQL",
"params": {
"async": false,
"sql": "Select count(*) FROM table1) as table1_count",
"queryParams": [],
"onSuccess": "table1_count",
"onSuccessType": "return"
}
},
{
"type": "showMessage",
"params": {
"text": "{{table1_count.results.0.table1_count}}{{table1_count.results.first.table1_count}}"
}
},
{
"type": "executeQuerySQL",
"params": {
"async": false,
"sql": "SELECT (Select count(*) FROM table1) as table1_count, (Select count(*) FROM table2) as table2_count",
"queryParams": [],
"onSuccess": "count",
"onSuccessType": "return"
}
},
{
"type": "setDelimiters",
"params": {
"leadingDelimiter": "{&",
"trailingDelimiter": "&}"
}
},
{
"type": "if",
"params": {
"async": false,
"condition": {
"left": {
"value": "{&count.results.0.table1_count&}{&count.results.first.table1_count&}"
},
"mode": "equal",
"right": {
"value": "{&count.results.0.table2_count&}{&count.results.first.table2_count&}"
}
},
"then": [
{
"type": "showMessage",
"params": {
"text": "Values are equal"
}
}
],
"else": [
{
"type": "showMessage",
"params": {
"text": "Values are different"
}
}
]
}
}
]
}
}