Home » Documentation » Class Reference » CDbMessageSource

CDbMessageSource

All Packages | Properties | Methods | Events

Package	system.i18n
Inheritance	class CDbMessageSource » CMessageSource » CApplicationComponent » CComponent
Implements	IApplicationComponent
Since	1.0
Version	$Id: CDbMessageSource.php 1678 2010-01-07 21:02:00Z qiang.xue $

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.

Public Properties

Hide inherited properties

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
isInitialized	boolean	whether this application component has been initialized (i.	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

Public Methods

Hide inherited methods

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
getEventHandlers()	Returns the list of attached event handlers for an event.	CComponent
getIsInitialized()		CApplicationComponent
getLanguage()		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.	CDbMessageSource
onMissingTranslation()	Raised when a message cannot be translated.	CMessageSource
raiseEvent()	Raises an event.	CComponent
setLanguage()		CMessageSource
translate()	Translates a message to the specified language.	CMessageSource

Protected Methods

Hide inherited methods

Method	Description	Defined By
loadMessages()	Loads the message translation for the specified language and category.	CDbMessageSource
translateMessage()	Translates the specified message.	CMessageSource

Events

Hide inherited events

Event	Description	Defined By
onMissingTranslation	Raised when a message cannot be translated.	CMessageSource

Property Details

cacheID property (available since v1.0.10)

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 property

public integer $cachingDuration;

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

connectionID property

public string $connectionID;

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

sourceMessageTable property

public string $sourceMessageTable;

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

translatedMessageTable property

public string $translatedMessageTable;

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

Method Details

init() method

public void init()

Initializes the application component. This method overrides the parent implementation by preprocessing the user request data.

loadMessages() method

protected array loadMessages(string $category, string $language)
$category	string	the message category
$language	string	the target language
{return}	array	the loaded messages

Loads the message translation for the specified language and category.