SQLAssignmentRow

Instantiate a new SQLAssignmentRow object with the given values

Given a key / value pair, extract the predicate and any potential parameters in a format suitable for storing internally as a list of paramaterised conditions.

Given a list of assignments in any user-acceptible format, normalise the value to a common ['SQL' => [parameters]] format

Adds assignments for a list of several fields

Note that field values must not be escaped, as these will be internally parameterised by the database engine.

// Basic assignments
$query->addAssignments([
     '"Object"."Title"' => 'Bob',
     '"Object"."Description"' => 'Bob was here'
])

// Parameterised assignments
$query->addAssignments([
     '"Object"."Title"' => ['?' => 'Bob'],
     '"Object"."Description"' => ['?' => null]
])

// Complex parameters
$query->addAssignments([
     '"Object"."Score"' => ['MAX(?,?)' => [1, 3]]
]);

// Assignment of literal SQL for a field. The empty array is
// important to denote the zero-number parameter list
$query->addAssignments([
     '"Object"."Score"' => ['NOW()' => []]
]);

Sets the list of assignments to the given list

Retrieves the list of assignments in parameterised format

Set the value for a single field

E.g.

// Literal assignment
$query->assign('"Object"."Description"', 'lorum ipsum');

// Single parameter
$query->assign('"Object"."Title"', ['?' => 'Bob']);

// Complex parameters
$query->assign('"Object"."Score"', ['MAX(?,?)' => [1, 3]]);

Assigns a value to a field using the literal SQL expression, rather than a value to be escaped

Determine if this assignment is empty

Retrieves the list of columns updated

Clears all assignment values