Methods

__construct()

__construct(string $table) 

Parameters

$table

string

addColumn()

addColumn(\Zend\Db\Sql\Ddl\Column\ColumnInterface $column) : \Zend\Db\Sql\Ddl\self

Parameters

Returns

\Zend\Db\Sql\Ddl\self

addConstraint()

addConstraint(\Zend\Db\Sql\Ddl\Constraint\ConstraintInterface $constraint) : \Zend\Db\Sql\Ddl\self

Parameters

Returns

\Zend\Db\Sql\Ddl\self

changeColumn()

changeColumn(string $name, \Zend\Db\Sql\Ddl\Column\ColumnInterface $column) : \Zend\Db\Sql\Ddl\self

Parameters

$name

string

Returns

\Zend\Db\Sql\Ddl\self

dropColumn()

dropColumn(string $name) : \Zend\Db\Sql\Ddl\self

Parameters

$name

string

Returns

\Zend\Db\Sql\Ddl\self

dropConstraint()

dropConstraint(string $name) : \Zend\Db\Sql\Ddl\self

Parameters

$name

string

Returns

\Zend\Db\Sql\Ddl\self

getRawState()

getRawState(string | null $key) : array

Parameters

$key

stringnull

Returns

array

Get SQL string for statement

getSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::getSqlString()

Parameters

Returns

string

setTable()

setTable(string $name) : \Zend\Db\Sql\Ddl\self

Parameters

$name

string

Returns

\Zend\Db\Sql\Ddl\self

buildSqlString()

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

inherited_from \Zend\Db\Sql\AbstractSql::buildSqlString()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

createSqlFromSpecificationAndParameters()

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

inherited_from \Zend\Db\Sql\AbstractSql::createSqlFromSpecificationAndParameters()

Parameters

$specifications

stringarray

$parameters

stringarray

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

Copy variables from the subject into the local properties

localizeVariables() 
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::localizeVariables()

processAddColumns()

processAddColumns(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) 

Parameters

$adapterPlatform

processAddConstraints()

processAddConstraints(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) 

Parameters

$adapterPlatform

processChangeColumns()

processChangeColumns(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) 

Parameters

$adapterPlatform

processDropColumns()

processDropColumns(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) 

Parameters

$adapterPlatform

processDropConstraints()

processDropConstraints(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) 

Parameters

$adapterPlatform

processExpression()

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

staticvar int $runtimeExpressionPrefix
inherited_from \Zend\Db\Sql\AbstractSql::processExpression()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

processSubSelect()

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

inherited_from \Zend\Db\Sql\AbstractSql::processSubSelect()

Parameters

$subselect

\Zend\Db\Sql\Select

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

processTable()

processTable(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) 

Parameters

$adapterPlatform

resolveColumnValue()

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

inherited_from \Zend\Db\Sql\AbstractSql::resolveColumnValue()

Parameters

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

inherited_from \Zend\Db\Sql\AbstractSql::resolveTable()

Parameters

Returns

string

 Properties

 

$addColumns

$addColumns : array

 

$addConstraints

$addConstraints : array

 

$changeColumns

$changeColumns : array

 

$dropColumns

$dropColumns : array

 

$dropConstraints

$dropConstraints : array

 

$instanceParameterIndex

$instanceParameterIndex : array
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::$$instanceParameterIndex
 

$processInfo

$processInfo : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::$$processInfo
 

Specifications for Sql String generation

$specifications : array

 

$table

$table : string

 Constants

 

ADD_COLUMNS

ADD_COLUMNS 

 

ADD_CONSTRAINTS

ADD_CONSTRAINTS 

 

CHANGE_COLUMNS

CHANGE_COLUMNS 

 

DROP_COLUMNS

DROP_COLUMNS 

 

DROP_CONSTRAINTS

DROP_CONSTRAINTS 

 

TABLE

TABLE