DELETE

Command

rhub add:action <group.eventId> <filterId> MYSQL DELETE

Param

Description

eventId

The event that will receive te action.

Example: payment.payment-fulfilled

filterId

The filter/trigger in the event that will process the action.

Example: on-event

Prompt Questions

Question

Description

Database Name

The database name in the service account.

Table Name

The table name of the informed database.

Has WHERE condition?

If YES, create a condition node in the YAML file;

UPDATE
UPDATE

YAML

-
id: my-action
async: false
type: MYSQL
action: INSERT
serviceAccountId: my-mysql-account-id
template:
database: my-database
table: my-table
condition:
-
field: the-field-to-check
operator: 'mysql-operator (> , <, >=, etc..)'
value: the-value-to-check

YAML PARAMS

Params

Description

id, async, type, action, operation, serviceAccountId

The action default parameters, see more.

database

The database name of the service account.

table

The table name of the informed database.

condition.[]

Array of condition objects to apply to the UPDATE statement.

condition.[].field

The table column to check

condition.[].operator

SQL operator (>, <, >= , etc ...)

condition.[].value

The value to check in the statement