Zend\Db\Sql\Platform\Mysql\SelectDecorator
Synopsis
class SelectDecorator
extends Select
implements
PlatformDecoratorInterface
{
- // Inherited constants from Select
- const SELECT = 'select';
- const QUANTIFIER = 'quantifier';
- const COLUMNS = 'columns';
- const TABLE = 'table';
- const JOINS = 'joins';
- const WHERE = 'where';
- const GROUP = 'group';
- const HAVING = 'having';
- const ORDER = 'order';
- const LIMIT = 'limit';
- const OFFSET = 'offset';
- const QUANTIFIER_DISTINCT = 'DISTINCT';
- const QUANTIFIER_ALL = 'ALL';
- const JOIN_INNER = 'inner';
- const JOIN_OUTER = 'outer';
- const JOIN_LEFT = 'left';
- const JOIN_RIGHT = 'right';
- const SQL_STAR = '*';
- const ORDER_ASCENDING = 'ASC';
- const ORDER_DESCENDING = 'DESC';
- const COMBINE = 'combine';
- const COMBINE_UNION = 'union';
- const COMBINE_EXCEPT = 'except';
- const COMBINE_INTERSECT = 'intersect';
- // members
- protected Select $select;
- // Inherited members from Select
- protected array $specifications;
- protected bool $tableReadOnly;
- protected bool $prefixColumnsWithTable;
- protected string|array|TableIdentifier $table;
- protected null|string|Expression $quantifier;
- protected array $columns;
- protected array $joins;
- protected Where $where;
- protected array $order;
- protected null|array $group;
- protected null|string|array $having;
- protected int|null $limit;
- protected int|null $offset;
- protected array $combine;
- // Inherited members from AbstractSql
- protected array $specifications;
- protected array $processInfo;
- protected array $instanceParameterIndex;
- // methods
- public void setSubject()
- public void prepareStatement()
- public string getSqlString()
- protected void processLimit()
- protected void processOffset()
- // Inherited methods from Select
- public void __construct()
- public Select from()
- public Select quantifier()
- public Select columns()
- public Select join()
- public Select where()
- public void group()
- public Select having()
- public Select order()
- public Select limit()
- public Select offset()
- public Select combine()
- public Select reset()
- public void setSpecification()
- public void getRawState()
- public void prepareStatement()
- public string getSqlString()
- public bool isTableReadOnly()
- protected string renderTable()
- protected void processStatementStart()
- protected void processStatementEnd()
- protected null|array processSelect()
- protected void processJoins()
- protected void processWhere()
- protected void processGroup()
- protected void processHaving()
- protected void processOrder()
- protected void processLimit()
- protected void processOffset()
- protected void processCombine()
- public mixed __get()
- public void __clone()
- // Inherited methods from AbstractSql
- protected void processExpression()
- protected string createSqlFromSpecificationAndParameters()
- protected void processSubSelect()
Hierarchy
Tasks
Line | Task |
---|---|
555+ | move TableIdentifier concatination here |
Constants
Name | Value |
---|---|
SELECT | 'select' |
QUANTIFIER | 'quantifier' |
COLUMNS | 'columns' |
TABLE | 'table' |
JOINS | 'joins' |
WHERE | 'where' |
GROUP | 'group' |
HAVING | 'having' |
ORDER | 'order' |
LIMIT | 'limit' |
OFFSET | 'offset' |
QUANTIFIER_DISTINCT | 'DISTINCT' |
QUANTIFIER_ALL | 'ALL' |
JOIN_INNER | 'inner' |
JOIN_OUTER | 'outer' |
JOIN_LEFT | 'left' |
JOIN_RIGHT | 'right' |
SQL_STAR | '*' |
ORDER_ASCENDING | 'ASC' |
ORDER_DESCENDING | 'DESC' |
COMBINE | 'combine' |
COMBINE_UNION | 'union' |
COMBINE_EXCEPT | 'except' |
COMBINE_INTERSECT | 'intersect' |
Members
protected
- $columns — array
- $combine — array
- $group — Zend\Db\Sql\null|array
- $having — Zend\Db\Sql\null|string|array
- $instanceParameterIndex — array
- $joins — array
- $limit — Zend\Db\Sql\int|null
- $offset — Zend\Db\Sql\int|null
- $order — array
- $prefixColumnsWithTable — Zend\Db\Sql\bool
- $processInfo — string
- $quantifier — Zend\Db\Sql\null|string|Expression
- $select — Zend\Db\Sql\Select
- $specifications — array
- $specifications — array
- $table — Zend\Db\Sql\string|array|TableIdentifier
- $tableReadOnly — Zend\Db\Sql\bool
- $where — Zend\Db\Sql\Where
Methods
protected
public
Inherited from Zend\Db\Sql\Select
protected
- processCombine()
- processGroup()
- processHaving()
- processJoins()
- processLimit()
- processOffset()
- processOrder()
- processSelect() — Process the select part
- processStatementEnd()
- processStatementStart()
- processWhere()
- renderTable() — Render table with alias in from/join parts
public
- __clone() — __clone
- __get() — Variable overloading
- columns() — Specify columns from which to select
- combine()
- from() — Create from clause
- getRawState()
- getSqlString() — Get SQL string for statement
- group()
- having() — Create where clause
- isTableReadOnly() — Returns whether the table is read only or not.
- join() — Create join clause
- limit()
- offset()
- order()
- prepareStatement() — Prepare statement
- quantifier()
- reset()
- setSpecification()
- where() — Create where clause