Package | system.i18n |
---|---|
Inheritance | class CDbMessageSource » CMessageSource » CApplicationComponent » CComponent |
Implements | IApplicationComponent |
Since | 1.0 |
Source Code | framework/i18n/CDbMessageSource.php |
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.
Property | Type | Description | Defined By |
---|---|---|---|
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 |
Method | Description | Defined By |
---|---|---|
__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 |
Method | Description | Defined By |
---|---|---|
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 |
Event | Description | Defined By |
---|---|---|
onMissingTranslation | Raised when a message cannot be translated. | CMessageSource |
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.
public integer $cachingDuration;
the time in seconds that the messages can remain valid in cache. Defaults to 0, meaning the caching is disabled.
public string $connectionID;
the ID of the database connection application component. Defaults to 'db'.
public CDbConnection getDbConnection()
Returns the DB connection used for the message source.
public string $sourceMessageTable;
the name of the source message table. Defaults to 'SourceMessage'.
public string $translatedMessageTable;
the name of the translated message table. Defaults to 'Message'.
public CDbConnection getDbConnection() | ||
{return} | CDbConnection | the DB connection used for the message source. |
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.
protected array loadMessages(string $category, string $language) | ||
$category | string | the message category |
$language | string | the target language |
{return} | array | the loaded messages |
protected function loadMessages($category,$language)
{
if($this->cachingDuration>0 && $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.
protected array loadMessagesFromDb(string $category, string $language) | ||
$category | string | the message category |
$language | string | the target language |
{return} | array | the messages loaded from database |
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.
© 2008–2017 by Yii Software LLC
Licensed under the three clause BSD license.
http://www.yiiframework.com/doc/api/1.1/CDbMessageSource