Methods
__clone
__clone() : void
Resets the where object each time the Select is cloned.
Variable overloading
__get(string $name) : mixed
Parameters
$name
string
Exceptions
Returns
mixed
Specify columns from which to select
columns(array $columns, bool $prefixColumnsWithTable) : \Zend\Db\Sql\Select
Possible valid states:
array(*)
array(value, ...)
value can be strings or Expression objects
array(string => value, ...)
key string will be use as alias,
value can be string or Expression objects
Parameters
$columns
array
$prefixColumnsWithTable
bool
Returns
combine()
combine(\Zend\Db\Sql\Select $select, string $type, string $modifier) : \Zend\Db\Sql\Select
Parameters
$type
string
$modifier
string
Exceptions
Returns
getRawState()
getRawState($key)
Get SQL string for statement
getSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : string
Parameters
Returns
string
Returns whether the table is read only or not.
isTableReadOnly() : bool
Create join clause
join(string | array $name, string $on, string | array $columns, string $type) : \Zend\Db\Sql\Select
Parameters
$name
stringarray
$on
string
$columns
stringarray
$type
string
one of the JOIN_* constants
Exceptions
Returns
order()
order(string | array $order) : \Zend\Db\Sql\Select
Parameters
$order
stringarray
Returns
Prepare statement
prepareStatement(\Zend\Db\Adapter\AdapterInterface $adapter, \Zend\Db\Adapter\StatementContainerInterface $statementContainer) : void
setSpecification()
setSpecification($index, $specification)
Parameters
$index
$specification
createSqlFromSpecificationAndParameters()
createSqlFromSpecificationAndParameters($specifications, $parameters) : string
Inherited
inherited_from |
\Zend\Db\Sql\AbstractSql::createSqlFromSpecificationAndParameters() |
Parameters
$specifications
$parameters
Exceptions
Returns
string
processCombine()
processCombine(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
processExpression()
processExpression(\Zend\Db\Sql\ExpressionInterface $expression, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, $namedParameterPrefix)
Inherited
inherited_from |
\Zend\Db\Sql\AbstractSql::processExpression() |
Parameters
$expression
$platform
$driver
$namedParameterPrefix
processGroup()
processGroup(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
processHaving()
processHaving(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
processJoins()
processJoins(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
processLimit()
processLimit(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
processOffset()
processOffset(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
processOrder()
processOrder(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
Process the select part
processSelect(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : null | array
Parameters
Returns
null
array
processStatementEnd()
processStatementEnd(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer)
Parameters
$platform
$driver
$parameterContainer
processStatementStart()
processStatementStart(\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)
Inherited
inherited_from |
\Zend\Db\Sql\AbstractSql::processSubSelect() |
Parameters
$subselect
$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
Render table with alias in from/join parts
renderTable(string $table, string $alias) : string
todo |
move TableIdentifier concatination here |
Parameters
$table
string
$alias
string
Returns
string
Properties
$columns
$columns : array
$combine
$combine : array
$group
$group : null | array
$having
$having : null | string | array
$instanceParameterIndex
$instanceParameterIndex : array
Inherited
inherited_from |
\Zend\Db\Sql\AbstractSql::$$instanceParameterIndex |
$limit
$limit : int | null
$offset
$offset : int | null
$prefixColumnsWithTable
$prefixColumnsWithTable : bool
$processInfo
$processInfo : string
Inherited
inherited_from |
\Zend\Db\Sql\AbstractSql::$$processInfo |
<p>Specifications</p>
$specifications : array
$tableReadOnly
$tableReadOnly : bool
Constants
COMBINE_EXCEPT
COMBINE_EXCEPT
COMBINE_INTERSECT
COMBINE_INTERSECT
COMBINE_UNION
COMBINE_UNION
ORDER_ASCENDING
ORDER_ASCENDING
ORDER_DESCENDING
ORDER_DESCENDING
QUANTIFIER_ALL
QUANTIFIER_ALL
QUANTIFIER_DISTINCT
QUANTIFIER_DISTINCT