system system.base system.caching system.caching.dependencies system.collections system.console system.db system.db.ar system.db.schema system.db.schema.cubrid system.db.schema.mssql system.db.schema.mysql system.db.schema.oci system.db.schema.pgsql system.db.schema.sqlite system.gii system.i18n system.i18n.gettext system.logging system.test system.utils system.validators system.web system.web.actions system.web.auth system.web.filters system.web.form system.web.helpers system.web.renderers system.web.services system.web.widgets system.web.widgets.captcha system.web.widgets.pagers zii.behaviors zii.widgets zii.widgets.grid zii.widgets.jui

CMysqlColumnSchema

system.db.schema.mysql
继承 class CMysqlColumnSchema » CDbColumnSchema » CComponent
可用自 1.0
源码 framework/db/schema/mysql/CMysqlColumnSchema.php
CMysqlColumnSchema class describes the column meta data of a MySQL table.

公共属性

隐藏继承的属性

属性类型描述被定义在
allowNull boolean whether this column can be null. CDbColumnSchema
autoIncrement boolean whether this column is auto-incremental CDbColumnSchema
comment string comment of this column. CDbColumnSchema
dbType string the DB type of this column. CDbColumnSchema
defaultValue mixed default value of this column CDbColumnSchema
isForeignKey boolean whether this column is a foreign key CDbColumnSchema
isPrimaryKey boolean whether this column is a primary key CDbColumnSchema
name string name of this column (without quotes). CDbColumnSchema
precision integer precision of the column data, if it is numeric. CDbColumnSchema
rawName string raw name of this column. CDbColumnSchema
scale integer scale of the column data, if it is numeric. CDbColumnSchema
size integer size of the column. CDbColumnSchema
type string the PHP type of this column. CDbColumnSchema

公共方法

隐藏继承的方法

方法描述被定义在
__call() Calls the named method which is not a class method. CComponent
__get() Returns a property value, an event handler list or a behavior based on its name. CComponent
__isset() Checks if a property value is null. CComponent
__set() Sets value of a component property. CComponent
__unset() Sets a component property to be null. CComponent
asa() Returns the named behavior object. CComponent
attachBehavior() Attaches a behavior to this component. CComponent
attachBehaviors() Attaches a list of behaviors to the component. CComponent
attachEventHandler() Attaches an event handler to an event. CComponent
canGetProperty() Determines whether a property can be read. CComponent
canSetProperty() Determines whether a property can be set. CComponent
detachBehavior() Detaches a behavior from the component. CComponent
detachBehaviors() Detaches all behaviors from the component. CComponent
detachEventHandler() Detaches an existing event handler. CComponent
disableBehavior() Disables an attached behavior. CComponent
disableBehaviors() Disables all behaviors attached to this component. CComponent
enableBehavior() Enables an attached behavior. CComponent
enableBehaviors() Enables all behaviors attached to this component. CComponent
evaluateExpression() Evaluates a PHP expression or callback under the context of this component. CComponent
getEventHandlers() Returns the list of attached event handlers for an event. CComponent
hasEvent() Determines whether an event is defined. CComponent
hasEventHandler() Checks whether the named event has attached handlers. CComponent
hasProperty() Determines whether a property is defined. CComponent
init() Initializes the column with its DB type and default value. CDbColumnSchema
raiseEvent() Raises an event. CComponent
typecast() Converts the input value to the type that this column is of. CDbColumnSchema

受保护的方法

隐藏继承的方法

方法描述被定义在
extractDefault() Extracts the default value for the column. CMysqlColumnSchema
extractLimit() Extracts size, precision and scale information from column's DB type. CMysqlColumnSchema
extractType() Extracts the PHP type from DB type. CMysqlColumnSchema

方法详情

extractDefault() 方法
protected void extractDefault(mixed $defaultValue)
$defaultValue mixed the default value obtained from metadata
源码: framework/db/schema/mysql/CMysqlColumnSchema.php#43 (显示)
protected function extractDefault($defaultValue)
{
    if(
strncmp($this->dbType,'bit',3)===0)
        
$this->defaultValue=bindec(trim($defaultValue,'b\''));
    elseif((
$this->dbType==='timestamp' || $this->dbType==='datetime')  && ($defaultValue==='CURRENT_TIMESTAMP' || $defaultValue==='current_timestamp()'))
        
$this->defaultValue=null;
    else
        
parent::extractDefault($defaultValue);
}

Extracts the default value for the column. The value is typecasted to correct PHP type.

extractLimit() 方法
protected void extractLimit(string $dbType)
$dbType string the column's DB type
源码: framework/db/schema/mysql/CMysqlColumnSchema.php#57 (显示)
protected function extractLimit($dbType)
{
    if (
strncmp($dbType'enum'4)===&& preg_match('/\(([\'"])(.*)\\1\)/',$dbType,$matches))
    {
        
// explode by (single or double) quote and comma (ENUM values may contain commas)
        
$values explode($matches[1].','.$matches[1], $matches[2]);
        
$size 0;
        foreach(
$values as $value)
        {
            if((
$n=strlen($value)) > $size)
                
$size=$n;
        }
        
$this->size $this->precision $size;
    }
    else
        
parent::extractLimit($dbType);
}

Extracts size, precision and scale information from column's DB type.

extractType() 方法
protected void extractType(string $dbType)
$dbType string DB type
源码: framework/db/schema/mysql/CMysqlColumnSchema.php#24 (显示)
protected function extractType($dbType)
{
    if(
strncmp($dbType,'enum',4)===0)
        
$this->type='string';
    elseif(
strpos($dbType,'float')!==false || strpos($dbType,'double')!==false)
        
$this->type='double';
    elseif(
strpos($dbType,'bool')!==false)
        
$this->type='boolean';
    elseif(
strpos($dbType,'int')===&& strpos($dbType,'unsigned')===false || preg_match('/(bit|tinyint|smallint|mediumint)/',$dbType))
        
$this->type='integer';
    else
        
$this->type='string';
}

Extracts the PHP type from DB type.