checkIntegrity() public method Builds a SQL statement for enabling or disabling integrity check. public string checkIntegrity ( $check = true, $schema = '', $table = '' )$check boolean Whether to turn on or off the integrity check. $schema string The schema of the tables. $table string The table name. return string The SQL statement for checking integrity

batchInsert() public method Generates a batch INSERT SQL statement. For example, $sql = $queryBuilder->batchInsert('user', ['name', 'age'], [ ['Tom', 30], ['Jane', 20], ['Linda', 25], ]); Note that the values in each row must match the corresponding column names. The method will properly escape the column names, and quote the values to be inserted. public string batchInsert ( $table, $columns, $rows )$table string The table that new rows will be inserted into. $columns a

alterColumn() public method Builds a SQL statement for changing the definition of a column. public string alterColumn ( $table, $column, $type )$table string The table whose column is to be changed. The table name will be properly quoted by the method. $column string The name of the column to be changed. The name will be properly quoted by the method. $type string The new column type. The getColumnType() method will be invoked to convert abstract column type (if any) into the physica

$typeMap public property Mapping from abstract column types (keys) to physical column types (values). public array $typeMap = [\yii\db\pgsql\Schema::TYPE_PK => 'serial NOT NULL PRIMARY KEY', \yii\db\pgsql\Schema::TYPE_UPK => 'serial NOT NULL PRIMARY KEY', \yii\db\pgsql\Schema::TYPE_BIGPK => 'bigserial NOT NULL PRIMARY KEY', \yii\db\pgsql\Schema::TYPE_UBIGPK => 'bigserial NOT NULL PRIMARY KEY', \yii\db\pgsql\Schema::TYPE_CHAR => 'char(1)', \yii\db\pgsql\Schema::TYPE_STRING =&

$conditionBuilders protected property Map of query condition to builder methods. These methods are used by buildCondition() to build SQL conditions from array syntax. protected array $conditionBuilders = ['NOT' => 'buildNotCondition', 'AND' => 'buildAndCondition', 'OR' => 'buildAndCondition', 'BETWEEN' => 'buildBetweenCondition', 'NOT BETWEEN' => 'buildBetweenCondition', 'IN' => 'buildInCondition', 'NOT IN' => 'buildInCondition', 'LIKE' => 'buildLikeCondition', 'ILI

resolveTableNames() protected method Resolves the table name and schema name (if any). protected void resolveTableNames ( $table, $name )$table yii\db\TableSchema The table metadata object $name string The table name

releaseSavepoint() public method Releases an existing savepoint. public void releaseSavepoint ( $name )$name string The savepoint name

quoteSimpleTableName() public method Quotes a simple table name for use in a query. A simple table name should contain the table name only without any schema prefix. If the table name is already quoted, this method will do nothing. public string quoteSimpleTableName ( $name )$name string Table name return string The properly quoted table name

loadTableSchema() public method Loads the metadata for the specified table. public null|yii\db\TableSchema loadTableSchema ( $name )$name string Table name return null|yii\db\TableSchema DBMS-dependent table metadata, null if the table does not exist.

insert() public method Executes the INSERT command, returning primary key values. public array|false insert ( $table, $columns )$table string The table that new rows will be inserted into. $columns array The column data (name => value) to be inserted into the table. return array|false Primary key values or false if the command fails