Overview
Inserts or updates a row in table by specified column and value as single criteria. Only included columns get updated.DataRow $Database.EnsureData(schema: string, table: string, column: string, value: any, input: object)
DataRow $Database.EnsureData(schema: string, table: string, column: string, value: any, input: object, initInput: object)
DataRow $Database.EnsureData(store: string, schema: string, table: string, column: string, value: any, input: object)
DataRow $Database.EnsureData(store: string, schema: string, table: string, column: string, value: any, input: object, initInput: object)
Arguments
string schema
Name of target schema
string table
Name of target table
string column
Name of column to use as criteria
any value
Value of column to use as criteria
object input
Object or function for column values for updating.
object initInput
Object or function for initialize for new rows. Optional.
string store
Name or Id number of target data store. This parameter is optional.
string store
name of store
string schema
name of schema
string table
name of table
string column
name of column to compare
any value
value to compare
object input
row values
object initInput
row values if row does not exists
Example
Code Block | ||
---|---|---|
| ||
$Database.EnsureData("MySchema", "MyTable", "Id", id, { Id : id, Name : $Xml.Evaluate('Name') }, { CreateDate : DateTimeOffset.now }); |
Examples
Code Block | ||
---|---|---|
| ||
$Database.EnsureData("MySchema", "MyTable", "Id", id, { Id : id, Name : $Xml.Evaluate('Name') }, { CreateDate : DateTimeOffset.now }); |