Methods
Overloading: variable retrieval
__get(string $name) : mixed
Retrieves value by column name
Parameters
$name
string
Exceptions
Returns
mixed
Overloading: variable isset
__isset(string $name) : bool
Proxies to columns; does a column of that name exist?
Parameters
$name
string
Returns
bool
Overloading: variable setting
__set(string $name, mixed $value) : \Zend\Db\Sql\Insert
Proxies to values, using VALUES_MERGE strategy
Parameters
$name
string
$value
mixed
Returns
Overloading: variable unset
__unset(string $name) : void
Proxies to values and columns
Parameters
$name
string
Exceptions
Specify columns
columns(array $columns) : \Zend\Db\Sql\Insert
Parameters
$columns
array
Returns
Get raw state
getRawState(string $key) : mixed
Parameters
$key
string
Returns
mixed
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
Create INTO SELECT clause
select(\Zend\Db\Sql\Select $select) : \Zend\Db\Sql\self
Parameters
Returns
\Zend\Db\Sql\self
Specify values to insert
values(array | \Zend\Db\Sql\Select $values, string $flag) : \Zend\Db\Sql\Insert
Parameters
$flag
stringone of VALUES_MERGE or VALUES_SET; defaults to VALUES_SET
Exceptions
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
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
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
$namedParameterPrefix
nullstring
Exceptions
Returns
string
processInsert()
processInsert(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
processSelect()
processSelect(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
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
Returns
string
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
$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
$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 : array
Constants
SPECIFICATION_INSERT
SPECIFICATION_INSERT
SPECIFICATION_SELECT
SPECIFICATION_SELECT
VALUES_MERGE
VALUES_MERGE