|
| setSubject ($select) |
|
| __construct ($table=null) |
| Constructor.
|
|
| from ($table) |
| Create from clause.
|
|
| quantifier ($quantifier) |
|
| columns (array $columns, $prefixColumnsWithTable=true) |
| Specify columns from which to select.
|
|
| join ($name, $on, $columns=self::SQL_STAR, $type=self::JOIN_INNER) |
| Create join clause.
|
|
| where ($predicate, $combination=Predicate\PredicateSet::OP_AND) |
| Create where clause.
|
|
| group ($group) |
|
| having ($predicate, $combination=Predicate\PredicateSet::OP_AND) |
| Create having clause.
|
|
| order ($order) |
|
| limit ($limit) |
|
| offset ($offset) |
|
| combine (Select $select, $type=self::COMBINE_UNION, $modifier= '') |
|
| reset ($part) |
|
| setSpecification ($index, $specification) |
|
| getRawState ($key=null) |
|
| isTableReadOnly () |
| Returns whether the table is read only or not.
|
|
| __get ($name) |
| Variable overloading.
|
|
| __clone () |
| __clone
|
|
| prepareStatement (AdapterInterface $adapter, StatementContainerInterface $statementContainer) |
| - Parameters
-
AdapterInterface | $adapter | |
StatementContainerInterface | $statementContainer | |
- Returns
- void
|
|
| getSqlString (PlatformInterface $adapterPlatform=null) |
| Get SQL string for statement.- Parameters
-
null | PlatformInterface | $adapterPlatform | |
- Returns
- string
|
|
|
| renderTable ($table, $alias=null) |
|
| localizeVariables () |
|
| processLimitOffset (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null, &$sqls=[], &$parameters=[]) |
|
| processStatementStart (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processStatementEnd (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processSelect (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
| Process the select part.
|
|
| processJoins (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processWhere (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processGroup (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processHaving (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processOrder (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processLimit (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processOffset (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| processCombine (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|
| resolveTable ($table, PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null) |
|