GPUdb.create_trigger_by_range( request_id = None, table_names = None,
column_name = None, _min = None, _max = None,
options = {} )
Sets up a simple range trigger for a column_name for one or more tables. Once the trigger has been activated, any record added to the listed tables(s) via insert_records with the chosen column_name's value falling within the specified range will trip the trigger. All such records will be queued at GPUdb's trigger port-by default '9001' but can also be obtained via show_system_status-for any listening client to collect. Active triggers can be cancelled by using the clear_trigger endpoint or by clearing all relevant tables.
The output returns the trigger handle as well as indicating success or failure of the trigger activation.
Input Parameter Description
| Name | Type | Description |
|---|---|---|
| request_id | str | ID for the trigger request. |
| table_names | list of str | Tables on which the trigger will be active. |
| column_name | str | Name of a numeric column_name on which the trigger is activated. |
| min | float | The lower bound (inclusive) for the trigger range. |
| max | float | The upper bound (inclusive) for the trigger range. |
| options | dict of str | Optional parameters. Default value is an empty dict ( {} ). |
Output Parameter Description
| Name | Type | Description |
|---|---|---|
| trigger_id | str | Value of input parameter request_id. |