UPDATE

Command

rhub add:action <group.eventId> <filterId> POSTGRESQL UPDATE

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: POSTGRESQL
action: INSERT
serviceAccountId: my-postgresql-account-id
template:
database: my-database
table: my-table
condition:
-
field: the-field-to-check
operator: 'mysql-operator (> , <, >=, etc..)'
value: the-value-to-check
payload:
keyName: '{keyName}'

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

payload

Key / Value object:

Key = The table column name

Value = The value to insert into the column