• 홈
• yii
• db
• QueryBuilder

PHP 클래스 yii\db\QueryBuilder

SQL statements are created from Query objects using the QueryBuilder::build-method. QueryBuilder is also used by Command to build SQL statements such as INSERT, UPDATE, DELETE, CREATE TABLE. For more details and usage information on QueryBuilder, see the guide article on query builders. 파일 보기 프로젝트 열기: yiisoft/yii2 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
$db		the database connection.
$separator		the separator between different fragments of a SQL statement. Defaults to an empty space. This is mainly used by QueryBuilder::build when generating a SQL statement.
$typeMap		the abstract column types mapped to physical column types. This is mainly used to support creating/modifying tables using DB-independent data type specifications. Child classes should override this property to declare supported type mappings.

보호된 프로퍼티들

프로퍼티	타입	설명
$conditionBuilders		map of query condition to builder methods. These methods are used by [[buildCondition]] to build SQL conditions from array syntax.

공개 메소드들

메소드	설명
__construct ( Connection $connection, array $config = [] )	Constructor.
addColumn ( string $table, string $column, string $type ) : string	Builds a SQL statement for adding a new DB column.
addCommentOnColumn ( string $table, string $column, string $comment ) : string	Builds a SQL command for adding comment to column
addCommentOnTable ( string $table, string $comment ) : string	Builds a SQL command for adding comment to table
addForeignKey ( string $name, string $table, string | array $columns, string $refTable, string | array $refColumns, string $delete = null, string $update = null ) : string	Builds a SQL statement for adding a foreign key constraint to an existing table.
addPrimaryKey ( string $name, string $table, string | array $columns ) : string	Builds a SQL statement for adding a primary key constraint to an existing table.
alterColumn ( string $table, string $column, string $type ) : string	Builds a SQL statement for changing the definition of a column.
batchInsert ( string $table, array $columns, array $rows ) : string	Generates a batch INSERT SQL statement.
build ( Query $query, array $params = [] ) : array	Generates a SELECT SQL statement from a Query object.
buildAndCondition ( string $operator, array $operands, array &$params ) : string	Connects two or more SQL expressions with the AND or OR operator.
buildBetweenCondition ( string $operator, array $operands, array &$params ) : string	Creates an SQL expressions with the BETWEEN operator.
buildColumns ( string | array $columns ) : string	Processes columns and properly quotes them if necessary.
buildCondition ( string | array | yii\db\Expression $condition, array &$params ) : string	Parses the condition specification and generates the corresponding SQL expression.
buildExistsCondition ( string $operator, array $operands, array &$params ) : string	Creates an SQL expressions with the EXISTS operator.
buildFrom ( array $tables, array &$params ) : string
buildGroupBy ( array $columns ) : string
buildHashCondition ( array $condition, array &$params ) : string	Creates a condition based on column-value pairs.
buildHaving ( string | array $condition, array &$params ) : string
buildInCondition ( string $operator, array $operands, array &$params ) : string	Creates an SQL expressions with the IN operator.
buildJoin ( array $joins, array &$params ) : string
buildLikeCondition ( string $operator, array $operands, array &$params ) : string	Creates an SQL expressions with the LIKE operator.
buildLimit ( integer $limit, integer $offset ) : string
buildNotCondition ( string $operator, array $operands, array &$params ) : string	Inverts an SQL expressions with NOT operator.
buildOrderBy ( array $columns ) : string
buildOrderByAndLimit ( string $sql, array $orderBy, integer $limit, integer $offset ) : string	Builds the ORDER BY and LIMIT/OFFSET clauses and appends them to the given SQL.
buildSelect ( array $columns, array &$params, boolean $distinct = false, string $selectOption = null ) : string
buildSimpleCondition ( string $operator, array $operands, array &$params ) : string	Creates an SQL expressions like "column" operator value.
buildUnion ( array $unions, array &$params ) : string
buildWhere ( string | array $condition, array &$params ) : string
checkIntegrity ( boolean $check = true, string $schema = '', string $table = '' ) : string	Builds a SQL statement for enabling or disabling integrity check.
createIndex ( string $name, string $table, string | array $columns, boolean $unique = false ) : string	Builds a SQL statement for creating a new index.
createTable ( string $table, array $columns, string $options = null ) : string	Builds a SQL statement for creating a new DB table.
delete ( string $table, array | string $condition, array &$params ) : string	Creates a DELETE SQL statement.
dropColumn ( string $table, string $column ) : string	Builds a SQL statement for dropping a DB column.
dropCommentFromColumn ( string $table, string $column ) : string	Builds a SQL command for adding comment to column
dropCommentFromTable ( string $table ) : string	Builds a SQL command for adding comment to table
dropForeignKey ( string $name, string $table ) : string	Builds a SQL statement for dropping a foreign key constraint.
dropIndex ( string $name, string $table ) : string	Builds a SQL statement for dropping an index.
dropPrimaryKey ( string $name, string $table ) : string	Builds a SQL statement for removing a primary key constraint to an existing table.
dropTable ( string $table ) : string	Builds a SQL statement for dropping a DB table.
getColumnType ( string | ColumnSchemaBuilder $type ) : string	Converts an abstract column type into a physical column type.
insert ( string $table, array $columns, array &$params ) : string	Creates an INSERT SQL statement.
renameColumn ( string $table, string $oldName, string $newName ) : string	Builds a SQL statement for renaming a column.
renameTable ( string $oldName, string $newName ) : string	Builds a SQL statement for renaming a DB table.
resetSequence ( string $table, array | string $value = null ) : string	Creates a SQL statement for resetting the sequence value of a table's primary key.
selectExists ( string $rawSql ) : string	Creates a SELECT EXISTS() SQL statement.
truncateTable ( string $table ) : string	Builds a SQL statement for truncating a DB table.
update ( string $table, array $columns, array | string $condition, array &$params ) : string	Creates an UPDATE SQL statement.

보호된 메소드들

메소드	설명
buildCompositeInCondition ( string $operator, array | Traversable $columns, array $values, array &$params ) : string	Builds SQL for IN condition
buildSubqueryInCondition ( string $operator, array $columns, Query $values, array &$params ) : string	Builds SQL for IN condition
hasLimit ( mixed $limit ) : boolean	Checks to see if the given limit is effective.
hasOffset ( mixed $offset ) : boolean	Checks to see if the given offset is effective.

비공개 메소드들

메소드	설명
quoteTableNames ( array $tables, array &$params ) : array	Quotes table names passed

메소드 상세

프로퍼티 상세