PHP Class Prado\Caching\TDbCache

TDbCache implements a cache application module by storing cached data in a database. TDbCache relies on {@link http://www.php.net/manual/en/ref.pdo.php PDO} to retrieve data from databases. In order to use TDbCache, you need to enable the PDO extension as well as the corresponding PDO DB driver. For example, to use SQLite database to store cached data, you need both php_pdo and php_pdo_sqlite extensions. By default, TDbCache creates and uses an SQLite database under the application runtime directory. You may change this default setting by specifying the following properties: - {@link setConnectionID ConnectionID} or - {@link setConnectionString ConnectionString}, {@link setUsername Username} and {@link setPassword Pasword}. The cached data is stored in a table in the specified database. By default, the name of the table is called 'pradocache'. If the table does not exist in the database, it will be automatically created with the following structure: CREATE TABLE pradocache (itemkey CHAR(128), value BLOB, expire INT) CREATE INDEX IX_itemkey ON pradocache (itemkey) CREATE INDEX IX_expire ON pradocache (expire) Note, some DBMS might not support BLOB type. In this case, replace 'BLOB' with a suitable binary data type (e.g. LONGBLOB in MySQL, BYTEA in PostgreSQL.) Important: Make sure that the indices are non-unique! If you want to change the cache table name, or if you want to create the table by yourself, you may set {@link setCacheTableName CacheTableName} and {@link setAutoCreateCacheTable AutoCreateCacheTableName} properties. {@link setFlushInterval FlushInterval} control how often expired items will be removed from cache. If you prefer to remove expired items manualy e.g. via cronjob you can disable automatic deletion by setting FlushInterval to '0'. The following basic cache operations are implemented: - {@link get} : retrieve the value with a key (if any) from cache - {@link set} : store the value with a key into cache - {@link add} : store the value only if cache does not have this key - {@link delete} : delete the value with the specified key from cache - {@link flush} : delete all values from cache Each value is associated with an expiration time. The {@link get} operation ensures that any expired value will not be returned. The expiration time by the number of seconds. A expiration time 0 represents never expire. By definition, cache does not ensure the existence of a value even if it never expires. Cache is not meant to be an persistent storage. Do not use the same database file for multiple applications using TDbCache. Also note, cache is shared by all user sessions of an application. Some usage examples of TDbCache are as follows, $cache=new TDbCache; // TDbCache may also be loaded as a Prado application module $cache->init(null); $cache->add('object',$object); $object2=$cache->get('object'); If loaded, TDbCache will register itself with {@link TApplication} as the cache module. It can be accessed via {@link TApplication::getCache()}. TDbCache may be configured in application configuration file as follows
Since: 3.1.0
Author: Qiang Xue ([email protected])
Inheritance: extends TCache
Afficher le fichier Open project: pradosoft/prado

Méthodes publiques

Méthode Description
__destruct ( ) Destructor.
doFlushCacheExpired ( ) : void Event listener for TApplication.OnSaveState
doInitializeCache ( ) : void Event listener for TApplication.OnLoadStateComplete
flush ( ) Deletes all values from cache.
flushCacheExpired ( $force = false ) : void Flush expired values from cache depending on {@link setFlushInterval FlushInterval}
getAutoCreateCacheTable ( ) : boolean
getCacheTableName ( ) : string
getConnectionID ( ) : string
getConnectionString ( ) : string
getDbConnection ( ) : TDbConnection
getFlushInterval ( ) : integer
getPassword ( ) : string
getUsername ( ) : string
init ( $config ) Initializes this module.
setAutoCreateCacheTable ( $value )
setCacheTableName ( $value ) Sets the name of the DB table to store cache content.
setConnectionID ( $value ) Sets the ID of a TDataSourceConfig module.
setConnectionString ( $value )
setFlushInterval ( $value ) Sets interval expired items will be removed from cache
setPassword ( $value )
setUsername ( $value )

Méthodes protégées

Méthode Description
addValue ( $key, $value, $expire ) : boolean Stores a value identified by a key into cache if the cache does not contain this key.
createDbConnection ( ) : TDbConnection Creates the DB connection.
deleteValue ( $key ) : boolean Deletes a value with the specified key from cache This is the implementation of the method declared in the parent class.
getValue ( $key ) : string Retrieves a value from cache with a specified key.
initializeCache ( $force = false ) : void Initialize TDbCache
setValue ( $key, $value, $expire ) : boolean Stores a value identified by a key in cache.

Method Details

__destruct() public méthode

Disconnect the db connection.
public __destruct ( )

addValue() protected méthode

This is the implementation of the method declared in the parent class.
protected addValue ( $key, $value, $expire ) : boolean
Résultat boolean true if the value is successfully stored into cache, false otherwise

createDbConnection() protected méthode

Creates the DB connection.
protected createDbConnection ( ) : TDbConnection
Résultat Prado\Data\TDbConnection the created DB connection

deleteValue() protected méthode

Deletes a value with the specified key from cache This is the implementation of the method declared in the parent class.
protected deleteValue ( $key ) : boolean
Résultat boolean if no error happens during deletion

doFlushCacheExpired() public méthode

Event listener for TApplication.OnSaveState
See also: flushCacheExpired
Since: 3.1.5
public doFlushCacheExpired ( ) : void
Résultat void

doInitializeCache() public méthode

Event listener for TApplication.OnLoadStateComplete
See also: initializeCache
Since: 3.1.5
public doInitializeCache ( ) : void
Résultat void

flush() public méthode

Be careful of performing this operation if the cache is shared by multiple applications.
public flush ( )

flushCacheExpired() public méthode

Flush expired values from cache depending on {@link setFlushInterval FlushInterval}
Since: 3.1.5
public flushCacheExpired ( $force = false ) : void
Résultat void

getAutoCreateCacheTable() public méthode

See also: setAutoCreateCacheTable
public getAutoCreateCacheTable ( ) : boolean
Résultat boolean whether the cache DB table should be automatically created if not exists. Defaults to true.

getCacheTableName() public méthode

See also: setAutoCreateCacheTable
public getCacheTableName ( ) : string
Résultat string the name of the DB table to store cache content. Defaults to 'pradocache'.

getConnectionID() public méthode

Since: 3.1.1
public getConnectionID ( ) : string
Résultat string the ID of a {@link TDataSourceConfig} module. Defaults to empty string, meaning not set.

getConnectionString() public méthode

public getConnectionString ( ) : string
Résultat string The Data Source Name, or DSN, contains the information required to connect to the database.

getDbConnection() public méthode

public getDbConnection ( ) : TDbConnection
Résultat Prado\Data\TDbConnection the DB connection instance

getFlushInterval() public méthode

Since: 3.1.5
public getFlushInterval ( ) : integer
Résultat integer Interval in sec expired items will be removed from cache. Default to 60

getPassword() public méthode

public getPassword ( ) : string
Résultat string the password for establishing DB connection. Defaults to empty string.

getUsername() public méthode

public getUsername ( ) : string
Résultat string the username for establishing DB connection. Defaults to empty string.

getValue() protected méthode

This is the implementation of the method declared in the parent class.
protected getValue ( $key ) : string
Résultat string the value stored in cache, false if the value is not in the cache or expired.

init() public méthode

This method is required by the IModule interface. attach {@link doInitializeCache} to TApplication.OnLoadStateComplete event attach {@link doFlushCacheExpired} to TApplication.OnSaveState event
public init ( $config )

initializeCache() protected méthode

If {@link setAutoCreateCacheTable AutoCreateCacheTableName} is 'true' check existence of cache table and create table if does not exist.
Since: 3.1.5
protected initializeCache ( $force = false ) : void
Résultat void

setAutoCreateCacheTable() public méthode

See also: setCacheTableName
public setAutoCreateCacheTable ( $value )

setCacheTableName() public méthode

Note, if {@link setAutoCreateCacheTable AutoCreateCacheTable} is false and you want to create the DB table manually by yourself, you need to make sure the DB table is of the following structure: CREATE TABLE pradocache (itemkey CHAR(128), value BLOB, expire INT) CREATE INDEX IX_itemkey ON pradocache (itemkey) CREATE INDEX IX_expire ON pradocache (expire) Note, some DBMS might not support BLOB type. In this case, replace 'BLOB' with a suitable binary data type (e.g. LONGBLOB in MySQL, BYTEA in PostgreSQL.) Important: Make sure that the indices are non-unique!
See also: setAutoCreateCacheTable
public setCacheTableName ( $value )

setConnectionID() public méthode

The datasource module will be used to establish the DB connection for this cache module. The database connection can also be specified via {@link setConnectionString ConnectionString}. When both ConnectionID and ConnectionString are specified, the former takes precedence.
Since: 3.1.1
public setConnectionID ( $value )

setConnectionString() public méthode

See also: http://www.php.net/manual/en/function.pdo-construct.php
public setConnectionString ( $value )

setFlushInterval() public méthode

To disable automatic deletion of expired items, e.g. for external flushing via cron you can set value to '0'
Since: 3.1.5
public setFlushInterval ( $value )

setPassword() public méthode

public setPassword ( $value )

setUsername() public méthode

public setUsername ( $value )

setValue() protected méthode

This is the implementation of the method declared in the parent class.
protected setValue ( $key, $value, $expire ) : boolean
Résultat boolean true if the value is successfully stored into cache, false otherwise