Class SelectDecorator

Summary

Fully Qualified Name: Zend\Db\Sql\Platform\Oracle\SelectDecorator
Extends: Select
Implements: PlatformDecoratorInterface

Description

Methods

Name Description Defined By
__clone() __clone Select
__construct() Constructor Select
__get() Variable overloading Select
columns() Specify columns from which to select Select
combine() Select
from() Create from clause Select
getRawState() Select
getSqlString() {@inheritDoc} AbstractSql
group() Select
having() Create having clause Select
isTableReadOnly() Returns whether the table is read only or not. Select
join() Create join clause Select
limit() Select
offset() Select
order() Select
prepareStatement() {@inheritDoc} AbstractPreparableSql
quantifier() Select
reset() Select
setSpecification() Select
setSubject() SelectDecorator
where() Create where clause Select

Method Details

__clone()

__clone

Resets the where object each time the Select is cloned.

Returns: void

__construct()

Constructor

Parameter Name Type Description
$table null|string|array|\TableIdentifier

Returns:

__get()

Variable overloading

Parameter Name Type Description
$name string

Returns: mixed

columns()

Specify columns from which to 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

Parameter Name Type Description
$columns array
$prefixColumnsWithTable bool

Returns: self Provides a fluent interface

combine()

Parameter Name Type Description
$select \Select
$type string
$modifier string

Returns: self Provides a fluent interface

from()

Create from clause

Parameter Name Type Description
$table string|array|\TableIdentifier

Returns: self Provides a fluent interface

getRawState()

Parameter Name Type Description
$key

Returns: void

getSqlString()

{@inheritDoc}

Parameter Name Type Description
$adapterPlatform

Returns:

group()

Parameter Name Type Description
$group mixed

Returns: self Provides a fluent interface

having()

Create having clause

Parameter Name Type Description
$predicate \Where|\Closure|string|array
$combination string One

Returns: self Provides a fluent interface

isTableReadOnly()

Returns whether the table is read only or not.

Returns: bool

join()

Create join clause

Parameter Name Type Description
$name string|array|\TableIdentifier
$on string|\Predicate\Expression
$columns string|array
$type string one

Returns: self Provides a fluent interface

limit()

Parameter Name Type Description
$limit int

Returns: self Provides a fluent interface

offset()

Parameter Name Type Description
$offset int

Returns: self Provides a fluent interface

order()

Parameter Name Type Description
$order string|array|\Expression

Returns: self Provides a fluent interface

prepareStatement()

{@inheritDoc}

Parameter Name Type Description
$adapter
$statementContainer

Returns: \StatementContainerInterface

quantifier()

Parameter Name Type Description
$quantifier string|\Expression DISTINCT|ALL

Returns: self Provides a fluent interface

reset()

Parameter Name Type Description
$part string

Returns: self Provides a fluent interface

setSpecification()

Parameter Name Type Description
$specification
$index
$specification

Returns: self Provides a fluent interface

setSubject()

Parameter Name Type Description
$select \Select

Returns:

where()

Create where clause

Parameter Name Type Description
$predicate \Where|\Closure|string|array|\Predicate\PredicateInterface
$combination string One

Returns: self Provides a fluent interface

Top