package Default
inherited_from \Zend\Db\Sql\AbstractPreparableSql

 Methods

Constructor

__construct(null|string|\Zend\Db\Sql\TableIdentifier $table = null

Parameters

$table

nullstring\Zend\Db\Sql\TableIdentifier

Overloading: variable retrieval

__get(string $name) : mixed

Retrieves value by column name

Parameters

$name

string

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

mixed

Overloading: variable isset

__isset(string $name) : boolean

Proxies to columns; does a column of that name exist?

Parameters

$name

string

Returns

boolean

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

\Zend\Db\Sql\Insert

Overloading: variable unset

__unset(string $name) : void

Proxies to values and columns

Parameters

$name

string

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Specify columns

columns(array $columns) : \Zend\Db\Sql\Insert

Parameters

$columns

array

Returns

\Zend\Db\Sql\Insert

Get raw state

getRawState(string $key = null) : mixed

Parameters

$key

string

Returns

mixed

Get SQL string for statement

getSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform = null
Inherited
inherited_from \Zend\Db\Sql\SqlInterface::getSqlString()

Parameters

$adapterPlatform

Create INTO clause

into(string|\Zend\Db\Sql\TableIdentifier $table) : \Zend\Db\Sql\Insert

Parameters

$table

string\Zend\Db\Sql\TableIdentifier

Returns

\Zend\Db\Sql\Insert

prepareStatement()

prepareStatement(\Zend\Db\Adapter\AdapterInterface $adapter, \Zend\Db\Adapter\StatementContainerInterface $statementContainer) : \Zend\Db\Adapter\StatementContainerInterface
Inherited
inherited_from \Zend\Db\Sql\PreparableSqlInterface::prepareStatement()

Parameters

$adapter

$statementContainer

Returns

\Zend\Db\Adapter\StatementContainerInterface

Create INTO SELECT clause

select(\Zend\Db\Sql\Select $select) : \Zend\Db\Sql\Insert
fluent This method is part of a fluent interface and will return the same instance

Parameters

$select

\Zend\Db\Sql\Select

Returns

\Zend\Db\Sql\Insert

Specify values to insert

values(array|\Zend\Db\Sql\Select $values, string $flag = self::VALUES_SET) : \Zend\Db\Sql\Insert

Parameters

$values

array\Zend\Db\Sql\Select

$flag

string

one of VALUES_MERGE or VALUES_SET; defaults to VALUES_SET

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

\Zend\Db\Sql\Insert

buildSqlString()

buildSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $platform, null|\Zend\Db\Adapter\Driver\DriverInterface $driver = null, null|\Zend\Db\Adapter\ParameterContainer $parameterContainer = null) : string
Inherited

Parameters

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

null\Zend\Db\Adapter\Driver\DriverInterface

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

createSqlFromSpecificationAndParameters()

createSqlFromSpecificationAndParameters(string|array $specifications, string|array $parameters) : string
Inherited

Parameters

$specifications

stringarray

$parameters

stringarray

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

Copy variables from the subject into the local properties

localizeVariables() 
Inherited

processExpression()

processExpression(\Zend\Db\Sql\ExpressionInterface $expression, \Zend\Db\Adapter\Platform\PlatformInterface $platform, null|\Zend\Db\Adapter\Driver\DriverInterface $driver = null, null|\Zend\Db\Adapter\ParameterContainer $parameterContainer = null, null|string $namedParameterPrefix = null) : string
Inherited
staticvar int $runtimeExpressionPrefix

Parameters

$expression

\Zend\Db\Sql\ExpressionInterface

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

null\Zend\Db\Adapter\Driver\DriverInterface

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

processInsert()

processInsert(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver = null, \Zend\Db\Adapter\ParameterContainer $parameterContainer = null

Parameters

$platform

$driver

$parameterContainer

processSelect()

processSelect(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver = null, \Zend\Db\Adapter\ParameterContainer $parameterContainer = null

Parameters

$platform

$driver

$parameterContainer

processSubSelect()

processSubSelect(\Zend\Db\Sql\Select $subselect, \Zend\Db\Adapter\Platform\PlatformInterface $platform, null|\Zend\Db\Adapter\Driver\DriverInterface $driver = null, null|\Zend\Db\Adapter\ParameterContainer $parameterContainer = null) : string
Inherited

Parameters

$subselect

\Zend\Db\Sql\Select

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

null\Zend\Db\Adapter\Driver\DriverInterface

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

resolveColumnValue()

resolveColumnValue(null|array|\Zend\Db\Sql\ExpressionInterface|\Zend\Db\Sql\Select $column, \Zend\Db\Adapter\Platform\PlatformInterface $platform, null|\Zend\Db\Adapter\Driver\DriverInterface $driver = null, null|\Zend\Db\Adapter\ParameterContainer $parameterContainer = null, null|string $namedParameterPrefix = null) : string
Inherited

Parameters

$column

nullarray\Zend\Db\Sql\ExpressionInterface\Zend\Db\Sql\Select

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

null\Zend\Db\Adapter\Driver\DriverInterface

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$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 = null, \Zend\Db\Adapter\ParameterContainer $parameterContainer = null) : string
Inherited

Parameters

$table

string\Zend\Db\Sql\TableIdentifier\Zend\Db\Sql\Select

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

\Zend\Db\Adapter\Driver\DriverInterface

$parameterContainer

\Zend\Db\Adapter\ParameterContainer

Returns

string

 Properties

 

$columns

$columns 

Default

array()
 

$instanceParameterIndex

$instanceParameterIndex : array

Default

array()
 

$processInfo

$processInfo : string

Default

array('paramPrefix' => '', 'subselectCount' => 0)
 

$select

$select : array | \Zend\Db\Sql\Select

Default

null
 

Specification array

$specifications : array

Default

array(self::SPECIFICATION_INSERT => 'INSERT INTO %1$s (%2$s) VALUES (%3$s)', self::SPECIFICATION_SELECT => 'INSERT INTO %1$s %2$s %3$s')
 

Specifications for Sql String generation

$specifications : array<mixed,string> | array<mixed,array>

Default

array()
 

$table

$table : string | \Zend\Db\Sql\TableIdentifier

Default

null

 Constants

 

SPECIFICATION_INSERT

SPECIFICATION_INSERT = 'insert' 
 

SPECIFICATION_SELECT

SPECIFICATION_SELECT = 'select' 
 

VALUES_MERGE

VALUES_MERGE = 'merge' 
 

VALUES_SET

VALUES_SET = 'set'