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

CDbMessageSource

system.i18n
继承 class CDbMessageSource » CMessageSource » CApplicationComponent » CComponent
实现 IApplicationComponent
可用自 1.0
源码 framework/i18n/CDbMessageSource.php
CDbMessageSource represents a message source that stores translated messages in database.

The database must contain the following two tables:
CREATE TABLE SourceMessage
(
    id INTEGER PRIMARY KEY,
    category VARCHAR(32),
    message TEXT
);
CREATE TABLE Message
(
    id INTEGER,
    language VARCHAR(16),
    translation TEXT,
    PRIMARY KEY (id, language),
    CONSTRAINT FK_Message_SourceMessage FOREIGN KEY (id)
         REFERENCES SourceMessage (id) ON DELETE CASCADE ON UPDATE RESTRICT
);
The 'SourceMessage' table stores the messages to be translated, and the 'Message' table stores the translated messages. The name of these two tables can be customized by setting sourceMessageTable and translatedMessageTable, respectively.

When cachingDuration is set as a positive number, message translations will be cached.

公共属性

隐藏继承的属性

属性类型描述被定义在
behaviors array the behaviors that should be attached to this component. CApplicationComponent
cacheID string the ID of the cache application component that is used to cache the messages. CDbMessageSource
cachingDuration integer the time in seconds that the messages can remain valid in cache. CDbMessageSource
connectionID string the ID of the database connection application component. CDbMessageSource
dbConnection CDbConnection Returns the DB connection used for the message source. CDbMessageSource
forceTranslation boolean whether to force message translation when the source and target languages are the same. CMessageSource
isInitialized boolean Checks if this application component has been initialized. CApplicationComponent
language string the language that the source messages are written in. CMessageSource
sourceMessageTable string the name of the source message table. CDbMessageSource
translatedMessageTable string the name of the translated message table. CDbMessageSource

公共方法

隐藏继承的方法

方法描述被定义在
__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
getDbConnection() Returns the DB connection used for the message source. CDbMessageSource
getEventHandlers() Returns the list of attached event handlers for an event. CComponent
getIsInitialized() Checks if this application component has been initialized. CApplicationComponent
getLanguage() Returns the language that the source messages are written in. Defaults to application language. CMessageSource
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 application component. CApplicationComponent
onMissingTranslation() Raised when a message cannot be translated. CMessageSource
raiseEvent() Raises an event. CComponent
setLanguage() Sets the language that the source messages are written in. CMessageSource
translate() Translates a message to the specified language. CMessageSource

受保护的方法

隐藏继承的方法

方法描述被定义在
loadMessages() Loads the message translation for the specified language and category. CDbMessageSource
loadMessagesFromDb() Loads the messages from database. CDbMessageSource
translateMessage() Translates the specified message. CMessageSource

事件

隐藏继承的事件

事件描述被定义在
onMissingTranslation Raised when a message cannot be translated. CMessageSource

属性详情

cacheID 属性
public string $cacheID;

the ID of the cache application component that is used to cache the messages. Defaults to 'cache' which refers to the primary cache application component. Set this property to false if you want to disable caching the messages.

cachingDuration 属性
public integer $cachingDuration;

the time in seconds that the messages can remain valid in cache. Defaults to 0, meaning the caching is disabled.

connectionID 属性
public string $connectionID;

the ID of the database connection application component. Defaults to 'db'.

dbConnection 属性 只读 (自版本 v1.1.5 可用)

Returns the DB connection used for the message source.

sourceMessageTable 属性
public string $sourceMessageTable;

the name of the source message table. Defaults to 'SourceMessage'.

translatedMessageTable 属性
public string $translatedMessageTable;

the name of the translated message table. Defaults to 'Message'.

方法详情

getDbConnection() 方法 (自版本 v1.1.5 可用)
public CDbConnection getDbConnection()
{return} CDbConnection the DB connection used for the message source.
源码: framework/i18n/CDbMessageSource.php#102 (显示)
public function getDbConnection()
{
    if(
$this->_db===null)
    {
        
$this->_db=Yii::app()->getComponent($this->connectionID);
        if(!
$this->_db instanceof CDbConnection)
            throw new 
CException(Yii::t('yii','CDbMessageSource.connectionID is invalid. Please make sure "{id}" refers to a valid database application component.',
                array(
'{id}'=>$this->connectionID)));
    }
    return 
$this->_db;
}

Returns the DB connection used for the message source.

loadMessages() 方法
protected array loadMessages(string $category, string $language)
$category string the message category
$language string the target language
{return} array the loaded messages
源码: framework/i18n/CDbMessageSource.php#77 (显示)
protected function loadMessages($category,$language)
{
    if(
$this->cachingDuration>&& $this->cacheID!==false && ($cache=Yii::app()->getComponent($this->cacheID))!==null)
    {
        
$key=self::CACHE_KEY_PREFIX.'.messages.'.$category.'.'.$language;
        if((
$data=$cache->get($key))!==false)
            return 
unserialize($data);
    }

    
$messages=$this->loadMessagesFromDb($category,$language);

    if(isset(
$cache))
        
$cache->set($key,serialize($messages),$this->cachingDuration);

    return 
$messages;
}

Loads the message translation for the specified language and category.

loadMessagesFromDb() 方法 (自版本 v1.1.5 可用)
protected array loadMessagesFromDb(string $category, string $language)
$category string the message category
$language string the target language
{return} array the messages loaded from database
源码: framework/i18n/CDbMessageSource.php#122 (显示)
protected function loadMessagesFromDb($category,$language)
{
    
$command=$this->getDbConnection()->createCommand()
        ->
select("t1.message AS message, t2.translation AS translation")
        ->
from(array("{$this->sourceMessageTable} t1","{$this->translatedMessageTable} t2"))
        ->
where('t1.id=t2.id AND t1.category=:category AND t2.language=:language',array(':category'=>$category,':language'=>$language))
    ;
    
$messages=array();
    foreach(
$command->queryAll() as $row)
        
$messages[$row['message']]=$row['translation'];

    return 
$messages;
}

Loads the messages from database. You may override this method to customize the message storage in the database.