PHP Class Nette\Database\Table\SqlBuilder

SqlBuilder is based on great library NotORM http://www.notorm.com written by Jakub Vrana.
Author: Jakub Vrana
Author: Jan Skrasek
Inheritance: extends Nette\Object
Afficher le fichier Open project: nette/database Class Usage Examples

Protected Properties

Свойство Type Description
$aliases of table aliases
$conditions of where conditions for caching
$conventions Nette\Database\IConventions
$currentAlias currently parsing alias for joins
$delimitedTable delimited table name
$group columns to grouping
$having grouping condition
$joinCondition of array of join conditions
$limit number of rows to fetch
$offset first row to fetch
$order or columns to order by
$parameters of parameters passed to where conditions
$reservedTableNames of reserved table names associated with chain
$select of column to select
$tableName string
$where of where conditions

Méthodes publiques

Méthode Description
__construct ( $tableName, Context $context )
addAlias ( $chain, $alias ) : void Adds alias.
addJoinCondition ( $tableChain, $condition, $params )
addOrder ( $columns, $params )
addSelect ( $columns, $params ) ******************* SQL selectors ****************d*g*
addWhere ( $condition, $params )
buildDeleteQuery ( )
buildInsertQuery ( )
buildSelectQuery ( $columns = NULL ) : string Returns SQL query.
buildUpdateQuery ( )
getConditions ( )
getGroup ( )
getHaving ( )
getLimit ( )
getOffset ( )
getOrder ( )
getParameters ( )
getSelect ( )
getSelectQueryHash ( $columns = NULL ) : string Returns select query hash for caching.
getTableName ( ) : string
importConditions ( SqlBuilder $builder )
parseJoinsCb ( &$joins, $match )
setGroup ( $columns, $params )
setHaving ( $having, $params )
setLimit ( $limit, $offset )
setOrder ( array $columns, array $parameters )

Méthodes protégées

Méthode Description
addCondition ( $condition, array $params, array &$conditions, array &$conditionsParameters )
addConditionComposition ( array $columns, array $parameters, array &$conditions, array &$conditionsParameters )
buildConditions ( )
buildJoinConditions ( )
buildQueryEnd ( )
buildQueryJoins ( array $joins, array $leftJoinConditions = [] )
buildSelect ( array $columns ) ******************* SQL building ****************d*g*
checkUniqueTableName ( $tableName, $chain )
getSortedJoins ( $table, &$leftJoinDependency, &$tableJoins, &$finalJoins )
parseJoinConditions ( &$joins, $joinConditions )
parseJoins ( &$joins, &$query )
tryDelimite ( $s )

Private Methods

Méthode Description
getCachedTableList ( )
getColumnChainsRegxp ( )
getConditionHash ( $condition, $parameters )

Method Details

__construct() public méthode

public __construct ( $tableName, Context $context )
$context Nette\Database\Context

addAlias() public méthode

Adds alias.
public addAlias ( $chain, $alias ) : void
Résultat void

addCondition() protected méthode

protected addCondition ( $condition, array $params, array &$conditions, array &$conditionsParameters )
$params array
$conditions array
$conditionsParameters array

addConditionComposition() protected méthode

protected addConditionComposition ( array $columns, array $parameters, array &$conditions, array &$conditionsParameters )
$columns array
$parameters array
$conditions array
$conditionsParameters array

addJoinCondition() public méthode

public addJoinCondition ( $tableChain, $condition, $params )

addOrder() public méthode

public addOrder ( $columns, $params )

addSelect() public méthode

******************* SQL selectors ****************d*g*
public addSelect ( $columns, $params )

addWhere() public méthode

public addWhere ( $condition, $params )

buildConditions() protected méthode

protected buildConditions ( )

buildDeleteQuery() public méthode

public buildDeleteQuery ( )

buildInsertQuery() public méthode

public buildInsertQuery ( )

buildJoinConditions() protected méthode

protected buildJoinConditions ( )

buildQueryEnd() protected méthode

protected buildQueryEnd ( )

buildQueryJoins() protected méthode

protected buildQueryJoins ( array $joins, array $leftJoinConditions = [] )
$joins array
$leftJoinConditions array

buildSelect() protected méthode

******************* SQL building ****************d*g*
protected buildSelect ( array $columns )
$columns array

buildSelectQuery() public méthode

Returns SQL query.
public buildSelectQuery ( $columns = NULL ) : string
Résultat string

buildUpdateQuery() public méthode

public buildUpdateQuery ( )

checkUniqueTableName() protected méthode

protected checkUniqueTableName ( $tableName, $chain )

getConditions() public méthode

public getConditions ( )

getGroup() public méthode

public getGroup ( )

getHaving() public méthode

public getHaving ( )

getLimit() public méthode

public getLimit ( )

getOffset() public méthode

public getOffset ( )

getOrder() public méthode

public getOrder ( )

getParameters() public méthode

public getParameters ( )

getSelect() public méthode

public getSelect ( )

getSelectQueryHash() public méthode

Returns select query hash for caching.
public getSelectQueryHash ( $columns = NULL ) : string
Résultat string

getSortedJoins() protected méthode

protected getSortedJoins ( $table, &$leftJoinDependency, &$tableJoins, &$finalJoins )

getTableName() public méthode

public getTableName ( ) : string
Résultat string

importConditions() public méthode

public importConditions ( SqlBuilder $builder )
$builder SqlBuilder

parseJoinConditions() protected méthode

protected parseJoinConditions ( &$joins, $joinConditions )

parseJoins() protected méthode

protected parseJoins ( &$joins, &$query )

parseJoinsCb() public méthode

public parseJoinsCb ( &$joins, $match )

setGroup() public méthode

public setGroup ( $columns, $params )

setHaving() public méthode

public setHaving ( $having, $params )

setLimit() public méthode

public setLimit ( $limit, $offset )

setOrder() public méthode

public setOrder ( array $columns, array $parameters )
$columns array
$parameters array

tryDelimite() protected méthode

protected tryDelimite ( $s )

Property Details

$aliases protected_oe property

of table aliases
protected $aliases

$conditions protected_oe property

of where conditions for caching
protected $conditions

$conventions protected_oe property

protected IConventions,Nette\Database $conventions
Résultat Nette\Database\IConventions

$currentAlias protected_oe property

currently parsing alias for joins
protected $currentAlias

$delimitedTable protected_oe property

delimited table name
protected $delimitedTable

$group protected_oe property

columns to grouping
protected $group

$having protected_oe property

grouping condition
protected $having

$joinCondition protected_oe property

of array of join conditions
protected $joinCondition

$limit protected_oe property

number of rows to fetch
protected $limit

$offset protected_oe property

first row to fetch
protected $offset

$order protected_oe property

or columns to order by
protected $order

$parameters protected_oe property

of parameters passed to where conditions
protected $parameters

$reservedTableNames protected_oe property

of reserved table names associated with chain
protected $reservedTableNames

$select protected_oe property

of column to select
protected $select

$tableName protected_oe property

protected string $tableName
Résultat string

$where protected_oe property

of where conditions
protected $where