Cache/Backend/Sqlite.php
Zend Framework
LICENSE
This source file is subject to the new BSD license that is bundled with this package in the file LICENSE.txt. It is also available through the world-wide-web at this URL: http://framework.zend.com/license/new-bsd If you did not receive a copy of the license and are unable to obtain it through the world-wide-web, please send an email to [email protected] so we can send you a copy immediately.
- Category
- Zend
- Copyright
- Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
- License
- New BSD License
- Package
- Zend_Cache
- Subpackage
- Zend_Cache_Backend
- Version
- $Id: Sqlite.php 24593 2012-01-05 20:35:02Z matthew $
\Zend_Cache_Backend_Sqlite
- Implements
- \Zend_Cache_Backend_ExtendedInterface
- Parent(s)
- \Zend_Cache_Backend
- Copyright
- Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
- License
- New BSD License
Properties

array $_directives = array('lifetime' => 3600, 'logging' => false, 'logger' => null)Frontend or Core directives
<p>directives</p>Inherited from: \Zend_Cache_Backend::$$_directives=====> (int) lifetime : - Cache lifetime (in seconds) - If null, the cache is valid forever
=====> (int) logging : - if set to true, a logging is activated throw Zend_Log
array('lifetime' => 3600, 'logging' => false, 'logger' => null)Details- Type
- array
- Inherited_from
- \Zend_Cache_Backend::$$_directives

array $_options = array('cache_db_complete_path' => null, 'automatic_vacuum_factor' => 10)Available options
<p>Available options</p>=====> (string) cache_db_complete_path : - the complete path (filename included) of the SQLITE database
====> (int) automatic_vacuum_factor : - Disable / Tune the automatic vacuum process - The automatic vacuum process defragment the database file (and make it smaller) when a clean() or delete() is called 0 => no automatic vacuum 1 => systematic vacuum (when delete() or clean() methods are called) x (integer) > 1 => automatic vacuum randomly 1 times on x clean() or delete()
array('cache_db_complete_path' => null, 'automatic_vacuum_factor' => 10)Details- Type
- array
Methods

___expire(string $id) : voidPUBLIC METHOD FOR UNIT TESTING ONLY !
Force a cache record to expire
| Name | Type | Description |
|---|---|---|
| $id | string | Cache id |

__construct(array $options = array()) : voidConstructor
| Name | Type | Description |
|---|---|---|
| $options | array | Associative array of options |
| Exception | Description |
|---|---|
| \Zend_cache_Exception |

_checkAndBuildStructure() : booleanCheck if the database structure is ok (with the good version), if no : build it
| Type | Description |
|---|---|
| boolean | True if ok |
| Exception | Description |
|---|---|
| \Zend_Cache_Exception |

_checkStructureVersion() : booleanCheck if the database structure is ok (with the good version)
| Type | Description |
|---|---|
| boolean | True if ok |

_clean(string $mode = \Zend_Cache::CLEANING_MODE_ALL, array $tags = array()) : booleanClean some cache records
Available modes are : Zend_Cache::CLEANING_MODE_ALL (default) => remove all cache entries ($tags is not used) Zend_Cache::CLEANING_MODE_OLD => remove too old cache entries ($tags is not used) Zend_Cache::CLEANING_MODE_MATCHING_TAG => remove cache entries matching all given tags ($tags can be an array of strings or a single string) Zend_Cache::CLEANING_MODE_NOT_MATCHING_TAG => remove cache entries not {matching one of the given tags} ($tags can be an array of strings or a single string) Zend_Cache::CLEANING_MODE_MATCHING_ANY_TAG => remove cache entries matching any given tags ($tags can be an array of strings or a single string)
| Name | Type | Description |
|---|---|---|
| $mode | string | Clean mode |
| $tags | array | Array of tags |
| Type | Description |
|---|---|
| boolean | True if no problem |

_getConnection() : resourceReturn the connection resource
If we are not connected, the connection is made
| Type | Description |
|---|---|
| resource | Connection resource |
| Exception | Description |
|---|---|
| \Zend_Cache_Exception |

_isGoodTmpDir(string $dir) : booleanVerify if the given temporary directory is readable and writable
Inherited from: \Zend_Cache_Backend::_isGoodTmpDir()| Name | Type | Description |
|---|---|---|
| $dir | string | temporary directory |
| Type | Description |
|---|---|
| boolean | true if the directory is ok |

_log(string $message, $priority = 4) : void
| Name | Type | Description |
|---|---|---|
| $message | string | |
| $priority |
| Exception | Description |
|---|---|
| \Zend_Cache_Exception |

_loggerSanity() : voidMake sure if we enable logging that the Zend_Log class is available.
Inherited from: \Zend_Cache_Backend::_loggerSanity()Create a default log object if none is set.
| Exception | Description |
|---|---|
| \Zend_Cache_Exception |

_query(string $query) : mixed | falseExecute an SQL query silently
| Name | Type | Description |
|---|---|---|
| $query | string | SQL query |
| Type | Description |
|---|---|
| mixed | false | query results |

_registerTag(string $id, string $tag) : booleanRegister a cache id with the given tag
| Name | Type | Description |
|---|---|---|
| $id | string | Cache id |
| $tag | string | Tag |
| Type | Description |
|---|---|
| boolean | True if no problem |

clean(string $mode = \Zend_Cache::CLEANING_MODE_ALL, array $tags = array()) : booleanClean some cache records
Available modes are : Zend_Cache::CLEANING_MODE_ALL (default) => remove all cache entries ($tags is not used) Zend_Cache::CLEANING_MODE_OLD => remove too old cache entries ($tags is not used) Zend_Cache::CLEANING_MODE_MATCHING_TAG => remove cache entries matching all given tags ($tags can be an array of strings or a single string) Zend_Cache::CLEANING_MODE_NOT_MATCHING_TAG => remove cache entries not {matching one of the given tags} ($tags can be an array of strings or a single string) Zend_Cache::CLEANING_MODE_MATCHING_ANY_TAG => remove cache entries matching any given tags ($tags can be an array of strings or a single string)
| Name | Type | Description |
|---|---|---|
| $mode | string | Clean mode |
| $tags | array | Array of tags |
| Type | Description |
|---|---|
| boolean | True if no problem |

getCapabilities() : arrayReturn an associative array of capabilities (booleans) of the backend
The array must include these keys : - automatic_cleaning (is automating cleaning necessary) - tags (are tags supported) - expired_read (is it possible to read expired cache records (for doNotTestCacheValidity option for example)) - priority does the backend deal with priority when saving - infinite_lifetime (is infinite lifetime can work with this backend) - get_list (is it possible to get the list of cache ids and the complete list of tags)
| Type | Description |
|---|---|
| array | associative of with capabilities |

getFillingPercentage() : intReturn the filling percentage of the backend storage
| Type | Description |
|---|---|
| int | integer between 0 and 100 |
| Exception | Description |
|---|---|
| \Zend_Cache_Exception |

getIds() : arrayReturn an array of stored cache ids
| Type | Description |
|---|---|
| array | array of stored cache ids (string) |

getIdsMatchingAnyTags(array $tags = array()) : arrayReturn an array of stored cache ids which match any given tags
In case of multiple tags, a logical AND is made between tags
| Name | Type | Description |
|---|---|---|
| $tags | array | array of tags |
| Type | Description |
|---|---|
| array | array of any matching cache ids (string) |

getIdsMatchingTags(array $tags = array()) : arrayReturn an array of stored cache ids which match given tags
In case of multiple tags, a logical AND is made between tags
| Name | Type | Description |
|---|---|---|
| $tags | array | array of tags |
| Type | Description |
|---|---|
| array | array of matching cache ids (string) |

getIdsNotMatchingTags(array $tags = array()) : arrayReturn an array of stored cache ids which don't match given tags
In case of multiple tags, a logical OR is made between tags
| Name | Type | Description |
|---|---|---|
| $tags | array | array of tags |
| Type | Description |
|---|---|
| array | array of not matching cache ids (string) |

getLifetime(int $specificLifetime) : int
if $specificLifetime is not false, the given specific life time is used else, the global lifetime is used
| Name | Type | Description |
|---|---|---|
| $specificLifetime | int |
| Type | Description |
|---|---|
| int | Cache life time |

getMetadatas(string $id) : arrayReturn an array of metadatas for the given cache id
The array must include these keys : - expire : the expire timestamp - tags : a string array of tags - mtime : timestamp of last modification time
| Name | Type | Description |
|---|---|---|
| $id | string | cache id |
| Type | Description |
|---|---|
| array | array of metadatas (false if the cache id is not found) |

getOption(string $name) : mixed
| Name | Type | Description |
|---|---|---|
| $name | string | Optional, the options name to return |
| Type | Description |
|---|---|
| mixed |
| Exception | Description |
|---|---|
| \Zend_Cache_Exceptions |

getTags() : arrayReturn an array of stored tags
| Type | Description |
|---|---|
| array | array of stored tags (string) |

getTmpDir() : stringDetermine system TMP directory and detect if we have read access
Inherited from: \Zend_Cache_Backend::getTmpDir()inspired from Zend_File_Transfer_Adapter_Abstract
| Type | Description |
|---|---|
| string |
| Exception | Description |
|---|---|
| \Zend_Cache_Exception | if unable to determine directory |

isAutomaticCleaningAvailable() : booleanReturn true if the automatic cleaning is available for the backend
Inherited from: \Zend_Cache_Backend::isAutomaticCleaningAvailable()DEPRECATED : use getCapabilities() instead
| Type | Description |
|---|---|
| boolean |

load(string $id, boolean $doNotTestCacheValidity = false) : string | falseTest if a cache is available for the given id and (if yes) return it (false else)
| Name | Type | Description |
|---|---|---|
| $id | string | Cache id |
| $doNotTestCacheValidity | boolean | If set to true, the cache validity won't be tested |
| Type | Description |
|---|---|
| string | false | Cached datas |

remove(string $id) : booleanRemove a cache record
| Name | Type | Description |
|---|---|---|
| $id | string | Cache id |
| Type | Description |
|---|---|
| boolean | True if no problem |

save(string $data, string $id, array $tags = array(), int $specificLifetime = false) : booleanSave some string datas into a cache record
Note : $data is always "string" (serialization is done by the core not by the backend)
| Name | Type | Description |
|---|---|---|
| $data | string | Datas to cache |
| $id | string | Cache id |
| $tags | array | Array of strings, the cache record will be tagged by each string entry |
| $specificLifetime | int | If != false, set a specific lifetime for this cache record (null => infinite lifetime) |
| Type | Description |
|---|---|
| boolean | True if no problem |
| Exception | Description |
|---|---|
| \Zend_Cache_Exception |

setDirectives(array $directives) : void
| Name | Type | Description |
|---|---|---|
| $directives | array | Assoc of directives |
| Exception | Description |
|---|---|
| \Zend_Cache_Exception |

setOption(string $name, mixed $value) : void
| Name | Type | Description |
|---|---|---|
| $name | string | |
| $value | mixed |
| Exception | Description |
|---|---|
| \Zend_Cache_Exception |

test(string $id) : mixed | falseTest if a cache is available or not (for the given id)
| Name | Type | Description |
|---|---|---|
| $id | string | Cache id |
| Type | Description |
|---|---|
| mixed | false | (a cache is not available) or "last modified" timestamp (int) of the available cache record |