Creates an upsert query for one table of an API connection.
The API connection.
The name of the table to update or create a new record into.
The field values to set when the query is executed.
The field and values to set when the query is executed.
The table name where the new record is to be created.
An alias for go method.
The query execution timeout (milliseconds).
Asynchronously executes the insert query and, when fulfilled, returns the created row.
The query execution timeout (milliseconds).
Asynchronously executes the insert query and, when fulfilled, returns the number of affected (created) rows.
The query execution timeout (milliseconds).
Set the value to be assigned for a field when the query is executed.
The name of the field, use square brackets to specify an array item.
The value to set for that field.
Returns the current query instance (fluent interface).
Asynchronously executes the insert query on the connection and, when fulfilled, returns the created row or the number of rows affected.
An open connection to the akera.io application server.
The insert query definition, table name and at least the primary key values are mandatory.
If set to true the complete record will be returned if created (field values might be updated by triggers).
If set and a record with the same primary key values is found the record is updated, else the insert fails.
The query execution timeout (milliseconds).
An 'upsert' query is using the values of the primary key fields to find and update a record, if not found a new record is created and the query behaves like an 'insert'.
1.1.0
QueryInsert