Table of Contents
KEYVALUE UPSERT
Syntax
KEYVALUE keyvalue_name [OF TABLE TABLE_NAME | OF LINK link_name] UPSERT ( vext_keyvalue_list ) [FOR RECORD { UINT | vext_link_list_of_records } ]
vext_keyvalue_list
: vext_keyvalue, ...
vext_keyvalue
: vext_key COLON vext_value
vext_key_list
: vext_key, ...
vext_key
: character_string_literal
vext_value
: character_string_literal
| variable_name
| dynamic_parameter_specification
| TRUE
| FALSE
vext_link_list_of_records
: ( vext_link_value, ... )
vext_link_value
: UINT | dynamic_parameter_specification
Description
This command do UPDATE or INSERT.
IF the given KEY exists in KeyValue store, then it UPDATEs it by a new VALUE, otherwise, it INSERTs pair KEY:VALUE.
Examples
KEYVALUE kvProperties UPSERT ( '545.name' : 'Bob', '545.age' : 29 );