<div id="content">
<h1 align="center">Source for file Db.php</h1>
<p>Documentation is available at <a href="../Doctrine/Doctrine_Cache/_Doctrine---Cache---Db.php.html">Db.php</a></p>
<div class="src-code"><span class="php">
<ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li>
<li><div class="src-line"><a name="a2"></a><span class="src-comm">/*</span></div></li>
<li><div class="src-line"><a name="a3"></a><span class="src-comm"> * $Id: Db.php 2258 2007-08-17 10:49:51Z jepso $</span></div></li>
<li><div class="src-line"><a name="a4"></a><span class="src-comm"> *</span></div></li>
<li><div class="src-line"><a name="a5"></a><span class="src-comm"> * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS</span></div></li>
<li><div class="src-line"><a name="a6"></a><span class="src-comm"> * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT</span></div></li>
<li><div class="src-line"><a name="a7"></a><span class="src-comm"> * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR</span></div></li>
<li><div class="src-line"><a name="a8"></a><span class="src-comm"> * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT</span></div></li>
<li><div class="src-line"><a name="a9"></a><span class="src-comm"> * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,</span></div></li>
<li><div class="src-line"><a name="a10"></a><span class="src-comm"> * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT</span></div></li>
<li><div class="src-line"><a name="a11"></a><span class="src-comm"> * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,</span></div></li>
<li><div class="src-line"><a name="a12"></a><span class="src-comm"> * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY</span></div></li>
<li><div class="src-line"><a name="a13"></a><span class="src-comm"> * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT</span></div></li>
<li><div class="src-line"><a name="a14"></a><span class="src-comm"> * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE</span></div></li>
<li><div class="src-line"><a name="a15"></a><span class="src-comm"> * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.</span></div></li>
<li><div class="src-line"><a name="a16"></a><span class="src-comm"> *</span></div></li>
<li><div class="src-line"><a name="a17"></a><span class="src-comm"> * This software consists of voluntary contributions made by many individuals</span></div></li>
<li><div class="src-line"><a name="a18"></a><span class="src-comm"> * and is licensed under the LGPL. For more information, see</span></div></li>
<li><div class="src-line"><a name="a19"></a><span class="src-comm"> * <http://www.phpdoctrine.com>.</span></div></li>
<li><div class="src-line"><a name="a20"></a><span class="src-comm"> */</span></div></li>
<li><div class="src-line"><a name="a21"></a> </div></li>
<li><div class="src-line"><a name="a22"></a><span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a23"></a><span class="src-doc"> * Doctrine_Cache_Db</span></div></li>
<li><div class="src-line"><a name="a24"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Doctrine</span></div></li>
<li><div class="src-line"><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> Doctrine_Cache</span></div></li>
<li><div class="src-line"><a name="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.opensource.org/licenses/lgpl-license.php LGPL</span></div></li>
<li><div class="src-line"><a name="a28"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc"> Object Relational Mapping</span></div></li>
<li><div class="src-line"><a name="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@link</span><span class="src-doc"> www.phpdoctrine.com</span></div></li>
<li><div class="src-line"><a name="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@since</span><span class="src-doc"> 1.0</span></div></li>
<li><div class="src-line"><a name="a31"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 2258 $</span></div></li>
<li><div class="src-line"><a name="a32"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Konsta Vesterinen <kvesteri@cc.hut.fi></span></div></li>
<li><div class="src-line"><a name="a33"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a34"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html">Doctrine_Cache_Db</a> <span class="src-key">extends </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html">Doctrine_Cache_Driver</a> <span class="src-key">implements </span><span class="src-id">Countable</span></div></li>
<li><div class="src-line"><a name="a35"></a><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a36"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a37"></a><span class="src-doc"> * constructor</span></div></li>
<li><div class="src-line"><a name="a38"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a39"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">array </span><span class="src-doc-var">$_options </span><span class="src-doc"> an array of options</span></div></li>
<li><div class="src-line"><a name="a40"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a41"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#method__construct">__construct</a><span class="src-sym">(</span><span class="src-var">$options</span><span class="src-sym">) </span></div></li>
<li><div class="src-line"><a name="a42"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a43"></a> <span class="src-key">if </span><span class="src-sym">( </span><span class="src-sym">! </span>isset<span class="src-sym">(</span><span class="src-var">$options</span><span class="src-sym">[</span><span class="src-str">'connection'</span><span class="src-sym">]</span><span class="src-sym">) </span>|| </div></li>
<li><div class="src-line"><a name="a44"></a> <span class="src-sym">! </span><span class="src-sym">(</span><span class="src-var">$options</span><span class="src-sym">[</span><span class="src-str">'connection'</span><span class="src-sym">] </span>instanceof <span class="src-id"><a href="../Doctrine/Doctrine_Connection.html">Doctrine_Connection</a></span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a45"></a> </div></li>
<li><div class="src-line"><a name="a46"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Exception.html">Doctrine_Cache_Exception</a></span><span class="src-sym">(</span><span class="src-str">'Connection option not set.'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a47"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a48"></a> </div></li>
<li><div class="src-line"><a name="a49"></a> <span class="src-key">if </span><span class="src-sym">( </span><span class="src-sym">! </span>isset<span class="src-sym">(</span><span class="src-var">$options</span><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">]</span><span class="src-sym">) </span>||</div></li>
<li><div class="src-line"><a name="a50"></a> <span class="src-sym">! </span><a href="http://www.php.net/is_string">is_string</a><span class="src-sym">(</span><span class="src-var">$options</span><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a51"></a> </div></li>
<li><div class="src-line"><a name="a52"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Exception.html">Doctrine_Cache_Exception</a></span><span class="src-sym">(</span><span class="src-str">'Table name option not set.'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a53"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a54"></a> </div></li>
<li><div class="src-line"><a name="a55"></a> </div></li>
<li><div class="src-line"><a name="a56"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a> = <span class="src-var">$options</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a57"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a58"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a59"></a><span class="src-doc"> * getConnection</span></div></li>
<li><div class="src-line"><a name="a60"></a><span class="src-doc"> * returns the connection object associated with this cache driver</span></div></li>
<li><div class="src-line"><a name="a61"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a62"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">Doctrine_Connection </span><span class="src-doc"> connection object</span></div></li>
<li><div class="src-line"><a name="a63"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a64"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodgetConnection">getConnection</a><span class="src-sym">(</span><span class="src-sym">) </span></div></li>
<li><div class="src-line"><a name="a65"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a66"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a><span class="src-sym">[</span><span class="src-str">'connection'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a67"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a68"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a69"></a><span class="src-doc"> * Test if a cache is available for the given id and (if yes) return it (false else)</span></div></li>
<li><div class="src-line"><a name="a70"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a71"></a><span class="src-doc"> * Note : return value is always "string" (unserialization is done by the core not by the backend)</span></div></li>
<li><div class="src-line"><a name="a72"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a73"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$id </span><span class="src-doc">cache id</span></div></li>
<li><div class="src-line"><a name="a74"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">boolean </span><span class="src-doc-var">$testCacheValidity </span><span class="src-doc"> if set to false, the cache validity won't be tested</span></div></li>
<li><div class="src-line"><a name="a75"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">cached datas (or false)</span></div></li>
<li><div class="src-line"><a name="a76"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a77"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodfetch">fetch</a><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">, </span><span class="src-var">$testCacheValidity </span>= <span class="src-id">true</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a78"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a79"></a> <span class="src-var">$sql </span>= <span class="src-str">'SELECT data, expire FROM ' </span>. <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">]</span></div></li>
<li><div class="src-line"><a name="a80"></a> . <span class="src-str">' WHERE id = ?'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a81"></a> </div></li>
<li><div class="src-line"><a name="a82"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$testCacheValidity</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a83"></a> <span class="src-var">$sql </span>.= <span class="src-str">' AND (expire=0 OR expire > ' </span>. <a href="http://www.php.net/time">time</a><span class="src-sym">(</span><span class="src-sym">) </span>. <span class="src-str">')'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a84"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a85"></a> </div></li>
<li><div class="src-line"><a name="a86"></a> <span class="src-var">$result </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodgetConnection">getConnection</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">fetchAssoc</span><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">, </span><span class="src-key">array</span><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a87"></a> </div></li>
<li><div class="src-line"><a name="a88"></a> <span class="src-key">if </span><span class="src-sym">( </span><span class="src-sym">! </span>isset<span class="src-sym">(</span><span class="src-var">$result</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a89"></a> <span class="src-key">return </span><span class="src-id">false</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a90"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a91"></a> </div></li>
<li><div class="src-line"><a name="a92"></a> <span class="src-key">return </span><a href="http://www.php.net/unserialize">unserialize</a><span class="src-sym">(</span><span class="src-var">$result</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">[</span><span class="src-str">'data'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a93"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a94"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a95"></a><span class="src-doc"> * Test if a cache is available or not (for the given id)</span></div></li>
<li><div class="src-line"><a name="a96"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a97"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$id </span><span class="src-doc">cache id</span></div></li>
<li><div class="src-line"><a name="a98"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span><span class="src-doc">false (a cache is not available) or "last modified" timestamp (int) of the available cache record</span></div></li>
<li><div class="src-line"><a name="a99"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a100"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodcontains">contains</a><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">) </span></div></li>
<li><div class="src-line"><a name="a101"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a102"></a> <span class="src-var">$sql </span>= <span class="src-str">'SELECT expire FROM ' </span>. <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">]</span></div></li>
<li><div class="src-line"><a name="a103"></a> . <span class="src-str">' WHERE id = ? AND (expire=0 OR expire > ' </span>. <a href="http://www.php.net/time">time</a><span class="src-sym">(</span><span class="src-sym">) </span>. <span class="src-str">')'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a104"></a> </div></li>
<li><div class="src-line"><a name="a105"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodgetConnection">getConnection</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">fetchOne</span><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">, </span><span class="src-key">array</span><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a106"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a107"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a108"></a><span class="src-doc"> * Save some string datas into a cache record</span></div></li>
<li><div class="src-line"><a name="a109"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a110"></a><span class="src-doc"> * Note : $data is always saved as a string</span></div></li>
<li><div class="src-line"><a name="a111"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a112"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$data </span><span class="src-doc"> data to cache</span></div></li>
<li><div class="src-line"><a name="a113"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$id </span><span class="src-doc"> cache id</span></div></li>
<li><div class="src-line"><a name="a114"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$lifeTime </span><span class="src-doc"> if != false, set a specific lifetime for this cache record (null => infinite lifeTime)</span></div></li>
<li><div class="src-line"><a name="a115"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">boolean </span><span class="src-doc">true if no problem</span></div></li>
<li><div class="src-line"><a name="a116"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a117"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodsave">save</a><span class="src-sym">(</span><span class="src-var">$data</span><span class="src-sym">, </span><span class="src-var">$id</span><span class="src-sym">, </span><span class="src-var">$lifeTime </span>= <span class="src-id">false</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a118"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a119"></a> <span class="src-var">$sql </span>= <span class="src-str">'INSERT INTO ' </span>. <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">]</span></div></li>
<li><div class="src-line"><a name="a120"></a> . <span class="src-str">' (id, data, expire) VALUES (?, ?, ?)'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a121"></a> </div></li>
<li><div class="src-line"><a name="a122"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$lifeTime</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a123"></a> <span class="src-var">$expire </span>= <a href="http://www.php.net/time">time</a><span class="src-sym">(</span><span class="src-sym">) </span>+ <span class="src-var">$lifeTime</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a124"></a> <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a125"></a> <span class="src-var">$expire </span>= <span class="src-num">0</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a126"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a127"></a> </div></li>
<li><div class="src-line"><a name="a128"></a> <span class="src-var">$params </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">, </span><a href="http://www.php.net/serialize">serialize</a><span class="src-sym">(</span><span class="src-var">$data</span><span class="src-sym">)</span><span class="src-sym">, </span><span class="src-var">$expire</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a129"></a> </div></li>
<li><div class="src-line"><a name="a130"></a> <span class="src-key">return </span>(bool) <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodgetConnection">getConnection</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">exec</span><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">, </span><span class="src-var">$params</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a131"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a132"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a133"></a><span class="src-doc"> * Remove a cache record</span></div></li>
<li><div class="src-line"><a name="a134"></a><span class="src-doc"> * </span></div></li>
<li><div class="src-line"><a name="a135"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$id </span><span class="src-doc">cache id</span></div></li>
<li><div class="src-line"><a name="a136"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">boolean </span><span class="src-doc">true if no problem</span></div></li>
<li><div class="src-line"><a name="a137"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a138"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methoddelete">delete</a><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">) </span></div></li>
<li><div class="src-line"><a name="a139"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a140"></a> <span class="src-var">$sql </span>= <span class="src-str">'DELETE FROM ' </span>. <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">] </span>. <span class="src-str">' WHERE id = ?'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a141"></a> </div></li>
<li><div class="src-line"><a name="a142"></a> <span class="src-key">return </span>(bool) <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodgetConnection">getConnection</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">exec</span><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">, </span><span class="src-key">array</span><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a143"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a144"></a> </div></li>
<li><div class="src-line"><a name="a145"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a146"></a><span class="src-doc"> * Removes all cache records</span></div></li>
<li><div class="src-line"><a name="a147"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a148"></a><span class="src-doc"> * $return bool true on success, false on failure</span></div></li>
<li><div class="src-line"><a name="a149"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a150"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methoddeleteAll">deleteAll</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a151"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a152"></a> <span class="src-var">$sql </span>= <span class="src-str">'DELETE FROM ' </span>. <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a153"></a> </div></li>
<li><div class="src-line"><a name="a154"></a> <span class="src-key">return </span>(bool) <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodgetConnection">getConnection</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">exec</span><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a155"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a156"></a> </div></li>
<li><div class="src-line"><a name="a157"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a158"></a><span class="src-doc"> * count</span></div></li>
<li><div class="src-line"><a name="a159"></a><span class="src-doc"> * returns the number of cached elements</span></div></li>
<li><div class="src-line"><a name="a160"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a161"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">integer </span></div></li>
<li><div class="src-line"><a name="a162"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a163"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodcount">count</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a164"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a165"></a> <span class="src-var">$sql </span>= <span class="src-str">'SELECT COUNT(*) FROM ' </span>. <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a166"></a> </div></li>
<li><div class="src-line"><a name="a167"></a> <span class="src-key">return </span>(int) <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodgetConnection">getConnection</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">fetchOne</span><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a168"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a169"></a> </div></li>
<li><div class="src-line"><a name="a170"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a171"></a><span class="src-doc"> * Creates the cache table.</span></div></li>
<li><div class="src-line"><a name="a172"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a173"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodcreateTable">createTable</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a174"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a175"></a> <span class="src-var">$name </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Driver.html#var$_options">_options</a><span class="src-sym">[</span><span class="src-str">'tableName'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a176"></a> </div></li>
<li><div class="src-line"><a name="a177"></a> <span class="src-var">$fields </span>= <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a178"></a> <span class="src-str">'id' </span>=> <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a179"></a> <span class="src-str">'type' </span>=> <span class="src-str">'string'</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a180"></a> <span class="src-str">'length' </span>=> <span class="src-num">255</span></div></li>
<li><div class="src-line"><a name="a181"></a> <span class="src-sym">)</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a182"></a> <span class="src-str">'data' </span>=> <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a183"></a> <span class="src-str">'type' </span>=> <span class="src-str">'blob'</span></div></li>
<li><div class="src-line"><a name="a184"></a> <span class="src-sym">)</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a185"></a> <span class="src-str">'expire' </span>=> <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a186"></a> <span class="src-str">'type' </span>=> <span class="src-str">'timestamp'</span></div></li>
<li><div class="src-line"><a name="a187"></a> <span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a188"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a189"></a> </div></li>
<li><div class="src-line"><a name="a190"></a> <span class="src-var">$options </span>= <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a191"></a> <span class="src-str">'primary' </span>=> <span class="src-key">array</span><span class="src-sym">(</span><span class="src-str">'id'</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a192"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a193"></a> </div></li>
<li><div class="src-line"><a name="a194"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Cache/Doctrine_Cache_Db.html#methodgetConnection">getConnection</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">export</span><span class="src-sym">-></span><span class="src-id">createTable</span><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-var">$fields</span><span class="src-sym">, </span><span class="src-var">$options</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a195"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a196"></a><span class="src-sym">}</span></div></li>
</ol>
</span></div>
</div>