• Главная
• Nette
• Database
• Table
• SqlBuilder

PHP Класс Nette\Database\Table\SqlBuilder

SqlBuilder is based on great library NotORM http://www.notorm.com written by Jakub Vrana. Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство	Тип	Описание
$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

Открытые методы

Метод	Описание
__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 )

Защищенные методы

Метод	Описание
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 )

Приватные методы

Метод	Описание
getCachedTableList ( )
getColumnChainsRegxp ( )
getConditionHash ( $condition, $parameters )

Описание методов

Описание свойств