isReadQuery() public method Returns a value indicating whether a SQL statement is for read purpose. public boolean isReadQuery ( $sql )$sql string The SQL statement return boolean Whether a SQL statement is for read purpose.

insert() public method (available since version 2.0.4) 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

getTableSchemas() public method Returns the metadata for all tables in the database. public yii\db\TableSchema[] getTableSchemas ( $schema = '', $refresh = false )$schema string The schema of the tables. Defaults to empty string, meaning the current or default schema name. $refresh boolean Whether to fetch the latest available table schemas. If this is false, cached data may be returned if available. return yii\db\TableSchema[] The metadata for all tables in the database. Each array

getTableSchema() public method Obtains the metadata for the named table. public null|yii\db\TableSchema getTableSchema ( $name, $refresh = false )$name string Table name. The table name may contain schema name if any. Do not quote the table name. $refresh boolean Whether to reload the table schema even if it is found in the cache. return null|yii\db\TableSchema Table metadata. Null if the named table does not exist.

getTableNames() public method Returns all table names in the database. public string[] getTableNames ( $schema = '', $refresh = false )$schema string The schema of the tables. Defaults to empty string, meaning the current or default schema name. If not empty, the returned table names will be prefixed with the schema name. $refresh boolean Whether to fetch the latest available table names. If this is false, table names fetched previously (if available) will be returned. return string[

getSchemaNames() public method (available since version 2.0.4) Returns all schema names in the database, except system schemas. public string[] getSchemaNames ( $refresh = false )$refresh boolean Whether to fetch the latest available schema names. If this is false, schema names fetched previously (if available) will be returned. return string[] All schema names in the database, except system schemas.

getRawTableName() public method Returns the actual name of a given table name. This method will strip off curly brackets from the given table name and replace the percentage character '%' with yii\db\Connection::$tablePrefix. public string getRawTableName ( $name )$name string The table name to be converted return string The real name of the given table name

getQueryBuilder() public method public yii\db\QueryBuilder getQueryBuilder ( )return yii\db\QueryBuilder The query builder for this connection.

getPdoType() public method Determines the PDO type for the given PHP data value. See also http://www.php.net/manual/en/pdo.constants.php. public integer getPdoType ( $data )$data mixed The data whose PDO type is to be determined return integer The PDO type

getLastInsertID() public method Returns the ID of the last inserted row or sequence value. See also http://www.php.net/manual/en/function.PDO-lastInsertId.php. public string getLastInsertID ( $sequenceName = '' )$sequenceName string Name of the sequence object (required by some DBMS) return string The row ID of the last row inserted, or the last value retrieved from the sequence object throws yii\base\InvalidCallException if the DB connection is not active