Class yii\db\cubrid\QueryBuilder
| Inheritance | yii\db\cubrid\QueryBuilder » yii\db\QueryBuilder » yii\base\Object |
|---|---|
| Implements | yii\base\Configurable |
| Available since version | 2.0 |
| Source Code | https://github.com/yiisoft/yii2/blob/master/framework/db/cubrid/QueryBuilder.php |
QueryBuilder is the query builder for CUBRID databases (version 9.3.x and higher).
Public Properties
| Property | Type | Description | Defined By |
|---|---|---|---|
| $db | yii\db\Connection | The database connection. | yii\db\QueryBuilder |
| $separator | string | The separator between different fragments of a SQL statement. | yii\db\QueryBuilder |
| $typeMap | array | Mapping from abstract column types (keys) to physical column types (values). | yii\db\cubrid\QueryBuilder |
Protected Properties
| Property | Type | Description | Defined By |
|---|---|---|---|
| $conditionBuilders | array | Map of query condition to builder methods. | yii\db\QueryBuilder |
| $likeEscapeCharacter | string|null | Character used to escape special characters in LIKE conditions. | yii\db\cubrid\QueryBuilder |
| $likeEscapingReplacements | array | Map of chars to their replacements in LIKE conditions. | yii\db\cubrid\QueryBuilder |
Public Methods
| Method | Description | Defined By |
|---|---|---|
| __call() | Calls the named method which is not a class method. | yii\base\Object |
| __construct() | Constructor. | yii\db\QueryBuilder |
| __get() | Returns the value of an object property. | yii\base\Object |
| __isset() | Checks if a property is set, i.e. defined and not null. | yii\base\Object |
| __set() | Sets value of an object property. | yii\base\Object |
| __unset() | Sets an object property to null. | yii\base\Object |
| addColumn() | Builds a SQL statement for adding a new DB column. | yii\db\QueryBuilder |
| addCommentOnColumn() | Builds a SQL command for adding comment to column | yii\db\cubrid\QueryBuilder |
| addCommentOnTable() | Builds a SQL command for adding comment to table | yii\db\cubrid\QueryBuilder |
| addForeignKey() | Builds a SQL statement for adding a foreign key constraint to an existing table. | yii\db\QueryBuilder |
| addPrimaryKey() | Builds a SQL statement for adding a primary key constraint to an existing table. | yii\db\QueryBuilder |
| alterColumn() | Builds a SQL statement for changing the definition of a column. | yii\db\QueryBuilder |
| batchInsert() | Generates a batch INSERT SQL statement. | yii\db\QueryBuilder |
| build() | Generates a SELECT SQL statement from a yii\db\Query object. | yii\db\QueryBuilder |
| buildAndCondition() | Connects two or more SQL expressions with the AND or OR operator. | yii\db\QueryBuilder |
| buildBetweenCondition() | Creates an SQL expressions with the BETWEEN operator. | yii\db\QueryBuilder |
| buildColumns() | Processes columns and properly quotes them if necessary. | yii\db\QueryBuilder |
| buildCondition() | Parses the condition specification and generates the corresponding SQL expression. | yii\db\QueryBuilder |
| buildExistsCondition() | Creates an SQL expressions with the EXISTS operator. | yii\db\QueryBuilder |
| buildFrom() | yii\db\QueryBuilder | |
| buildGroupBy() | yii\db\QueryBuilder | |
| buildHashCondition() | Creates a condition based on column-value pairs. | yii\db\QueryBuilder |
| buildHaving() | yii\db\QueryBuilder | |
| buildInCondition() | Creates an SQL expressions with the IN operator. | yii\db\QueryBuilder |
| buildJoin() | yii\db\QueryBuilder | |
| buildLikeCondition() | Creates an SQL expressions with the LIKE operator. | yii\db\QueryBuilder |
| buildLimit() | yii\db\cubrid\QueryBuilder | |
| buildNotCondition() | Inverts an SQL expressions with NOT operator. | yii\db\QueryBuilder |
| buildOrderBy() | yii\db\QueryBuilder | |
| buildOrderByAndLimit() | Builds the ORDER BY and LIMIT/OFFSET clauses and appends them to the given SQL. | yii\db\QueryBuilder |
| buildSelect() | yii\db\QueryBuilder | |
| buildSimpleCondition() | Creates an SQL expressions like "column" operator value. | yii\db\QueryBuilder |
| buildUnion() | yii\db\QueryBuilder | |
| buildWhere() | yii\db\QueryBuilder | |
| canGetProperty() | Returns a value indicating whether a property can be read. | yii\base\Object |
| canSetProperty() | Returns a value indicating whether a property can be set. | yii\base\Object |
| checkIntegrity() | Builds a SQL statement for enabling or disabling integrity check. | yii\db\QueryBuilder |
| className() | Returns the fully qualified name of this class. | yii\base\Object |
| createIndex() | Builds a SQL statement for creating a new index. | yii\db\QueryBuilder |
| createTable() | Builds a SQL statement for creating a new DB table. | yii\db\QueryBuilder |
| delete() | Creates a DELETE SQL statement. | yii\db\QueryBuilder |
| dropColumn() | Builds a SQL statement for dropping a DB column. | yii\db\QueryBuilder |
| dropCommentFromColumn() | Builds a SQL command for adding comment to column | yii\db\cubrid\QueryBuilder |
| dropCommentFromTable() | Builds a SQL command for adding comment to table | yii\db\cubrid\QueryBuilder |
| dropForeignKey() | Builds a SQL statement for dropping a foreign key constraint. | yii\db\QueryBuilder |
| dropIndex() | Builds a SQL statement for dropping an index. | yii\db\QueryBuilder |
| dropPrimaryKey() | Builds a SQL statement for removing a primary key constraint to an existing table. | yii\db\QueryBuilder |
| dropTable() | Builds a SQL statement for dropping a DB table. | yii\db\QueryBuilder |
| getColumnType() | Converts an abstract column type into a physical column type. | yii\db\QueryBuilder |
| hasMethod() | Returns a value indicating whether a method is defined. | yii\base\Object |
| hasProperty() | Returns a value indicating whether a property is defined. | yii\base\Object |
| init() | Initializes the object. | yii\base\Object |
| insert() | Creates an INSERT SQL statement. | yii\db\QueryBuilder |
| renameColumn() | Builds a SQL statement for renaming a column. | yii\db\QueryBuilder |
| renameTable() | Builds a SQL statement for renaming a DB table. | yii\db\QueryBuilder |
| resetSequence() | Creates a SQL statement for resetting the sequence value of a table's primary key. | yii\db\cubrid\QueryBuilder |
| selectExists() | Creates a SELECT EXISTS() SQL statement. | yii\db\cubrid\QueryBuilder |
| truncateTable() | Builds a SQL statement for truncating a DB table. | yii\db\QueryBuilder |
| update() | Creates an UPDATE SQL statement. | yii\db\QueryBuilder |
Protected Methods
| Method | Description | Defined By |
|---|---|---|
| buildCompositeInCondition() | Builds SQL for IN condition | yii\db\QueryBuilder |
| buildSubqueryInCondition() | Builds SQL for IN condition | yii\db\QueryBuilder |
| hasLimit() | Checks to see if the given limit is effective. | yii\db\QueryBuilder |
| hasOffset() | Checks to see if the given offset is effective. | yii\db\QueryBuilder |
| prepareInsertSelectSubQuery() | Prepare select-subquery and field names for INSERT INTO . | yii\db\QueryBuilder |
Constants
| Constant | Value | Description | Defined By |
|---|---|---|---|
| PARAM_PREFIX | ':qp' | The prefix for automatically generated query binding parameters. | yii\db\QueryBuilder |
Property Details
$likeEscapeCharacter protected property
Character used to escape special characters in LIKE conditions. By default it's assumed to be \.
protected string|null $likeEscapeCharacter = '!'
$likeEscapingReplacements protected property
Map of chars to their replacements in LIKE conditions. By default it's configured to escape %, _ and \ with \.
protected array $likeEscapingReplacements = ['%' => '!%', '_' => '!_', '!' => '!!']
$typeMap public property
Mapping from abstract column types (keys) to physical column types (values).
public array $typeMap = [\yii\db\cubrid\Schema::TYPE_PK => 'int NOT NULL AUTO_INCREMENT PRIMARY KEY', \yii\db\cubrid\Schema::TYPE_UPK => 'int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY', \yii\db\cubrid\Schema::TYPE_BIGPK => 'bigint NOT NULL AUTO_INCREMENT PRIMARY KEY', \yii\db\cubrid\Schema::TYPE_UBIGPK => 'bigint UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY', \yii\db\cubrid\Schema::TYPE_CHAR => 'char(1)', \yii\db\cubrid\Schema::TYPE_STRING => 'varchar(255)', \yii\db\cubrid\Schema::TYPE_TEXT => 'varchar', \yii\db\cubrid\Schema::TYPE_SMALLINT => 'smallint', \yii\db\cubrid\Schema::TYPE_INTEGER => 'int', \yii\db\cubrid\Schema::TYPE_BIGINT => 'bigint', \yii\db\cubrid\Schema::TYPE_FLOAT => 'float(7)', \yii\db\cubrid\Schema::TYPE_DOUBLE => 'double(15)', \yii\db\cubrid\Schema::TYPE_DECIMAL => 'decimal(10,0)', \yii\db\cubrid\Schema::TYPE_DATETIME => 'datetime', \yii\db\cubrid\Schema::TYPE_TIMESTAMP => 'timestamp', \yii\db\cubrid\Schema::TYPE_TIME => 'time', \yii\db\cubrid\Schema::TYPE_DATE => 'date', \yii\db\cubrid\Schema::TYPE_BINARY => 'blob', \yii\db\cubrid\Schema::TYPE_BOOLEAN => 'smallint', \yii\db\cubrid\Schema::TYPE_MONEY => 'decimal(19,4)']
Method Details
addCommentOnColumn() public method (available since version 2.0.8)
Builds a SQL command for adding comment to column
| public string addCommentOnColumn ( $table, $column, $comment ) | ||
|---|---|---|
| $table | string |
The table whose column is to be commented. The table name will be properly quoted by the method. |
| $column | string |
The name of the column to be commented. The column name will be properly quoted by the method. |
| $comment | string |
The text of the comment to be added. The comment will be properly quoted by the method. |
| return | string |
The SQL statement for adding comment on column |
addCommentOnTable() public method (available since version 2.0.8)
Builds a SQL command for adding comment to table
| public string addCommentOnTable ( $table, $comment ) | ||
|---|---|---|
| $table | string |
The table whose column is to be commented. The table name will be properly quoted by the method. |
| $comment | string |
The text of the comment to be added. The comment will be properly quoted by the method. |
| return | string |
The SQL statement for adding comment on table |
buildLimit() public method
| public string buildLimit ( $limit, $offset ) | ||
|---|---|---|
| $limit | integer | |
| $offset | integer | |
| return | string |
The LIMIT and OFFSET clauses |
dropCommentFromColumn() public method (available since version 2.0.8)
Builds a SQL command for adding comment to column
| public string dropCommentFromColumn ( $table, $column ) | ||
|---|---|---|
| $table | string |
The table whose column is to be commented. The table name will be properly quoted by the method. |
| $column | string |
The name of the column to be commented. The column name will be properly quoted by the method. |
| return | string |
The SQL statement for adding comment on column |
dropCommentFromTable() public method (available since version 2.0.8)
Builds a SQL command for adding comment to table
| public string dropCommentFromTable ( $table ) | ||
|---|---|---|
| $table | string |
The table whose column is to be commented. The table name will be properly quoted by the method. |
| return | string |
The SQL statement for adding comment on column |
resetSequence() public method
Creates a SQL statement for resetting the sequence value of a table's primary key.
The sequence will be reset such that the primary key of the next new row inserted will have the specified value or 1.
| public string resetSequence ( $tableName, $value = null ) | ||
|---|---|---|
| $tableName | string |
The name of the table whose primary key sequence will be reset |
| $value | mixed |
The value for the primary key of the next new row inserted. If this is not set, the next new row's primary key will have a value 1. |
| return | string |
The SQL statement for resetting sequence |
| throws | yii\base\InvalidParamException |
if the table does not exist or there is no sequence associated with the table. |
selectExists() public method (available since version 2.0.8)
Creates a SELECT EXISTS() SQL statement.
| public string selectExists ( $rawSql ) | ||
|---|---|---|
| $rawSql | string |
The subquery in a raw form to select from. |
| return | string |
The SELECT EXISTS() SQL statement. |
© 2008–2017 by Yii Software LLC
Licensed under the three clause BSD license.
http://www.yiiframework.com/doc-2.0/yii-db-cubrid-querybuilder.html