create_trigger_by_range
- create_trigger_by_range(
request_id: string,
table_names: string[],
column_name: string,
min: number,
max: number,
options?: Record<string, string>,
callback?: GPUdbCallback,
): Promise<CreateTriggerByRangeResponse>Parameters
- request_id: string
User-created ID for the trigger. The ID can be alphanumeric, contain symbols, and must contain at least one character.
- table_names: string[]
Tables on which the trigger will be active, each in [schema_name.]table_name format, using standard name resolution rules.
- column_name: string
Name of a numeric column_name on which the trigger is activated.
- min: number
The lower bound (inclusive) for the trigger range.
- max: number
The upper bound (inclusive) for the trigger range.
Optionaloptions: Record<string, string>Optional parameters.
Optionalcallback: GPUdbCallbackOptional callback function
Returns Promise<CreateTriggerByRangeResponse>
Promise<Types.CreateTriggerByRangeResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:7008
- request_id: string
create_trigger_by_range_request
- create_trigger_by_range_request(
request: CreateTriggerByRangeRequest,
callback?: GPUdbCallback,
): Promise<CreateTriggerByRangeResponse>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_recordswith the chosen column_name’s value falling within the specified range will trip the trigger. All such records will be queued at the trigger port (by default ‘9001’ but able to be retrieved viashow_system_status) for any listening client to collect. Active triggers can be cancelled by using theclear_triggerendpoint or by clearing all relevant tables.The output returns the trigger handle as well as indicating success or failure of the trigger activation.
Parameters
- request: CreateTriggerByRangeRequest
Request object containing the parameters for the operation
Optionalcallback: GPUdbCallbackOptional callback function
Returns Promise<CreateTriggerByRangeResponse>
Promise<Types.CreateTriggerByRangeResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:6967
- request: CreateTriggerByRangeRequest
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_recordswith the chosen column_name’s value falling within the specified range will trip the trigger. All such records will be queued at the trigger port (by default ‘9001’ but able to be retrieved viashow_system_status) for any listening client to collect. Active triggers can be cancelled by using theclear_triggerendpoint or by clearing all relevant tables.The output returns the trigger handle as well as indicating success or failure of the trigger activation.