• 홈
• Nette
• Database
• Table
• SqlBuilder

PHP 클래스 Nette\Database\Table\SqlBuilder

SqlBuilder is based on great library NotORM http://www.notorm.com written by Jakub Vrana. 파일 보기 프로젝트 열기: nette/database 1 사용 예제들

보호된 프로퍼티들

프로퍼티	타입	설명
$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 )

메소드 상세

프로퍼티 상세