Methods

__clone

__clone() : void

Resets the where object each time the Update is cloned.

Constructor

__construct(null | string | \Zend\Db\Sql\TableIdentifier $table) 

Parameters

$table

nullstring\Zend\Db\Sql\TableIdentifier

Variable overloading

__get(string $name) : mixed

Proxies to "where" only

Parameters

$name

string

Returns

mixed

getRawState()

getRawState($key) 

Parameters

$key

Get SQL string for statement

getSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::getSqlString()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::getSqlString()

Parameters

Returns

string

prepareStatement()

prepareStatement(\Zend\Db\Adapter\AdapterInterface $adapter, \Zend\Db\Adapter\StatementContainerInterface $statementContainer) : \Zend\Db\Adapter\StatementContainerInterface
Inherited

inherited_from \Zend\Db\Sql\AbstractPreparableSql::prepareStatement()

Parameters

Returns

Set key/value pairs to update

set(array $values, string $flag) : \Zend\Db\Sql\Update

Parameters

$values

array

Associative array of key values

$flag

string

One of the VALUES_* constants

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

Specify table for statement

table(string | \Zend\Db\Sql\TableIdentifier $table) : \Zend\Db\Sql\Update

Parameters

Returns

Create where clause

where(\Zend\Db\Sql\Where | \Closure | string | array $predicate, string $combination) : \Zend\Db\Sql\Update

Parameters

$predicate

\Zend\Db\Sql\Where\Closurestringarray

$combination

string

One of the OP_* constants from Predicate\PredicateSet

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

buildSqlString()

buildSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::buildSqlString()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::buildSqlString()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

createSqlFromSpecificationAndParameters()

createSqlFromSpecificationAndParameters(string | array $specifications, string | array $parameters) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::createSqlFromSpecificationAndParameters()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::createSqlFromSpecificationAndParameters()

Parameters

$specifications

stringarray

$parameters

stringarray

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

Copy variables from the subject into the local properties

localizeVariables() 
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::localizeVariables()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::localizeVariables()

processExpression()

processExpression(\Zend\Db\Sql\ExpressionInterface $expression, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer, null | string $namedParameterPrefix) : string
Inherited

staticvar int $runtimeExpressionPrefix
inherited_from \Zend\Db\Sql\AbstractSql::processExpression()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::processExpression()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

processSubSelect()

processSubSelect(\Zend\Db\Sql\Select $subselect, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::processSubSelect()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::processSubSelect()

Parameters

$subselect

\Zend\Db\Sql\Select

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

processUpdate()

processUpdate(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 

Parameters

$platform

$driver

$parameterContainer

processWhere()

processWhere(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 

Parameters

$platform

$driver

$parameterContainer

resolveColumnValue()

resolveColumnValue(null | array | \Zend\Db\Sql\ExpressionInterface | \Zend\Db\Sql\Select $column, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer, null | string $namedParameterPrefix) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::resolveColumnValue()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::resolveColumnValue()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Returns

string

resolveTable()

resolveTable(string | \Zend\Db\Sql\TableIdentifier | \Zend\Db\Sql\Select $table, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::resolveTable()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::resolveTable()

Parameters

Returns

string

 Properties

 

$where

$where : \Zend\Db\Sql\Where

magic
property
 

$emptyWhereProtection

$emptyWhereProtection : bool

 

$instanceParameterIndex

$instanceParameterIndex : array
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::$$instanceParameterIndex
inherited_from \Zend\Db\Sql\AbstractPreparableSql::$$instanceParameterIndex
 

$processInfo

$processInfo : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::$$processInfo
inherited_from \Zend\Db\Sql\AbstractPreparableSql::$$processInfo
   

Specifications for Sql String generation

$specifications : string[] | array[]

 

$table

$table : string | \Zend\Db\Sql\TableIdentifier

 

$where

$where : string | \Zend\Db\Sql\Where

 Constants

 

SPECIFICATION_UPDATE

SPECIFICATION_UPDATE 

 

SPECIFICATION_WHERE

SPECIFICATION_WHERE 

 

VALUES_MERGE

VALUES_MERGE 

 

VALUES_SET

VALUES_SET