addColumn() public method Creates a SQL command for adding a new DB column. public $this addColumn ( $table, $column, $type )$table string The table that the new column will be added to. The table name will be properly quoted by the method. $column string The name of the new column. The name will be properly quoted by the method. $type string The column type. yii\db\QueryBuilder::getColumnType() will be called to convert the give column type to the physical one. For example, string w
addForeignKey() public method Creates a SQL command for adding a foreign key constraint to an existing table. The method will properly quote the table and column names. public $this addForeignKey ( $name, $table, $columns, $refTable, $refColumns, $delete = null, $update = null )$name string The name of the foreign key constraint. $table string The table that the foreign key constraint will be added to. $columns string|array The name of the column to that the constraint will be adde
$db public property The Sphinx connection that this command is associated with. public yii\sphinx\Connection $db = null
typecast() protected method (available since version 2.0.3) Converts the input value according to $phpType after retrieval from the database. If the value is null or an yii\db\Expression, it will not be converted. protected mixed typecast ( $value )$value mixed Input value return mixed Converted value
dbTypecast() public method Converts the input value according to $type and $dbType for use in a db query. If the value is null or an yii\db\Expression, it will not be converted. public mixed dbTypecast ( $value )$value mixed Input value return mixed Converted value. This may also be an array containing the value as the first element and the PDO type as the second element.
phpTypecast() public method Converts the input value according to $phpType after retrieval from the database. If the value is null or an yii\db\Expression, it will not be converted. public mixed phpTypecast ( $value )$value mixed Input value return mixed Converted value
$name public property Name of this column (without quotes). public string $name = null
$phpType public property The PHP type of this column. Possible PHP types include: string, boolean, integer, double. public string $phpType = null
$type public property Abstract type of this column. Possible abstract types include: string, text, boolean, smallint, integer, bigint, float, decimal, datetime, timestamp, time, date, binary, and money. public string $type = null
$isMva public property Whether this column is a multi value attribute (MVA) public boolean $isMva = null
Page 146 of 633