Source for file Db.php
Documentation is available at Db.php
* $Id: Db.php 2258 2007-08-17 10:49:51Z jepso $
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
* DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
* THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
* OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
* This software consists of voluntary contributions made by many individuals
* and is licensed under the LGPL. For more information, see
* <http://www.phpdoctrine.com>.
* @subpackage Doctrine_Cache
* @license http://www.opensource.org/licenses/lgpl-license.php LGPL
* @category Object Relational Mapping
* @link www.phpdoctrine.com
* @version $Revision: 2258 $
* @author Konsta Vesterinen <kvesteri@cc.hut.fi>
* @param array $_options an array of options
if ( ! isset
($options['connection']) ||
if ( ! isset
($options['tableName']) ||
* returns the connection object associated with this cache driver
* @return Doctrine_Connection connection object
* Test if a cache is available for the given id and (if yes) return it (false else)
* Note : return value is always "string" (unserialization is done by the core not by the backend)
* @param string $id cache id
* @param boolean $testCacheValidity if set to false, the cache validity won't be tested
* @return string cached datas (or false)
public function fetch($id, $testCacheValidity =
true)
$sql =
'SELECT data, expire FROM ' .
$this->_options['tableName']
if ($testCacheValidity) {
$sql .=
' AND (expire=0 OR expire > ' .
time() .
')';
if ( ! isset
($result[0])) {
* Test if a cache is available or not (for the given id)
* @param string $id cache id
* @return mixed false (a cache is not available) or "last modified" timestamp (int) of the available cache record
$sql =
'SELECT expire FROM ' .
$this->_options['tableName']
.
' WHERE id = ? AND (expire=0 OR expire > ' .
time() .
')';
* Save some string datas into a cache record
* Note : $data is always saved as a string
* @param string $data data to cache
* @param string $id cache id
* @param int $lifeTime if != false, set a specific lifetime for this cache record (null => infinite lifeTime)
* @return boolean true if no problem
public function save($data, $id, $lifeTime =
false)
$sql =
'INSERT INTO ' .
$this->_options['tableName']
.
' (id, data, expire) VALUES (?, ?, ?)';
$expire =
time() +
$lifeTime;
$params =
array($id, serialize($data), $expire);
* @param string $id cache id
* @return boolean true if no problem
$sql =
'DELETE FROM ' .
$this->_options['tableName'] .
' WHERE id = ?';
* Removes all cache records
* $return bool true on success, false on failure
$sql =
'DELETE FROM ' .
$this->_options['tableName'];
* returns the number of cached elements
$sql =
'SELECT COUNT(*) FROM ' .
$this->_options['tableName'];
* Creates the cache table.
$this->getConnection()->export->createTable($name, $fields, $options);