SQLWriteExpression

Adds assignments for a list of several fields.

For multi-row objects this applies this to the current row.

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

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

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

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

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

Sets the list of assignments to the given list

For multi-row objects this applies this to the current row.

Retrieves the list of assignments in parameterised format

For multi-row objects returns assignments for the current row.

Set the value for a single field

For multi-row objects this applies this to the current row.

E.g.

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

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

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

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

For multi-row objects this applies this to the current row.