| 464 |
jpm |
1 |
<!DOCTYPE html>
|
|
|
2 |
<html>
|
|
|
3 |
<head>
|
|
|
4 |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|
|
|
5 |
<meta name="generator" content="ApiGen 2.8.0">
|
|
|
6 |
<meta name="robots" content="noindex">
|
|
|
7 |
|
| 465 |
jpm |
8 |
<title>File CacheSqlite.php</title>
|
| 464 |
jpm |
9 |
|
|
|
10 |
<script type="text/javascript" src="resources/combined.js?4205936287"></script>
|
| 465 |
jpm |
11 |
<script type="text/javascript" src="elementlist.js?4111837732"></script>
|
| 464 |
jpm |
12 |
<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360">
|
|
|
13 |
|
|
|
14 |
</head>
|
|
|
15 |
|
|
|
16 |
<body>
|
|
|
17 |
<div id="left">
|
|
|
18 |
<div id="menu">
|
|
|
19 |
<a href="index.html" title="Overview"><span>Overview</span></a>
|
|
|
20 |
|
|
|
21 |
|
|
|
22 |
<div id="groups">
|
|
|
23 |
<h3>Packages</h3>
|
|
|
24 |
<ul>
|
|
|
25 |
<li><a href="package-Framework.html">Framework</a>
|
|
|
26 |
</li>
|
|
|
27 |
<li class="active"><a href="package-None.html">None</a>
|
|
|
28 |
</li>
|
|
|
29 |
<li><a href="package-PHP.html">PHP</a>
|
|
|
30 |
</li>
|
|
|
31 |
<li><a href="package-Utilitaire.html">Utilitaire</a>
|
|
|
32 |
</li>
|
|
|
33 |
</ul>
|
|
|
34 |
</div>
|
|
|
35 |
|
|
|
36 |
<hr>
|
|
|
37 |
|
|
|
38 |
|
|
|
39 |
<div id="elements">
|
|
|
40 |
<h3>Classes</h3>
|
|
|
41 |
<ul>
|
|
|
42 |
<li><a href="class-CacheFichier.html">CacheFichier</a></li>
|
|
|
43 |
<li class="active"><a href="class-CacheSqlite.html">CacheSqlite</a></li>
|
|
|
44 |
</ul>
|
|
|
45 |
|
|
|
46 |
|
|
|
47 |
|
|
|
48 |
|
|
|
49 |
|
|
|
50 |
</div>
|
|
|
51 |
</div>
|
|
|
52 |
</div>
|
|
|
53 |
|
|
|
54 |
<div id="splitter"></div>
|
|
|
55 |
|
|
|
56 |
<div id="right">
|
|
|
57 |
<div id="rightInner">
|
|
|
58 |
<form id="search">
|
|
|
59 |
<input type="hidden" name="cx" value="">
|
|
|
60 |
<input type="hidden" name="ie" value="UTF-8">
|
|
|
61 |
<input type="text" name="q" class="text">
|
|
|
62 |
<input type="submit" value="Search">
|
|
|
63 |
</form>
|
|
|
64 |
|
|
|
65 |
<div id="navigation">
|
|
|
66 |
<ul>
|
|
|
67 |
<li>
|
|
|
68 |
<a href="index.html" title="Overview"><span>Overview</span></a>
|
|
|
69 |
</li>
|
|
|
70 |
<li>
|
|
|
71 |
<a href="package-None.html" title="Summary of None"><span>Package</span></a>
|
|
|
72 |
</li>
|
|
|
73 |
<li>
|
|
|
74 |
<a href="class-CacheSqlite.html" title="Summary of CacheSqlite"><span>Class</span></a>
|
|
|
75 |
</li>
|
|
|
76 |
</ul>
|
|
|
77 |
<ul>
|
|
|
78 |
<li>
|
|
|
79 |
<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
|
|
|
80 |
</li>
|
|
|
81 |
<li>
|
|
|
82 |
<a href="deprecated.html" title="List of deprecated elements"><span>Deprecated</span></a>
|
|
|
83 |
</li>
|
|
|
84 |
<li>
|
|
|
85 |
<a href="todo.html" title="Todo list"><span>Todo</span></a>
|
|
|
86 |
</li>
|
|
|
87 |
</ul>
|
|
|
88 |
<ul>
|
|
|
89 |
</ul>
|
|
|
90 |
</div>
|
|
|
91 |
|
|
|
92 |
<pre><code><span id="1" class="l"><a class="l" href="#1"> 1: </a><span class="xlang"><?php</span>
|
|
|
93 |
</span><span id="2" class="l"><a class="l" href="#2"> 2: </a><span class="php-keyword1">class</span> <a id="CacheSqlite" href="#CacheSqlite">CacheSqlite</a> {
|
|
|
94 |
</span><span id="3" class="l"><a class="l" href="#3"> 3: </a> <span class="php-comment">/**
|
|
|
95 |
</span></span><span id="4" class="l"><a class="l" href="#4"> 4: </a><span class="php-comment"> * Options disponibles :
|
|
|
96 |
</span></span><span id="5" class="l"><a class="l" href="#5"> 5: </a><span class="php-comment"> *
|
|
|
97 |
</span></span><span id="6" class="l"><a class="l" href="#6"> 6: </a><span class="php-comment"> * ====> (string) stockage_chemin :
|
|
|
98 |
</span></span><span id="7" class="l"><a class="l" href="#7"> 7: </a><span class="php-comment"> * Chemin vers le fichier contenant la base SQLite.
|
|
|
99 |
</span></span><span id="8" class="l"><a class="l" href="#8"> 8: </a><span class="php-comment"> *
|
|
|
100 |
</span></span><span id="9" class="l"><a class="l" href="#9"> 9: </a><span class="php-comment"> *
|
|
|
101 |
</span></span><span id="10" class="l"><a class="l" href="#10"> 10: </a><span class="php-comment"> * ====> (int) defragmentation_auto :
|
|
|
102 |
</span></span><span id="11" class="l"><a class="l" href="#11"> 11: </a><span class="php-comment"> * - Désactive / Régler le processus de défragmentation automatique
|
|
|
103 |
</span></span><span id="12" class="l"><a class="l" href="#12"> 12: </a><span class="php-comment"> * - Le processus de défragmentation automatiques réduit la taille du fichier contenant la base de données
|
|
|
104 |
</span></span><span id="13" class="l"><a class="l" href="#13"> 13: </a><span class="php-comment"> * quand un ajout ou une suppression de cache est réalisée :
|
|
|
105 |
</span></span><span id="14" class="l"><a class="l" href="#14"> 14: </a><span class="php-comment"> * 0 => pas de défragmentation automatique
|
|
|
106 |
</span></span><span id="15" class="l"><a class="l" href="#15"> 15: </a><span class="php-comment"> * 1 => défragmentation automatique systématique
|
|
|
107 |
</span></span><span id="16" class="l"><a class="l" href="#16"> 16: </a><span class="php-comment"> * x (integer) > 1 => défragmentation automatique toutes les 1 fois (au hasard) sur x ajout ou suppression de cache
|
|
|
108 |
</span></span><span id="17" class="l"><a class="l" href="#17"> 17: </a><span class="php-comment"> *
|
|
|
109 |
</span></span><span id="18" class="l"><a class="l" href="#18"> 18: </a><span class="php-comment"> * @var array options disponibles
|
|
|
110 |
</span></span><span id="19" class="l"><a class="l" href="#19"> 19: </a><span class="php-comment"> */</span>
|
|
|
111 |
</span><span id="20" class="l"><a class="l" href="#20"> 20: </a> <span class="php-keyword1">protected</span> <span class="php-var"><a id="$options" href="#$options">$options</a></span> = <span class="php-keyword1">array</span>(
|
|
|
112 |
</span><span id="21" class="l"><a class="l" href="#21"> 21: </a> <span class="php-quote">'stockage_chemin'</span> => <span class="php-keyword1">null</span>,
|
|
|
113 |
</span><span id="22" class="l"><a class="l" href="#22"> 22: </a> <span class="php-quote">'defragmentation_auto'</span> => <span class="php-num">10</span>
|
|
|
114 |
</span><span id="23" class="l"><a class="l" href="#23"> 23: </a> );
|
|
|
115 |
</span><span id="24" class="l"><a class="l" href="#24"> 24: </a>
|
|
|
116 |
</span><span id="25" class="l"><a class="l" href="#25"> 25: </a> <span class="php-comment">/**
|
|
|
117 |
</span></span><span id="26" class="l"><a class="l" href="#26"> 26: </a><span class="php-comment"> * DB ressource
|
|
|
118 |
</span></span><span id="27" class="l"><a class="l" href="#27"> 27: </a><span class="php-comment"> *
|
|
|
119 |
</span></span><span id="28" class="l"><a class="l" href="#28"> 28: </a><span class="php-comment"> * @var mixed $db
|
|
|
120 |
</span></span><span id="29" class="l"><a class="l" href="#29"> 29: </a><span class="php-comment"> */</span>
|
|
|
121 |
</span><span id="30" class="l"><a class="l" href="#30"> 30: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$bdd" href="#$bdd">$bdd</a></span> = <span class="php-keyword1">null</span>;
|
|
|
122 |
</span><span id="31" class="l"><a class="l" href="#31"> 31: </a>
|
|
|
123 |
</span><span id="32" class="l"><a class="l" href="#32"> 32: </a> <span class="php-comment">/**
|
|
|
124 |
</span></span><span id="33" class="l"><a class="l" href="#33"> 33: </a><span class="php-comment"> * Boolean to store if the structure has benn checked or not
|
|
|
125 |
</span></span><span id="34" class="l"><a class="l" href="#34"> 34: </a><span class="php-comment"> *
|
|
|
126 |
</span></span><span id="35" class="l"><a class="l" href="#35"> 35: </a><span class="php-comment"> * @var boolean $structure_ok
|
|
|
127 |
</span></span><span id="36" class="l"><a class="l" href="#36"> 36: </a><span class="php-comment"> */</span>
|
|
|
128 |
</span><span id="37" class="l"><a class="l" href="#37"> 37: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$structure_ok" href="#$structure_ok">$structure_ok</a></span> = <span class="php-keyword1">false</span>;
|
|
|
129 |
</span><span id="38" class="l"><a class="l" href="#38"> 38: </a>
|
|
|
130 |
</span><span id="39" class="l"><a class="l" href="#39"> 39: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$Cache" href="#$Cache">$Cache</a></span> = <span class="php-keyword1">null</span>;
|
|
|
131 |
</span><span id="40" class="l"><a class="l" href="#40"> 40: </a>
|
|
|
132 |
</span><span id="41" class="l"><a class="l" href="#41"> 41: </a> <span class="php-comment">/**
|
|
|
133 |
</span></span><span id="42" class="l"><a class="l" href="#42"> 42: </a><span class="php-comment"> * Constructor
|
|
|
134 |
</span></span><span id="43" class="l"><a class="l" href="#43"> 43: </a><span class="php-comment"> *
|
|
|
135 |
</span></span><span id="44" class="l"><a class="l" href="#44"> 44: </a><span class="php-comment"> * @param array $options Associative array of options
|
|
|
136 |
</span></span><span id="45" class="l"><a class="l" href="#45"> 45: </a><span class="php-comment"> * @throws Zend_cache_Exception
|
|
|
137 |
</span></span><span id="46" class="l"><a class="l" href="#46"> 46: </a><span class="php-comment"> * @return void
|
|
|
138 |
</span></span><span id="47" class="l"><a class="l" href="#47"> 47: </a><span class="php-comment"> */</span>
|
|
|
139 |
</span><span id="48" class="l"><a class="l" href="#48"> 48: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="___construct" href="#___construct">__construct</a>(<span class="php-keyword1">array</span> <span class="php-var">$options</span> = <span class="php-keyword1">array</span>(), Cache <span class="php-var">$cache</span>) {
|
|
|
140 |
</span><span id="49" class="l"><a class="l" href="#49"> 49: </a> <span class="php-var">$this</span>->Cache = <span class="php-var">$cache</span>;
|
|
|
141 |
</span><span id="50" class="l"><a class="l" href="#50"> 50: </a> <span class="php-keyword1">if</span> (<span class="php-keyword2">extension_loaded</span>(<span class="php-quote">'sqlite'</span>)) {
|
|
|
142 |
</span><span id="51" class="l"><a class="l" href="#51"> 51: </a> <span class="php-var">$this</span>->initialiserOptionsParConfig();
|
|
|
143 |
</span><span id="52" class="l"><a class="l" href="#52"> 52: </a> <span class="php-var">$this</span>->setOptions(<span class="php-var">$options</span>);
|
|
|
144 |
</span><span id="53" class="l"><a class="l" href="#53"> 53: </a> } <span class="php-keyword1">else</span> {
|
|
|
145 |
</span><span id="54" class="l"><a class="l" href="#54"> 54: </a> <span class="php-var">$e</span> = <span class="php-quote">"Impossible d'utiliser le cache SQLITE car l'extenssion 'sqlite' n'est pas chargée dans l'environnement PHP courrant."</span>;
|
|
|
146 |
</span><span id="55" class="l"><a class="l" href="#55"> 55: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_ERROR);
|
|
|
147 |
</span><span id="56" class="l"><a class="l" href="#56"> 56: </a> }
|
|
|
148 |
</span><span id="57" class="l"><a class="l" href="#57"> 57: </a> }
|
|
|
149 |
</span><span id="58" class="l"><a class="l" href="#58"> 58: </a>
|
|
|
150 |
</span><span id="59" class="l"><a class="l" href="#59"> 59: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_initialiserOptionsParConfig" href="#_initialiserOptionsParConfig">initialiserOptionsParConfig</a>() {
|
|
|
151 |
</span><span id="60" class="l"><a class="l" href="#60"> 60: </a> <span class="php-keyword1">while</span> (<span class="php-keyword1">list</span>(<span class="php-var">$nom</span>, <span class="php-var">$valeur</span>) = <span class="php-keyword2">each</span>(<span class="php-var">$this</span>->options)) {
|
|
|
152 |
</span><span id="61" class="l"><a class="l" href="#61"> 61: </a> <span class="php-keyword1">if</span> (Config::existe(<span class="php-var">$nom</span>)) {
|
|
|
153 |
</span><span id="62" class="l"><a class="l" href="#62"> 62: </a> <span class="php-var">$this</span>->options[<span class="php-var">$nom</span>] = Config::get(<span class="php-var">$nom</span>);
|
|
|
154 |
</span><span id="63" class="l"><a class="l" href="#63"> 63: </a> }
|
|
|
155 |
</span><span id="64" class="l"><a class="l" href="#64"> 64: </a> }
|
|
|
156 |
</span><span id="65" class="l"><a class="l" href="#65"> 65: </a> }
|
|
|
157 |
</span><span id="66" class="l"><a class="l" href="#66"> 66: </a>
|
|
|
158 |
</span><span id="67" class="l"><a class="l" href="#67"> 67: </a> <span class="php-comment">/**
|
|
|
159 |
</span></span><span id="68" class="l"><a class="l" href="#68"> 68: </a><span class="php-comment"> * Destructor
|
|
|
160 |
</span></span><span id="69" class="l"><a class="l" href="#69"> 69: </a><span class="php-comment"> *
|
|
|
161 |
</span></span><span id="70" class="l"><a class="l" href="#70"> 70: </a><span class="php-comment"> * @return void
|
|
|
162 |
</span></span><span id="71" class="l"><a class="l" href="#71"> 71: </a><span class="php-comment"> */</span>
|
|
|
163 |
</span><span id="72" class="l"><a class="l" href="#72"> 72: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="___destruct" href="#___destruct">__destruct</a>() {
|
|
|
164 |
</span><span id="73" class="l"><a class="l" href="#73"> 73: </a> @<span class="php-keyword2">sqlite_close</span>(<span class="php-var">$this</span>->getConnexion());
|
|
|
165 |
</span><span id="74" class="l"><a class="l" href="#74"> 74: </a> }
|
|
|
166 |
</span><span id="75" class="l"><a class="l" href="#75"> 75: </a>
|
|
|
167 |
</span><span id="76" class="l"><a class="l" href="#76"> 76: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_setOptions" href="#_setOptions">setOptions</a>(<span class="php-var">$options</span>) {
|
|
|
168 |
</span><span id="77" class="l"><a class="l" href="#77"> 77: </a> <span class="php-keyword1">while</span> (<span class="php-keyword1">list</span>(<span class="php-var">$nom</span>, <span class="php-var">$valeur</span>) = <span class="php-keyword2">each</span>(<span class="php-var">$options</span>)) {
|
|
|
169 |
</span><span id="78" class="l"><a class="l" href="#78"> 78: </a> <span class="php-keyword1">if</span> (!<span class="php-keyword2">is_string</span>(<span class="php-var">$nom</span>)) {
|
|
|
170 |
</span><span id="79" class="l"><a class="l" href="#79"> 79: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-quote">"Nom d'option incorecte : </span><span class="php-var">$nom</span><span class="php-quote">"</span>, E_USER_WARNING);
|
|
|
171 |
</span><span id="80" class="l"><a class="l" href="#80"> 80: </a> }
|
|
|
172 |
</span><span id="81" class="l"><a class="l" href="#81"> 81: </a> <span class="php-var">$nom</span> = <span class="php-keyword2">strtolower</span>(<span class="php-var">$nom</span>);
|
|
|
173 |
</span><span id="82" class="l"><a class="l" href="#82"> 82: </a> <span class="php-keyword1">if</span> (<span class="php-keyword2">array_key_exists</span>(<span class="php-var">$nom</span>, <span class="php-var">$this</span>->options)) {
|
|
|
174 |
</span><span id="83" class="l"><a class="l" href="#83"> 83: </a> <span class="php-var">$this</span>->options[<span class="php-var">$nom</span>] = <span class="php-var">$valeur</span>;
|
|
|
175 |
</span><span id="84" class="l"><a class="l" href="#84"> 84: </a> }
|
|
|
176 |
</span><span id="85" class="l"><a class="l" href="#85"> 85: </a> }
|
|
|
177 |
</span><span id="86" class="l"><a class="l" href="#86"> 86: </a> }
|
|
|
178 |
</span><span id="87" class="l"><a class="l" href="#87"> 87: </a>
|
|
|
179 |
</span><span id="88" class="l"><a class="l" href="#88"> 88: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_setEmplacement" href="#_setEmplacement">setEmplacement</a>(<span class="php-var">$emplacement</span>) {
|
|
|
180 |
</span><span id="89" class="l"><a class="l" href="#89"> 89: </a> <span class="php-keyword1">if</span> (<span class="php-keyword2">extension_loaded</span>(<span class="php-quote">'sqlite'</span>)) {
|
|
|
181 |
</span><span id="90" class="l"><a class="l" href="#90"> 90: </a> <span class="php-var">$this</span>->options[<span class="php-quote">'stockage_chemin'</span>] = <span class="php-var">$emplacement</span>;
|
|
|
182 |
</span><span id="91" class="l"><a class="l" href="#91"> 91: </a> } <span class="php-keyword1">else</span> {
|
|
|
183 |
</span><span id="92" class="l"><a class="l" href="#92"> 92: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-quote">"Impossible d'utiliser le mode de sotckage SQLite car l'extenssion 'sqlite' n'est pas chargé dans "</span>.
|
|
|
184 |
</span><span id="93" class="l"><a class="l" href="#93"> 93: </a> <span class="php-quote">"l'environnement PHP courrant."</span>, E_USER_ERROR);
|
|
|
185 |
</span><span id="94" class="l"><a class="l" href="#94"> 94: </a> }
|
|
|
186 |
</span><span id="95" class="l"><a class="l" href="#95"> 95: </a> }
|
|
|
187 |
</span><span id="96" class="l"><a class="l" href="#96"> 96: </a>
|
|
|
188 |
</span><span id="97" class="l"><a class="l" href="#97"> 97: </a> <span class="php-comment">/**
|
|
|
189 |
</span></span><span id="98" class="l"><a class="l" href="#98"> 98: </a><span class="php-comment"> * Test if a cache is available for the given id and (if yes) return it (false else)
|
|
|
190 |
</span></span><span id="99" class="l"><a class="l" href="#99"> 99: </a><span class="php-comment"> *
|
|
|
191 |
</span></span><span id="100" class="l"><a class="l" href="#100">100: </a><span class="php-comment"> * @param string $id Cache id
|
|
|
192 |
</span></span><span id="101" class="l"><a class="l" href="#101">101: </a><span class="php-comment"> * @param boolean $doNotTestCacheValidity If set to true, the cache validity won't be tested
|
|
|
193 |
</span></span><span id="102" class="l"><a class="l" href="#102">102: </a><span class="php-comment"> * @return string|false Cached datas
|
|
|
194 |
</span></span><span id="103" class="l"><a class="l" href="#103">103: </a><span class="php-comment"> */</span>
|
|
|
195 |
</span><span id="104" class="l"><a class="l" href="#104">104: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_charger" href="#_charger">charger</a>(<span class="php-var">$id</span>, <span class="php-var">$ne_pas_tester_validiter_du_cache</span> = <span class="php-keyword1">false</span>) {
|
|
|
196 |
</span><span id="105" class="l"><a class="l" href="#105">105: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
197 |
</span><span id="106" class="l"><a class="l" href="#106">106: </a> <span class="php-var">$requete</span> = <span class="php-quote">"SELECT content FROM cache WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>.
|
|
|
198 |
</span><span id="107" class="l"><a class="l" href="#107">107: </a> ((<span class="php-var">$ne_pas_tester_validiter_du_cache</span>) ? <span class="php-quote">''</span> : <span class="php-quote">' AND (expire = 0 OR expire > '</span>.<span class="php-keyword2">time</span>().<span class="php-quote">')'</span>);
|
|
|
199 |
</span><span id="108" class="l"><a class="l" href="#108">108: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-var">$requete</span>);
|
|
|
200 |
</span><span id="109" class="l"><a class="l" href="#109">109: </a> <span class="php-var">$ligne</span> = @<span class="php-keyword2">sqlite_fetch_array</span>(<span class="php-var">$resultat</span>);
|
|
|
201 |
</span><span id="110" class="l"><a class="l" href="#110">110: </a> <span class="php-keyword1">return</span> (<span class="php-var">$ligne</span>) ? <span class="php-var">$ligne</span>[<span class="php-quote">'content'</span>] : <span class="php-keyword1">false</span>;
|
|
|
202 |
</span><span id="111" class="l"><a class="l" href="#111">111: </a> }
|
|
|
203 |
</span><span id="112" class="l"><a class="l" href="#112">112: </a>
|
|
|
204 |
</span><span id="113" class="l"><a class="l" href="#113">113: </a> <span class="php-comment">/**
|
|
|
205 |
</span></span><span id="114" class="l"><a class="l" href="#114">114: </a><span class="php-comment"> * Test if a cache is available or not (for the given id)
|
|
|
206 |
</span></span><span id="115" class="l"><a class="l" href="#115">115: </a><span class="php-comment"> *
|
|
|
207 |
</span></span><span id="116" class="l"><a class="l" href="#116">116: </a><span class="php-comment"> * @param string $id Cache id
|
|
|
208 |
</span></span><span id="117" class="l"><a class="l" href="#117">117: </a><span class="php-comment"> * @return mixed|false (a cache is not available) or "last modified" timestamp (int) of the available cache record
|
|
|
209 |
</span></span><span id="118" class="l"><a class="l" href="#118">118: </a><span class="php-comment"> */</span>
|
|
|
210 |
</span><span id="119" class="l"><a class="l" href="#119">119: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_tester" href="#_tester">tester</a>(<span class="php-var">$id</span>) {
|
|
|
211 |
</span><span id="120" class="l"><a class="l" href="#120">120: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
212 |
</span><span id="121" class="l"><a class="l" href="#121">121: </a> <span class="php-var">$requete</span> = <span class="php-quote">"SELECT lastModified FROM cache WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">' AND (expire = 0 OR expire > "</span>.<span class="php-keyword2">time</span>().<span class="php-quote">')'</span>;
|
|
|
213 |
</span><span id="122" class="l"><a class="l" href="#122">122: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-var">$requete</span>);
|
|
|
214 |
</span><span id="123" class="l"><a class="l" href="#123">123: </a> <span class="php-var">$ligne</span> = @<span class="php-keyword2">sqlite_fetch_array</span>(<span class="php-var">$resultat</span>);
|
|
|
215 |
</span><span id="124" class="l"><a class="l" href="#124">124: </a> <span class="php-keyword1">return</span> (<span class="php-var">$ligne</span>) ? ((int) <span class="php-var">$ligne</span>[<span class="php-quote">'lastModified'</span>]) : <span class="php-keyword1">false</span>;
|
|
|
216 |
</span><span id="125" class="l"><a class="l" href="#125">125: </a> }
|
|
|
217 |
</span><span id="126" class="l"><a class="l" href="#126">126: </a>
|
|
|
218 |
</span><span id="127" class="l"><a class="l" href="#127">127: </a> <span class="php-comment">/**
|
|
|
219 |
</span></span><span id="128" class="l"><a class="l" href="#128">128: </a><span class="php-comment"> * Save some string datas into a cache record
|
|
|
220 |
</span></span><span id="129" class="l"><a class="l" href="#129">129: </a><span class="php-comment"> *
|
|
|
221 |
</span></span><span id="130" class="l"><a class="l" href="#130">130: </a><span class="php-comment"> * Note : $data is always "string" (serialization is done by the
|
|
|
222 |
</span></span><span id="131" class="l"><a class="l" href="#131">131: </a><span class="php-comment"> * core not by the backend)
|
|
|
223 |
</span></span><span id="132" class="l"><a class="l" href="#132">132: </a><span class="php-comment"> *
|
|
|
224 |
</span></span><span id="133" class="l"><a class="l" href="#133">133: </a><span class="php-comment"> * @param string $data Datas to cache
|
|
|
225 |
</span></span><span id="134" class="l"><a class="l" href="#134">134: </a><span class="php-comment"> * @param string $id Cache id
|
|
|
226 |
</span></span><span id="135" class="l"><a class="l" href="#135">135: </a><span class="php-comment"> * @param array $tags Array of strings, the cache record will be tagged by each string entry
|
|
|
227 |
</span></span><span id="136" class="l"><a class="l" href="#136">136: </a><span class="php-comment"> * @param int $specificLifetime If != false, set a specific lifetime for this cache record (null => infinite lifetime)
|
|
|
228 |
</span></span><span id="137" class="l"><a class="l" href="#137">137: </a><span class="php-comment"> * @throws Zend_Cache_Exception
|
|
|
229 |
</span></span><span id="138" class="l"><a class="l" href="#138">138: </a><span class="php-comment"> * @return boolean True if no problem
|
|
|
230 |
</span></span><span id="139" class="l"><a class="l" href="#139">139: </a><span class="php-comment"> */</span>
|
|
|
231 |
</span><span id="140" class="l"><a class="l" href="#140">140: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_sauver" href="#_sauver">sauver</a>(<span class="php-var">$donnees</span>, <span class="php-var">$id</span>, <span class="php-var">$tags</span> = <span class="php-keyword1">array</span>(), <span class="php-var">$duree_vie_specifique</span> = <span class="php-keyword1">false</span>) {
|
|
|
232 |
</span><span id="141" class="l"><a class="l" href="#141">141: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
233 |
</span><span id="142" class="l"><a class="l" href="#142">142: </a>
|
|
|
234 |
</span><span id="143" class="l"><a class="l" href="#143">143: </a> <span class="php-comment">//FIXME : si l'extension n'est pas installée, le cache passe tout de même par cette fonction et s'arrête à cet endroit.</span>
|
|
|
235 |
</span><span id="144" class="l"><a class="l" href="#144">144: </a> <span class="php-var">$donnees</span> = @<span class="php-keyword2">sqlite_escape_string</span>(<span class="php-var">$donnees</span>);
|
|
|
236 |
</span><span id="145" class="l"><a class="l" href="#145">145: </a> <span class="php-var">$timestamp_courrant</span> = <span class="php-keyword2">time</span>();
|
|
|
237 |
</span><span id="146" class="l"><a class="l" href="#146">146: </a> <span class="php-var">$expiration</span> = <span class="php-var">$this</span>->Cache->getTimestampExpiration(<span class="php-var">$duree_vie_specifique</span>);
|
|
|
238 |
</span><span id="147" class="l"><a class="l" href="#147">147: </a>
|
|
|
239 |
</span><span id="148" class="l"><a class="l" href="#148">148: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">"DELETE FROM cache WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
240 |
</span><span id="149" class="l"><a class="l" href="#149">149: </a> <span class="php-var">$sql</span> = <span class="php-quote">"INSERT INTO cache (id, content, lastModified, expire) VALUES ('</span><span class="php-var">$id</span><span class="php-quote">', '</span><span class="php-var">$donnees</span><span class="php-quote">', </span><span class="php-var">$timestamp_courrant</span><span class="php-quote">, </span><span class="php-var">$expiration</span><span class="php-quote">)"</span>;
|
|
|
241 |
</span><span id="150" class="l"><a class="l" href="#150">150: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-var">$sql</span>);
|
|
|
242 |
</span><span id="151" class="l"><a class="l" href="#151">151: </a> <span class="php-keyword1">if</span> (!<span class="php-var">$resultat</span>) {
|
|
|
243 |
</span><span id="152" class="l"><a class="l" href="#152">152: </a> <span class="php-comment">// TODO : ajouter un log sauver() : impossible de stocker le cache d'id '$id'</span>
|
|
|
244 |
</span><span id="153" class="l"><a class="l" href="#153">153: </a> Debug::printr(<span class="php-quote">"sauver() : impossible de stocker le cache d'id '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
245 |
</span><span id="154" class="l"><a class="l" href="#154">154: </a> <span class="php-var">$resultat</span> = <span class="php-keyword1">false</span>;
|
|
|
246 |
</span><span id="155" class="l"><a class="l" href="#155">155: </a> } <span class="php-keyword1">else</span> {
|
|
|
247 |
</span><span id="156" class="l"><a class="l" href="#156">156: </a> <span class="php-var">$resultat</span> = <span class="php-keyword1">true</span>;
|
|
|
248 |
</span><span id="157" class="l"><a class="l" href="#157">157: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$tags</span> <span class="php-keyword1">as</span> <span class="php-var">$tag</span>) {
|
|
|
249 |
</span><span id="158" class="l"><a class="l" href="#158">158: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->enregisterTag(<span class="php-var">$id</span>, <span class="php-var">$tag</span>) && <span class="php-var">$resultat</span>;
|
|
|
250 |
</span><span id="159" class="l"><a class="l" href="#159">159: </a> }
|
|
|
251 |
</span><span id="160" class="l"><a class="l" href="#160">160: </a> }
|
|
|
252 |
</span><span id="161" class="l"><a class="l" href="#161">161: </a> <span class="php-keyword1">return</span> <span class="php-var">$resultat</span>;
|
|
|
253 |
</span><span id="162" class="l"><a class="l" href="#162">162: </a> }
|
|
|
254 |
</span><span id="163" class="l"><a class="l" href="#163">163: </a>
|
|
|
255 |
</span><span id="164" class="l"><a class="l" href="#164">164: </a> <span class="php-comment">/**
|
|
|
256 |
</span></span><span id="165" class="l"><a class="l" href="#165">165: </a><span class="php-comment"> * Remove a cache record
|
|
|
257 |
</span></span><span id="166" class="l"><a class="l" href="#166">166: </a><span class="php-comment"> *
|
|
|
258 |
</span></span><span id="167" class="l"><a class="l" href="#167">167: </a><span class="php-comment"> * @param string $id Cache id
|
|
|
259 |
</span></span><span id="168" class="l"><a class="l" href="#168">168: </a><span class="php-comment"> * @return boolean True if no problem
|
|
|
260 |
</span></span><span id="169" class="l"><a class="l" href="#169">169: </a><span class="php-comment"> */</span>
|
|
|
261 |
</span><span id="170" class="l"><a class="l" href="#170">170: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_supprimer" href="#_supprimer">supprimer</a>(<span class="php-var">$id</span>) {
|
|
|
262 |
</span><span id="171" class="l"><a class="l" href="#171">171: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
263 |
</span><span id="172" class="l"><a class="l" href="#172">172: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"SELECT COUNT(*) AS nbr FROM cache WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
264 |
</span><span id="173" class="l"><a class="l" href="#173">173: </a> <span class="php-var">$resultat_nbre</span> = @<span class="php-keyword2">sqlite_fetch_single</span>(<span class="php-var">$resultat</span>);
|
|
|
265 |
</span><span id="174" class="l"><a class="l" href="#174">174: </a> <span class="php-var">$suppression_cache</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"DELETE FROM cache WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
266 |
</span><span id="175" class="l"><a class="l" href="#175">175: </a> <span class="php-var">$suppression_tags</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"DELETE FROM tag WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
267 |
</span><span id="176" class="l"><a class="l" href="#176">176: </a> <span class="php-var">$this</span>->defragmenterAutomatiquement();
|
|
|
268 |
</span><span id="177" class="l"><a class="l" href="#177">177: </a> <span class="php-keyword1">return</span> (<span class="php-var">$resultat_nbre</span> && <span class="php-var">$suppression_cache</span> && <span class="php-var">$suppression_tags</span>);
|
|
|
269 |
</span><span id="178" class="l"><a class="l" href="#178">178: </a> }
|
|
|
270 |
</span><span id="179" class="l"><a class="l" href="#179">179: </a>
|
|
|
271 |
</span><span id="180" class="l"><a class="l" href="#180">180: </a> <span class="php-comment">/**
|
|
|
272 |
</span></span><span id="181" class="l"><a class="l" href="#181">181: </a><span class="php-comment"> * Clean some cache records
|
|
|
273 |
</span></span><span id="182" class="l"><a class="l" href="#182">182: </a><span class="php-comment"> *
|
|
|
274 |
</span></span><span id="183" class="l"><a class="l" href="#183">183: </a><span class="php-comment"> * Available modes are :
|
|
|
275 |
</span></span><span id="184" class="l"><a class="l" href="#184">184: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_ALL (default) => remove all cache entries ($tags is not used)
|
|
|
276 |
</span></span><span id="185" class="l"><a class="l" href="#185">185: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_OLD => remove too old cache entries ($tags is not used)
|
|
|
277 |
</span></span><span id="186" class="l"><a class="l" href="#186">186: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_MATCHING_TAG => remove cache entries matching all given tags
|
|
|
278 |
</span></span><span id="187" class="l"><a class="l" href="#187">187: </a><span class="php-comment"> * ($tags can be an array of strings or a single string)
|
|
|
279 |
</span></span><span id="188" class="l"><a class="l" href="#188">188: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_NOT_MATCHING_TAG => remove cache entries not {matching one of the given tags}
|
|
|
280 |
</span></span><span id="189" class="l"><a class="l" href="#189">189: </a><span class="php-comment"> * ($tags can be an array of strings or a single string)
|
|
|
281 |
</span></span><span id="190" class="l"><a class="l" href="#190">190: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_MATCHING_ANY_TAG => remove cache entries matching any given tags
|
|
|
282 |
</span></span><span id="191" class="l"><a class="l" href="#191">191: </a><span class="php-comment"> * ($tags can be an array of strings or a single string)
|
|
|
283 |
</span></span><span id="192" class="l"><a class="l" href="#192">192: </a><span class="php-comment"> *
|
|
|
284 |
</span></span><span id="193" class="l"><a class="l" href="#193">193: </a><span class="php-comment"> * @param string $mode Clean mode
|
|
|
285 |
</span></span><span id="194" class="l"><a class="l" href="#194">194: </a><span class="php-comment"> * @param array $tags Array of tags
|
|
|
286 |
</span></span><span id="195" class="l"><a class="l" href="#195">195: </a><span class="php-comment"> * @return boolean True if no problem
|
|
|
287 |
</span></span><span id="196" class="l"><a class="l" href="#196">196: </a><span class="php-comment"> */</span>
|
|
|
288 |
</span><span id="197" class="l"><a class="l" href="#197">197: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_nettoyer" href="#_nettoyer">nettoyer</a>(<span class="php-var">$mode</span> = Cache::NETTOYAGE_MODE_TOUS, <span class="php-var">$tags</span> = <span class="php-keyword1">array</span>()) {
|
|
|
289 |
</span><span id="198" class="l"><a class="l" href="#198">198: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
290 |
</span><span id="199" class="l"><a class="l" href="#199">199: </a> <span class="php-var">$retour</span> = <span class="php-var">$this</span>->nettoyerSqlite(<span class="php-var">$mode</span>, <span class="php-var">$tags</span>);
|
|
|
291 |
</span><span id="200" class="l"><a class="l" href="#200">200: </a> <span class="php-var">$this</span>->defragmenterAutomatiquement();
|
|
|
292 |
</span><span id="201" class="l"><a class="l" href="#201">201: </a> <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
|
|
|
293 |
</span><span id="202" class="l"><a class="l" href="#202">202: </a> }
|
|
|
294 |
</span><span id="203" class="l"><a class="l" href="#203">203: </a>
|
|
|
295 |
</span><span id="204" class="l"><a class="l" href="#204">204: </a> <span class="php-comment">/**
|
|
|
296 |
</span></span><span id="205" class="l"><a class="l" href="#205">205: </a><span class="php-comment"> * Return an array of stored cache ids
|
|
|
297 |
</span></span><span id="206" class="l"><a class="l" href="#206">206: </a><span class="php-comment"> *
|
|
|
298 |
</span></span><span id="207" class="l"><a class="l" href="#207">207: </a><span class="php-comment"> * @return array array of stored cache ids (string)
|
|
|
299 |
</span></span><span id="208" class="l"><a class="l" href="#208">208: </a><span class="php-comment"> */</span>
|
|
|
300 |
</span><span id="209" class="l"><a class="l" href="#209">209: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getIds" href="#_getIds">getIds</a>() {
|
|
|
301 |
</span><span id="210" class="l"><a class="l" href="#210">210: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
302 |
</span><span id="211" class="l"><a class="l" href="#211">211: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">'SELECT id FROM cache WHERE (expire = 0 OR expire > '</span>.<span class="php-keyword2">time</span>().<span class="php-quote">')'</span>);
|
|
|
303 |
</span><span id="212" class="l"><a class="l" href="#212">212: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">array</span>();
|
|
|
304 |
</span><span id="213" class="l"><a class="l" href="#213">213: </a> <span class="php-keyword1">while</span> (<span class="php-var">$id</span> = @<span class="php-keyword2">sqlite_fetch_single</span>(<span class="php-var">$resultat</span>)) {
|
|
|
305 |
</span><span id="214" class="l"><a class="l" href="#214">214: </a> <span class="php-var">$retour</span>[] = <span class="php-var">$id</span>;
|
|
|
306 |
</span><span id="215" class="l"><a class="l" href="#215">215: </a> }
|
|
|
307 |
</span><span id="216" class="l"><a class="l" href="#216">216: </a> <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
|
|
|
308 |
</span><span id="217" class="l"><a class="l" href="#217">217: </a> }
|
|
|
309 |
</span><span id="218" class="l"><a class="l" href="#218">218: </a>
|
|
|
310 |
</span><span id="219" class="l"><a class="l" href="#219">219: </a> <span class="php-comment">/**
|
|
|
311 |
</span></span><span id="220" class="l"><a class="l" href="#220">220: </a><span class="php-comment"> * Return an array of stored tags
|
|
|
312 |
</span></span><span id="221" class="l"><a class="l" href="#221">221: </a><span class="php-comment"> *
|
|
|
313 |
</span></span><span id="222" class="l"><a class="l" href="#222">222: </a><span class="php-comment"> * @return array array of stored tags (string)
|
|
|
314 |
</span></span><span id="223" class="l"><a class="l" href="#223">223: </a><span class="php-comment"> */</span>
|
|
|
315 |
</span><span id="224" class="l"><a class="l" href="#224">224: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getTags" href="#_getTags">getTags</a>() {
|
|
|
316 |
</span><span id="225" class="l"><a class="l" href="#225">225: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
317 |
</span><span id="226" class="l"><a class="l" href="#226">226: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">'SELECT DISTINCT(name) AS name FROM tag'</span>);
|
|
|
318 |
</span><span id="227" class="l"><a class="l" href="#227">227: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">array</span>();
|
|
|
319 |
</span><span id="228" class="l"><a class="l" href="#228">228: </a> <span class="php-keyword1">while</span> (<span class="php-var">$id</span> = @<span class="php-keyword2">sqlite_fetch_single</span>(<span class="php-var">$resultat</span>)) {
|
|
|
320 |
</span><span id="229" class="l"><a class="l" href="#229">229: </a> <span class="php-var">$retour</span>[] = <span class="php-var">$id</span>;
|
|
|
321 |
</span><span id="230" class="l"><a class="l" href="#230">230: </a> }
|
|
|
322 |
</span><span id="231" class="l"><a class="l" href="#231">231: </a> <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
|
|
|
323 |
</span><span id="232" class="l"><a class="l" href="#232">232: </a> }
|
|
|
324 |
</span><span id="233" class="l"><a class="l" href="#233">233: </a>
|
|
|
325 |
</span><span id="234" class="l"><a class="l" href="#234">234: </a> <span class="php-comment">/**
|
|
|
326 |
</span></span><span id="235" class="l"><a class="l" href="#235">235: </a><span class="php-comment"> * Return an array of stored cache ids which match given tags
|
|
|
327 |
</span></span><span id="236" class="l"><a class="l" href="#236">236: </a><span class="php-comment"> *
|
|
|
328 |
</span></span><span id="237" class="l"><a class="l" href="#237">237: </a><span class="php-comment"> * In case of multiple tags, a logical AND is made between tags
|
|
|
329 |
</span></span><span id="238" class="l"><a class="l" href="#238">238: </a><span class="php-comment"> *
|
|
|
330 |
</span></span><span id="239" class="l"><a class="l" href="#239">239: </a><span class="php-comment"> * @param array $tags array of tags
|
|
|
331 |
</span></span><span id="240" class="l"><a class="l" href="#240">240: </a><span class="php-comment"> * @return array array of matching cache ids (string)
|
|
|
332 |
</span></span><span id="241" class="l"><a class="l" href="#241">241: </a><span class="php-comment"> */</span>
|
|
|
333 |
</span><span id="242" class="l"><a class="l" href="#242">242: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getIdsAvecLesTags" href="#_getIdsAvecLesTags">getIdsAvecLesTags</a>(<span class="php-var">$tags</span> = <span class="php-keyword1">array</span>()) {
|
|
|
334 |
</span><span id="243" class="l"><a class="l" href="#243">243: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
335 |
</span><span id="244" class="l"><a class="l" href="#244">244: </a> <span class="php-var">$premier</span> = <span class="php-keyword1">true</span>;
|
|
|
336 |
</span><span id="245" class="l"><a class="l" href="#245">245: </a> <span class="php-var">$ids</span> = <span class="php-keyword1">array</span>();
|
|
|
337 |
</span><span id="246" class="l"><a class="l" href="#246">246: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$tags</span> <span class="php-keyword1">as</span> <span class="php-var">$tag</span>) {
|
|
|
338 |
</span><span id="247" class="l"><a class="l" href="#247">247: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"SELECT DISTINCT(id) AS id FROM tag WHERE name='</span><span class="php-var">$tag</span><span class="php-quote">'"</span>);
|
|
|
339 |
</span><span id="248" class="l"><a class="l" href="#248">248: </a> <span class="php-keyword1">if</span> (<span class="php-var">$resultat</span>) {
|
|
|
340 |
</span><span id="249" class="l"><a class="l" href="#249">249: </a> <span class="php-var">$lignes</span> = @<span class="php-keyword2">sqlite_fetch_all</span>(<span class="php-var">$resultat</span>, SQLITE_ASSOC);
|
|
|
341 |
</span><span id="250" class="l"><a class="l" href="#250">250: </a> <span class="php-var">$ids_tmp</span> = <span class="php-keyword1">array</span>();
|
|
|
342 |
</span><span id="251" class="l"><a class="l" href="#251">251: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$lignes</span> <span class="php-keyword1">as</span> <span class="php-var">$ligne</span>) {
|
|
|
343 |
</span><span id="252" class="l"><a class="l" href="#252">252: </a> <span class="php-var">$ids_tmp</span>[] = <span class="php-var">$ligne</span>[<span class="php-quote">'id'</span>];
|
|
|
344 |
</span><span id="253" class="l"><a class="l" href="#253">253: </a> }
|
|
|
345 |
</span><span id="254" class="l"><a class="l" href="#254">254: </a> <span class="php-keyword1">if</span> (<span class="php-var">$premier</span>) {
|
|
|
346 |
</span><span id="255" class="l"><a class="l" href="#255">255: </a> <span class="php-var">$ids</span> = <span class="php-var">$ids_tmp</span>;
|
|
|
347 |
</span><span id="256" class="l"><a class="l" href="#256">256: </a> <span class="php-var">$premier</span> = <span class="php-keyword1">false</span>;
|
|
|
348 |
</span><span id="257" class="l"><a class="l" href="#257">257: </a> } <span class="php-keyword1">else</span> {
|
|
|
349 |
</span><span id="258" class="l"><a class="l" href="#258">258: </a> <span class="php-var">$ids</span> = <span class="php-keyword2">array_intersect</span>(<span class="php-var">$ids</span>, <span class="php-var">$ids_tmp</span>);
|
|
|
350 |
</span><span id="259" class="l"><a class="l" href="#259">259: </a> }
|
|
|
351 |
</span><span id="260" class="l"><a class="l" href="#260">260: </a> }
|
|
|
352 |
</span><span id="261" class="l"><a class="l" href="#261">261: </a> }
|
|
|
353 |
</span><span id="262" class="l"><a class="l" href="#262">262: </a>
|
|
|
354 |
</span><span id="263" class="l"><a class="l" href="#263">263: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">array</span>();
|
|
|
355 |
</span><span id="264" class="l"><a class="l" href="#264">264: </a> <span class="php-keyword1">if</span> (<span class="php-keyword2">count</span>(<span class="php-var">$ids</span>) > <span class="php-num">0</span>) {
|
|
|
356 |
</span><span id="265" class="l"><a class="l" href="#265">265: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$ids</span> <span class="php-keyword1">as</span> <span class="php-var">$id</span>) {
|
|
|
357 |
</span><span id="266" class="l"><a class="l" href="#266">266: </a> <span class="php-var">$retour</span>[] = <span class="php-var">$id</span>;
|
|
|
358 |
</span><span id="267" class="l"><a class="l" href="#267">267: </a> }
|
|
|
359 |
</span><span id="268" class="l"><a class="l" href="#268">268: </a> }
|
|
|
360 |
</span><span id="269" class="l"><a class="l" href="#269">269: </a> <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
|
|
|
361 |
</span><span id="270" class="l"><a class="l" href="#270">270: </a> }
|
|
|
362 |
</span><span id="271" class="l"><a class="l" href="#271">271: </a>
|
|
|
363 |
</span><span id="272" class="l"><a class="l" href="#272">272: </a> <span class="php-comment">/**
|
|
|
364 |
</span></span><span id="273" class="l"><a class="l" href="#273">273: </a><span class="php-comment"> * Return an array of stored cache ids which don't match given tags
|
|
|
365 |
</span></span><span id="274" class="l"><a class="l" href="#274">274: </a><span class="php-comment"> *
|
|
|
366 |
</span></span><span id="275" class="l"><a class="l" href="#275">275: </a><span class="php-comment"> * In case of multiple tags, a logical OR is made between tags
|
|
|
367 |
</span></span><span id="276" class="l"><a class="l" href="#276">276: </a><span class="php-comment"> *
|
|
|
368 |
</span></span><span id="277" class="l"><a class="l" href="#277">277: </a><span class="php-comment"> * @param array $tags array of tags
|
|
|
369 |
</span></span><span id="278" class="l"><a class="l" href="#278">278: </a><span class="php-comment"> * @return array array of not matching cache ids (string)
|
|
|
370 |
</span></span><span id="279" class="l"><a class="l" href="#279">279: </a><span class="php-comment"> */</span>
|
|
|
371 |
</span><span id="280" class="l"><a class="l" href="#280">280: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getIdsSansLesTags" href="#_getIdsSansLesTags">getIdsSansLesTags</a>(<span class="php-var">$tags</span> = <span class="php-keyword1">array</span>()) {
|
|
|
372 |
</span><span id="281" class="l"><a class="l" href="#281">281: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
373 |
</span><span id="282" class="l"><a class="l" href="#282">282: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">'SELECT id FROM cache'</span>);
|
|
|
374 |
</span><span id="283" class="l"><a class="l" href="#283">283: </a> <span class="php-var">$lignes</span> = @<span class="php-keyword2">sqlite_fetch_all</span>(<span class="php-var">$resultat</span>, SQLITE_ASSOC);
|
|
|
375 |
</span><span id="284" class="l"><a class="l" href="#284">284: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">array</span>();
|
|
|
376 |
</span><span id="285" class="l"><a class="l" href="#285">285: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$lignes</span> <span class="php-keyword1">as</span> <span class="php-var">$ligne</span>) {
|
|
|
377 |
</span><span id="286" class="l"><a class="l" href="#286">286: </a> <span class="php-var">$id</span> = <span class="php-var">$ligne</span>[<span class="php-quote">'id'</span>];
|
|
|
378 |
</span><span id="287" class="l"><a class="l" href="#287">287: </a> <span class="php-var">$correspondance</span> = <span class="php-keyword1">false</span>;
|
|
|
379 |
</span><span id="288" class="l"><a class="l" href="#288">288: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$tags</span> <span class="php-keyword1">as</span> <span class="php-var">$tag</span>) {
|
|
|
380 |
</span><span id="289" class="l"><a class="l" href="#289">289: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"SELECT COUNT(*) AS nbr FROM tag WHERE name = '</span><span class="php-var">$tag</span><span class="php-quote">' AND id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
381 |
</span><span id="290" class="l"><a class="l" href="#290">290: </a> <span class="php-keyword1">if</span> (<span class="php-var">$resultat</span>) {
|
|
|
382 |
</span><span id="291" class="l"><a class="l" href="#291">291: </a> <span class="php-var">$nbre</span> = (int) @<span class="php-keyword2">sqlite_fetch_single</span>(<span class="php-var">$resultat</span>);
|
|
|
383 |
</span><span id="292" class="l"><a class="l" href="#292">292: </a> <span class="php-keyword1">if</span> (<span class="php-var">$nbre</span> > <span class="php-num">0</span>) {
|
|
|
384 |
</span><span id="293" class="l"><a class="l" href="#293">293: </a> <span class="php-var">$correspondance</span> = <span class="php-keyword1">true</span>;
|
|
|
385 |
</span><span id="294" class="l"><a class="l" href="#294">294: </a> }
|
|
|
386 |
</span><span id="295" class="l"><a class="l" href="#295">295: </a> }
|
|
|
387 |
</span><span id="296" class="l"><a class="l" href="#296">296: </a> }
|
|
|
388 |
</span><span id="297" class="l"><a class="l" href="#297">297: </a> <span class="php-keyword1">if</span> (!<span class="php-var">$correspondance</span>) {
|
|
|
389 |
</span><span id="298" class="l"><a class="l" href="#298">298: </a> <span class="php-var">$retour</span>[] = <span class="php-var">$id</span>;
|
|
|
390 |
</span><span id="299" class="l"><a class="l" href="#299">299: </a> }
|
|
|
391 |
</span><span id="300" class="l"><a class="l" href="#300">300: </a> }
|
|
|
392 |
</span><span id="301" class="l"><a class="l" href="#301">301: </a> <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
|
|
|
393 |
</span><span id="302" class="l"><a class="l" href="#302">302: </a> }
|
|
|
394 |
</span><span id="303" class="l"><a class="l" href="#303">303: </a>
|
|
|
395 |
</span><span id="304" class="l"><a class="l" href="#304">304: </a> <span class="php-comment">/**
|
|
|
396 |
</span></span><span id="305" class="l"><a class="l" href="#305">305: </a><span class="php-comment"> * Return an array of stored cache ids which match any given tags
|
|
|
397 |
</span></span><span id="306" class="l"><a class="l" href="#306">306: </a><span class="php-comment"> *
|
|
|
398 |
</span></span><span id="307" class="l"><a class="l" href="#307">307: </a><span class="php-comment"> * In case of multiple tags, a logical AND is made between tags
|
|
|
399 |
</span></span><span id="308" class="l"><a class="l" href="#308">308: </a><span class="php-comment"> *
|
|
|
400 |
</span></span><span id="309" class="l"><a class="l" href="#309">309: </a><span class="php-comment"> * @param array $tags array of tags
|
|
|
401 |
</span></span><span id="310" class="l"><a class="l" href="#310">310: </a><span class="php-comment"> * @return array array of any matching cache ids (string)
|
|
|
402 |
</span></span><span id="311" class="l"><a class="l" href="#311">311: </a><span class="php-comment"> */</span>
|
|
|
403 |
</span><span id="312" class="l"><a class="l" href="#312">312: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getIdsAvecUnTag" href="#_getIdsAvecUnTag">getIdsAvecUnTag</a>(<span class="php-var">$tags</span> = <span class="php-keyword1">array</span>()) {
|
|
|
404 |
</span><span id="313" class="l"><a class="l" href="#313">313: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
405 |
</span><span id="314" class="l"><a class="l" href="#314">314: </a> <span class="php-var">$premier</span> = <span class="php-keyword1">true</span>;
|
|
|
406 |
</span><span id="315" class="l"><a class="l" href="#315">315: </a> <span class="php-var">$ids</span> = <span class="php-keyword1">array</span>();
|
|
|
407 |
</span><span id="316" class="l"><a class="l" href="#316">316: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$tags</span> <span class="php-keyword1">as</span> <span class="php-var">$tag</span>) {
|
|
|
408 |
</span><span id="317" class="l"><a class="l" href="#317">317: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"SELECT DISTINCT(id) AS id FROM tag WHERE name = '</span><span class="php-var">$tag</span><span class="php-quote">'"</span>);
|
|
|
409 |
</span><span id="318" class="l"><a class="l" href="#318">318: </a> <span class="php-keyword1">if</span> (<span class="php-var">$resultat</span>) {
|
|
|
410 |
</span><span id="319" class="l"><a class="l" href="#319">319: </a> <span class="php-var">$lignes</span> = @<span class="php-keyword2">sqlite_fetch_all</span>(<span class="php-var">$resultat</span>, SQLITE_ASSOC);
|
|
|
411 |
</span><span id="320" class="l"><a class="l" href="#320">320: </a> <span class="php-var">$ids_tmp</span> = <span class="php-keyword1">array</span>();
|
|
|
412 |
</span><span id="321" class="l"><a class="l" href="#321">321: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$lignes</span> <span class="php-keyword1">as</span> <span class="php-var">$ligne</span>) {
|
|
|
413 |
</span><span id="322" class="l"><a class="l" href="#322">322: </a> <span class="php-var">$ids_tmp</span>[] = <span class="php-var">$ligne</span>[<span class="php-quote">'id'</span>];
|
|
|
414 |
</span><span id="323" class="l"><a class="l" href="#323">323: </a> }
|
|
|
415 |
</span><span id="324" class="l"><a class="l" href="#324">324: </a> <span class="php-keyword1">if</span> (<span class="php-var">$premier</span>) {
|
|
|
416 |
</span><span id="325" class="l"><a class="l" href="#325">325: </a> <span class="php-var">$ids</span> = <span class="php-var">$ids_tmp</span>;
|
|
|
417 |
</span><span id="326" class="l"><a class="l" href="#326">326: </a> <span class="php-var">$premier</span> = <span class="php-keyword1">false</span>;
|
|
|
418 |
</span><span id="327" class="l"><a class="l" href="#327">327: </a> } <span class="php-keyword1">else</span> {
|
|
|
419 |
</span><span id="328" class="l"><a class="l" href="#328">328: </a> <span class="php-var">$ids</span> = <span class="php-keyword2">array_merge</span>(<span class="php-var">$ids</span>, <span class="php-var">$ids_tmp</span>);
|
|
|
420 |
</span><span id="329" class="l"><a class="l" href="#329">329: </a> }
|
|
|
421 |
</span><span id="330" class="l"><a class="l" href="#330">330: </a> }
|
|
|
422 |
</span><span id="331" class="l"><a class="l" href="#331">331: </a> }
|
|
|
423 |
</span><span id="332" class="l"><a class="l" href="#332">332: </a>
|
|
|
424 |
</span><span id="333" class="l"><a class="l" href="#333">333: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">array</span>();
|
|
|
425 |
</span><span id="334" class="l"><a class="l" href="#334">334: </a> <span class="php-keyword1">if</span> (<span class="php-keyword2">count</span>(<span class="php-var">$ids</span>) > <span class="php-num">0</span>) {
|
|
|
426 |
</span><span id="335" class="l"><a class="l" href="#335">335: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$ids</span> <span class="php-keyword1">as</span> <span class="php-var">$id</span>) {
|
|
|
427 |
</span><span id="336" class="l"><a class="l" href="#336">336: </a> <span class="php-var">$retour</span>[] = <span class="php-var">$id</span>;
|
|
|
428 |
</span><span id="337" class="l"><a class="l" href="#337">337: </a> }
|
|
|
429 |
</span><span id="338" class="l"><a class="l" href="#338">338: </a> }
|
|
|
430 |
</span><span id="339" class="l"><a class="l" href="#339">339: </a> <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
|
|
|
431 |
</span><span id="340" class="l"><a class="l" href="#340">340: </a> }
|
|
|
432 |
</span><span id="341" class="l"><a class="l" href="#341">341: </a>
|
|
|
433 |
</span><span id="342" class="l"><a class="l" href="#342">342: </a> <span class="php-comment">/**
|
|
|
434 |
</span></span><span id="343" class="l"><a class="l" href="#343">343: </a><span class="php-comment"> * Return the filling percentage of the backend storage
|
|
|
435 |
</span></span><span id="344" class="l"><a class="l" href="#344">344: </a><span class="php-comment"> *
|
|
|
436 |
</span></span><span id="345" class="l"><a class="l" href="#345">345: </a><span class="php-comment"> * @throws Zend_Cache_Exception
|
|
|
437 |
</span></span><span id="346" class="l"><a class="l" href="#346">346: </a><span class="php-comment"> * @return int integer between 0 and 100
|
|
|
438 |
</span></span><span id="347" class="l"><a class="l" href="#347">347: </a><span class="php-comment"> */</span>
|
|
|
439 |
</span><span id="348" class="l"><a class="l" href="#348">348: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getPourcentageRemplissage" href="#_getPourcentageRemplissage">getPourcentageRemplissage</a>() {
|
|
|
440 |
</span><span id="349" class="l"><a class="l" href="#349">349: </a> <span class="php-var">$dossier</span> = <span class="php-keyword2">dirname</span>(<span class="php-var">$this</span>->options[<span class="php-quote">'stockage_chemin'</span>]);
|
|
|
441 |
</span><span id="350" class="l"><a class="l" href="#350">350: </a> <span class="php-var">$libre</span> = <span class="php-keyword2">disk_free_space</span>(<span class="php-var">$dossier</span>);
|
|
|
442 |
</span><span id="351" class="l"><a class="l" href="#351">351: </a> <span class="php-var">$total</span> = <span class="php-keyword2">disk_total_space</span>(<span class="php-var">$dossier</span>);
|
|
|
443 |
</span><span id="352" class="l"><a class="l" href="#352">352: </a>
|
|
|
444 |
</span><span id="353" class="l"><a class="l" href="#353">353: </a> <span class="php-var">$pourcentage</span> = <span class="php-num">0</span>;
|
|
|
445 |
</span><span id="354" class="l"><a class="l" href="#354">354: </a> <span class="php-keyword1">if</span> (<span class="php-var">$total</span> == <span class="php-num">0</span>) {
|
|
|
446 |
</span><span id="355" class="l"><a class="l" href="#355">355: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-quote">"Impossible d'utiliser la fonction disk_total_space"</span>, E_USER_WARNING);
|
|
|
447 |
</span><span id="356" class="l"><a class="l" href="#356">356: </a> } <span class="php-keyword1">else</span> {
|
|
|
448 |
</span><span id="357" class="l"><a class="l" href="#357">357: </a> <span class="php-var">$pourcentage</span> = (<span class="php-var">$libre</span> >= <span class="php-var">$total</span>) ? <span class="php-num">100</span> : ((int) (<span class="php-num">100</span>. * (<span class="php-var">$total</span> - <span class="php-var">$libre</span>) / <span class="php-var">$total</span>));
|
|
|
449 |
</span><span id="358" class="l"><a class="l" href="#358">358: </a> }
|
|
|
450 |
</span><span id="359" class="l"><a class="l" href="#359">359: </a> <span class="php-keyword1">return</span> <span class="php-var">$pourcentage</span>;
|
|
|
451 |
</span><span id="360" class="l"><a class="l" href="#360">360: </a> }
|
|
|
452 |
</span><span id="361" class="l"><a class="l" href="#361">361: </a>
|
|
|
453 |
</span><span id="362" class="l"><a class="l" href="#362">362: </a> <span class="php-comment">/**
|
|
|
454 |
</span></span><span id="363" class="l"><a class="l" href="#363">363: </a><span class="php-comment"> * Return an array of metadatas for the given cache id
|
|
|
455 |
</span></span><span id="364" class="l"><a class="l" href="#364">364: </a><span class="php-comment"> *
|
|
|
456 |
</span></span><span id="365" class="l"><a class="l" href="#365">365: </a><span class="php-comment"> * The array must include these keys :
|
|
|
457 |
</span></span><span id="366" class="l"><a class="l" href="#366">366: </a><span class="php-comment"> * - expire : the expire timestamp
|
|
|
458 |
</span></span><span id="367" class="l"><a class="l" href="#367">367: </a><span class="php-comment"> * - tags : a string array of tags
|
|
|
459 |
</span></span><span id="368" class="l"><a class="l" href="#368">368: </a><span class="php-comment"> * - mtime : timestamp of last modification time
|
|
|
460 |
</span></span><span id="369" class="l"><a class="l" href="#369">369: </a><span class="php-comment"> *
|
|
|
461 |
</span></span><span id="370" class="l"><a class="l" href="#370">370: </a><span class="php-comment"> * @param string $id cache id
|
|
|
462 |
</span></span><span id="371" class="l"><a class="l" href="#371">371: </a><span class="php-comment"> * @return array array of metadatas (false if the cache id is not found)
|
|
|
463 |
</span></span><span id="372" class="l"><a class="l" href="#372">372: </a><span class="php-comment"> */</span>
|
|
|
464 |
</span><span id="373" class="l"><a class="l" href="#373">373: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getMetadonnees" href="#_getMetadonnees">getMetadonnees</a>(<span class="php-var">$id</span>) {
|
|
|
465 |
</span><span id="374" class="l"><a class="l" href="#374">374: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
466 |
</span><span id="375" class="l"><a class="l" href="#375">375: </a> <span class="php-var">$tags</span> = <span class="php-keyword1">array</span>();
|
|
|
467 |
</span><span id="376" class="l"><a class="l" href="#376">376: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"SELECT name FROM tag WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
468 |
</span><span id="377" class="l"><a class="l" href="#377">377: </a> <span class="php-keyword1">if</span> (<span class="php-var">$resultat</span>) {
|
|
|
469 |
</span><span id="378" class="l"><a class="l" href="#378">378: </a> <span class="php-var">$lignes</span> = @<span class="php-keyword2">sqlite_fetch_all</span>(<span class="php-var">$resultat</span>, SQLITE_ASSOC);
|
|
|
470 |
</span><span id="379" class="l"><a class="l" href="#379">379: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$lignes</span> <span class="php-keyword1">as</span> <span class="php-var">$ligne</span>) {
|
|
|
471 |
</span><span id="380" class="l"><a class="l" href="#380">380: </a> <span class="php-var">$tags</span>[] = <span class="php-var">$ligne</span>[<span class="php-quote">'name'</span>];
|
|
|
472 |
</span><span id="381" class="l"><a class="l" href="#381">381: </a> }
|
|
|
473 |
</span><span id="382" class="l"><a class="l" href="#382">382: </a> }
|
|
|
474 |
</span><span id="383" class="l"><a class="l" href="#383">383: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"SELECT lastModified, expire FROM cache WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
475 |
</span><span id="384" class="l"><a class="l" href="#384">384: </a> <span class="php-keyword1">if</span> (<span class="php-var">$resultat</span>) {
|
|
|
476 |
</span><span id="385" class="l"><a class="l" href="#385">385: </a> <span class="php-var">$ligne</span> = @<span class="php-keyword2">sqlite_fetch_array</span>(<span class="php-var">$resultat</span>, SQLITE_ASSOC);
|
|
|
477 |
</span><span id="386" class="l"><a class="l" href="#386">386: </a> <span class="php-var">$resultat</span> = <span class="php-keyword1">array</span>(
|
|
|
478 |
</span><span id="387" class="l"><a class="l" href="#387">387: </a> <span class="php-quote">'tags'</span> => <span class="php-var">$tags</span>,
|
|
|
479 |
</span><span id="388" class="l"><a class="l" href="#388">388: </a> <span class="php-quote">'mtime'</span> => <span class="php-var">$ligne</span>[<span class="php-quote">'lastModified'</span>],
|
|
|
480 |
</span><span id="389" class="l"><a class="l" href="#389">389: </a> <span class="php-quote">'expiration'</span> => <span class="php-var">$ligne</span>[<span class="php-quote">'expire'</span>]);
|
|
|
481 |
</span><span id="390" class="l"><a class="l" href="#390">390: </a> } <span class="php-keyword1">else</span> {
|
|
|
482 |
</span><span id="391" class="l"><a class="l" href="#391">391: </a> <span class="php-var">$resultat</span> = <span class="php-keyword1">false</span>;
|
|
|
483 |
</span><span id="392" class="l"><a class="l" href="#392">392: </a> }
|
|
|
484 |
</span><span id="393" class="l"><a class="l" href="#393">393: </a> <span class="php-keyword1">return</span> <span class="php-var">$resultat</span>;
|
|
|
485 |
</span><span id="394" class="l"><a class="l" href="#394">394: </a> }
|
|
|
486 |
</span><span id="395" class="l"><a class="l" href="#395">395: </a>
|
|
|
487 |
</span><span id="396" class="l"><a class="l" href="#396">396: </a> <span class="php-comment">/**
|
|
|
488 |
</span></span><span id="397" class="l"><a class="l" href="#397">397: </a><span class="php-comment"> * Give (if possible) an extra lifetime to the given cache id
|
|
|
489 |
</span></span><span id="398" class="l"><a class="l" href="#398">398: </a><span class="php-comment"> *
|
|
|
490 |
</span></span><span id="399" class="l"><a class="l" href="#399">399: </a><span class="php-comment"> * @param string $id cache id
|
|
|
491 |
</span></span><span id="400" class="l"><a class="l" href="#400">400: </a><span class="php-comment"> * @param int $extraLifetime
|
|
|
492 |
</span></span><span id="401" class="l"><a class="l" href="#401">401: </a><span class="php-comment"> * @return boolean true if ok
|
|
|
493 |
</span></span><span id="402" class="l"><a class="l" href="#402">402: </a><span class="php-comment"> */</span>
|
|
|
494 |
</span><span id="403" class="l"><a class="l" href="#403">403: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_ajouterSupplementDureeDeVie" href="#_ajouterSupplementDureeDeVie">ajouterSupplementDureeDeVie</a>(<span class="php-var">$id</span>, <span class="php-var">$supplement_duree_de_vie</span>) {
|
|
|
495 |
</span><span id="404" class="l"><a class="l" href="#404">404: </a> <span class="php-var">$this</span>->verifierEtCreerStructureBdd();
|
|
|
496 |
</span><span id="405" class="l"><a class="l" href="#405">405: </a> <span class="php-var">$augmentation</span> = <span class="php-keyword1">false</span>;
|
|
|
497 |
</span><span id="406" class="l"><a class="l" href="#406">406: </a> <span class="php-var">$requete</span> = <span class="php-quote">"SELECT expire FROM cache WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">' AND (expire = 0 OR expire > "</span>.<span class="php-keyword2">time</span>().<span class="php-quote">')'</span>;
|
|
|
498 |
</span><span id="407" class="l"><a class="l" href="#407">407: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-var">$requete</span>);
|
|
|
499 |
</span><span id="408" class="l"><a class="l" href="#408">408: </a> <span class="php-keyword1">if</span> (<span class="php-var">$resultat</span>) {
|
|
|
500 |
</span><span id="409" class="l"><a class="l" href="#409">409: </a> <span class="php-var">$expiration</span> = @<span class="php-keyword2">sqlite_fetch_single</span>(<span class="php-var">$resultat</span>);
|
|
|
501 |
</span><span id="410" class="l"><a class="l" href="#410">410: </a> <span class="php-var">$nouvelle_expiration</span> = <span class="php-var">$expiration</span> + <span class="php-var">$supplement_duree_de_vie</span>;
|
|
|
502 |
</span><span id="411" class="l"><a class="l" href="#411">411: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">'UPDATE cache SET lastModified = '</span>.<span class="php-keyword2">time</span>().<span class="php-quote">", expire = </span><span class="php-var">$nouvelle_expiration</span><span class="php-quote"> WHERE id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>);
|
|
|
503 |
</span><span id="412" class="l"><a class="l" href="#412">412: </a> <span class="php-var">$augmentation</span> = (<span class="php-var">$resultat</span>) ? <span class="php-keyword1">true</span> : <span class="php-keyword1">false</span>;
|
|
|
504 |
</span><span id="413" class="l"><a class="l" href="#413">413: </a> }
|
|
|
505 |
</span><span id="414" class="l"><a class="l" href="#414">414: </a> <span class="php-keyword1">return</span> <span class="php-var">$augmentation</span>;
|
|
|
506 |
</span><span id="415" class="l"><a class="l" href="#415">415: </a> }
|
|
|
507 |
</span><span id="416" class="l"><a class="l" href="#416">416: </a>
|
|
|
508 |
</span><span id="417" class="l"><a class="l" href="#417">417: </a> <span class="php-comment">/**
|
|
|
509 |
</span></span><span id="418" class="l"><a class="l" href="#418">418: </a><span class="php-comment"> * Return the connection resource
|
|
|
510 |
</span></span><span id="419" class="l"><a class="l" href="#419">419: </a><span class="php-comment"> *
|
|
|
511 |
</span></span><span id="420" class="l"><a class="l" href="#420">420: </a><span class="php-comment"> * If we are not connected, the connection is made
|
|
|
512 |
</span></span><span id="421" class="l"><a class="l" href="#421">421: </a><span class="php-comment"> *
|
|
|
513 |
</span></span><span id="422" class="l"><a class="l" href="#422">422: </a><span class="php-comment"> * @throws Zend_Cache_Exception
|
|
|
514 |
</span></span><span id="423" class="l"><a class="l" href="#423">423: </a><span class="php-comment"> * @return resource Connection resource
|
|
|
515 |
</span></span><span id="424" class="l"><a class="l" href="#424">424: </a><span class="php-comment"> */</span>
|
|
|
516 |
</span><span id="425" class="l"><a class="l" href="#425">425: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_getConnexion" href="#_getConnexion">getConnexion</a>() {
|
|
|
517 |
</span><span id="426" class="l"><a class="l" href="#426">426: </a> <span class="php-keyword1">if</span> (!<span class="php-keyword2">is_resource</span>(<span class="php-var">$this</span>->bdd)) {
|
|
|
518 |
</span><span id="427" class="l"><a class="l" href="#427">427: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->options[<span class="php-quote">'stockage_chemin'</span>] === <span class="php-keyword1">null</span>) {
|
|
|
519 |
</span><span id="428" class="l"><a class="l" href="#428">428: </a> <span class="php-var">$e</span> = <span class="php-quote">"L'emplacement du chemin vers le fichier de la base de données SQLite n'a pas été défini"</span>;
|
|
|
520 |
</span><span id="429" class="l"><a class="l" href="#429">429: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_ERROR);
|
|
|
521 |
</span><span id="430" class="l"><a class="l" href="#430">430: </a> } <span class="php-keyword1">else</span> {
|
|
|
522 |
</span><span id="431" class="l"><a class="l" href="#431">431: </a> <span class="php-var">$this</span>->bdd = <span class="php-keyword2">sqlite_open</span>(<span class="php-var">$this</span>->options[<span class="php-quote">'stockage_chemin'</span>]);
|
|
|
523 |
</span><span id="432" class="l"><a class="l" href="#432">432: </a> <span class="php-keyword1">if</span> (!(<span class="php-keyword2">is_resource</span>(<span class="php-var">$this</span>->bdd))) {
|
|
|
524 |
</span><span id="433" class="l"><a class="l" href="#433">433: </a> <span class="php-var">$e</span> = <span class="php-quote">"Impossible d'ouvrir le fichier '"</span>.<span class="php-var">$this</span>->options[<span class="php-quote">'stockage_chemin'</span>].<span class="php-quote">"' de la base de données SQLite."</span>;
|
|
|
525 |
</span><span id="434" class="l"><a class="l" href="#434">434: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_ERROR);
|
|
|
526 |
</span><span id="435" class="l"><a class="l" href="#435">435: </a> <span class="php-var">$this</span>->bdd = <span class="php-keyword1">null</span>;
|
|
|
527 |
</span><span id="436" class="l"><a class="l" href="#436">436: </a> }
|
|
|
528 |
</span><span id="437" class="l"><a class="l" href="#437">437: </a> }
|
|
|
529 |
</span><span id="438" class="l"><a class="l" href="#438">438: </a> }
|
|
|
530 |
</span><span id="439" class="l"><a class="l" href="#439">439: </a> <span class="php-keyword1">return</span> <span class="php-var">$this</span>->bdd;
|
|
|
531 |
</span><span id="440" class="l"><a class="l" href="#440">440: </a> }
|
|
|
532 |
</span><span id="441" class="l"><a class="l" href="#441">441: </a>
|
|
|
533 |
</span><span id="442" class="l"><a class="l" href="#442">442: </a> <span class="php-comment">/**
|
|
|
534 |
</span></span><span id="443" class="l"><a class="l" href="#443">443: </a><span class="php-comment"> * Execute une requête SQL sans afficher de messages d'erreur.
|
|
|
535 |
</span></span><span id="444" class="l"><a class="l" href="#444">444: </a><span class="php-comment"> *
|
|
|
536 |
</span></span><span id="445" class="l"><a class="l" href="#445">445: </a><span class="php-comment"> * @param string $requete requête SQL
|
|
|
537 |
</span></span><span id="446" class="l"><a class="l" href="#446">446: </a><span class="php-comment"> * @return mixed|false resultats de la requête
|
|
|
538 |
</span></span><span id="447" class="l"><a class="l" href="#447">447: </a><span class="php-comment"> */</span>
|
|
|
539 |
</span><span id="448" class="l"><a class="l" href="#448">448: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_requeter" href="#_requeter">requeter</a>(<span class="php-var">$requete</span>) {
|
|
|
540 |
</span><span id="449" class="l"><a class="l" href="#449">449: </a> <span class="php-var">$bdd</span> = <span class="php-var">$this</span>->getConnexion();
|
|
|
541 |
</span><span id="450" class="l"><a class="l" href="#450">450: </a> <span class="php-comment">//Debug::printr($requete);</span>
|
|
|
542 |
</span><span id="451" class="l"><a class="l" href="#451">451: </a> <span class="php-var">$resultat</span> = (<span class="php-keyword2">is_resource</span>(<span class="php-var">$bdd</span>)) ? @<span class="php-keyword2">sqlite_query</span>(<span class="php-var">$bdd</span>, <span class="php-var">$requete</span>, SQLITE_ASSOC, <span class="php-var">$e_sqlite</span>) : <span class="php-keyword1">false</span>;
|
|
|
543 |
</span><span id="452" class="l"><a class="l" href="#452">452: </a> <span class="php-keyword1">if</span> (<span class="php-keyword2">is_resource</span>(<span class="php-var">$bdd</span>) && ! <span class="php-var">$resultat</span>) {
|
|
|
544 |
</span><span id="453" class="l"><a class="l" href="#453">453: </a> Debug::printr(<span class="php-quote">"Erreur SQLITE :\n</span><span class="php-var">$e_sqlite</span><span class="php-quote">\nPour la requête :\n</span><span class="php-var">$requete</span><span class="php-quote">\nRessource : </span><span class="php-var">$bdd</span><span class="php-quote">"</span>);
|
|
|
545 |
</span><span id="454" class="l"><a class="l" href="#454">454: </a> }
|
|
|
546 |
</span><span id="455" class="l"><a class="l" href="#455">455: </a> <span class="php-keyword1">return</span> <span class="php-var">$resultat</span>;
|
|
|
547 |
</span><span id="456" class="l"><a class="l" href="#456">456: </a> }
|
|
|
548 |
</span><span id="457" class="l"><a class="l" href="#457">457: </a>
|
|
|
549 |
</span><span id="458" class="l"><a class="l" href="#458">458: </a> <span class="php-comment">/**
|
|
|
550 |
</span></span><span id="459" class="l"><a class="l" href="#459">459: </a><span class="php-comment"> * Deal with the automatic vacuum process
|
|
|
551 |
</span></span><span id="460" class="l"><a class="l" href="#460">460: </a><span class="php-comment"> *
|
|
|
552 |
</span></span><span id="461" class="l"><a class="l" href="#461">461: </a><span class="php-comment"> * @return void
|
|
|
553 |
</span></span><span id="462" class="l"><a class="l" href="#462">462: </a><span class="php-comment"> */</span>
|
|
|
554 |
</span><span id="463" class="l"><a class="l" href="#463">463: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_defragmenterAutomatiquement" href="#_defragmenterAutomatiquement">defragmenterAutomatiquement</a>() {
|
|
|
555 |
</span><span id="464" class="l"><a class="l" href="#464">464: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->options[<span class="php-quote">'defragmentation_auto'</span>] > <span class="php-num">0</span>) {
|
|
|
556 |
</span><span id="465" class="l"><a class="l" href="#465">465: </a> <span class="php-var">$rand</span> = <span class="php-keyword2">rand</span>(<span class="php-num">1</span>, <span class="php-var">$this</span>->options[<span class="php-quote">'defragmentation_auto'</span>]);
|
|
|
557 |
</span><span id="466" class="l"><a class="l" href="#466">466: </a> <span class="php-keyword1">if</span> (<span class="php-var">$rand</span> == <span class="php-num">1</span>) {
|
|
|
558 |
</span><span id="467" class="l"><a class="l" href="#467">467: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'VACUUM'</span>);
|
|
|
559 |
</span><span id="468" class="l"><a class="l" href="#468">468: </a> @<span class="php-keyword2">sqlite_close</span>(<span class="php-var">$this</span>->getConnexion());
|
|
|
560 |
</span><span id="469" class="l"><a class="l" href="#469">469: </a> }
|
|
|
561 |
</span><span id="470" class="l"><a class="l" href="#470">470: </a> }
|
|
|
562 |
</span><span id="471" class="l"><a class="l" href="#471">471: </a> }
|
|
|
563 |
</span><span id="472" class="l"><a class="l" href="#472">472: </a>
|
|
|
564 |
</span><span id="473" class="l"><a class="l" href="#473">473: </a> <span class="php-comment">/**
|
|
|
565 |
</span></span><span id="474" class="l"><a class="l" href="#474">474: </a><span class="php-comment"> * Register a cache id with the given tag
|
|
|
566 |
</span></span><span id="475" class="l"><a class="l" href="#475">475: </a><span class="php-comment"> *
|
|
|
567 |
</span></span><span id="476" class="l"><a class="l" href="#476">476: </a><span class="php-comment"> * @param string $id Cache id
|
|
|
568 |
</span></span><span id="477" class="l"><a class="l" href="#477">477: </a><span class="php-comment"> * @param string $tag Tag
|
|
|
569 |
</span></span><span id="478" class="l"><a class="l" href="#478">478: </a><span class="php-comment"> * @return boolean True if no problem
|
|
|
570 |
</span></span><span id="479" class="l"><a class="l" href="#479">479: </a><span class="php-comment"> */</span>
|
|
|
571 |
</span><span id="480" class="l"><a class="l" href="#480">480: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_enregisterTag" href="#_enregisterTag">enregisterTag</a>(<span class="php-var">$id</span>, <span class="php-var">$tag</span>) {
|
|
|
572 |
</span><span id="481" class="l"><a class="l" href="#481">481: </a> <span class="php-var">$requete_suppression</span> = <span class="php-quote">"DELETE FROM tag WHERE name = '</span><span class="php-var">$tag</span><span class="php-quote">' AND id = '</span><span class="php-var">$id</span><span class="php-quote">'"</span>;
|
|
|
573 |
</span><span id="482" class="l"><a class="l" href="#482">482: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-var">$requete_suppression</span>);
|
|
|
574 |
</span><span id="483" class="l"><a class="l" href="#483">483: </a> <span class="php-var">$requete_insertion</span> = <span class="php-quote">"INSERT INTO tag(name,id) VALUES ('</span><span class="php-var">$tag</span><span class="php-quote">','</span><span class="php-var">$id</span><span class="php-quote">')"</span>;
|
|
|
575 |
</span><span id="484" class="l"><a class="l" href="#484">484: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-var">$requete_insertion</span>);
|
|
|
576 |
</span><span id="485" class="l"><a class="l" href="#485">485: </a> <span class="php-keyword1">if</span> (!<span class="php-var">$resultat</span>) {
|
|
|
577 |
</span><span id="486" class="l"><a class="l" href="#486">486: </a> <span class="php-comment">// TODO : ajouter un log -> impossible d'enregistrer le tag=$tag pour le cache id=$id");</span>
|
|
|
578 |
</span><span id="487" class="l"><a class="l" href="#487">487: </a> Debug::printr(<span class="php-quote">"Impossible d'enregistrer le tag=</span><span class="php-var">$tag</span><span class="php-quote"> pour le cache id=</span><span class="php-var">$id</span><span class="php-quote">"</span>);
|
|
|
579 |
</span><span id="488" class="l"><a class="l" href="#488">488: </a> }
|
|
|
580 |
</span><span id="489" class="l"><a class="l" href="#489">489: </a> <span class="php-keyword1">return</span> (<span class="php-var">$resultat</span>) ? <span class="php-keyword1">true</span> : <span class="php-keyword1">false</span>;
|
|
|
581 |
</span><span id="490" class="l"><a class="l" href="#490">490: </a> }
|
|
|
582 |
</span><span id="491" class="l"><a class="l" href="#491">491: </a>
|
|
|
583 |
</span><span id="492" class="l"><a class="l" href="#492">492: </a> <span class="php-comment">/**
|
|
|
584 |
</span></span><span id="493" class="l"><a class="l" href="#493">493: </a><span class="php-comment"> * Build the database structure
|
|
|
585 |
</span></span><span id="494" class="l"><a class="l" href="#494">494: </a><span class="php-comment"> *
|
|
|
586 |
</span></span><span id="495" class="l"><a class="l" href="#495">495: </a><span class="php-comment"> * @return false
|
|
|
587 |
</span></span><span id="496" class="l"><a class="l" href="#496">496: </a><span class="php-comment"> */</span>
|
|
|
588 |
</span><span id="497" class="l"><a class="l" href="#497">497: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_creerStructure" href="#_creerStructure">creerStructure</a>() {
|
|
|
589 |
</span><span id="498" class="l"><a class="l" href="#498">498: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'DROP INDEX IF EXISTS tag_id_index'</span>);
|
|
|
590 |
</span><span id="499" class="l"><a class="l" href="#499">499: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'DROP INDEX IF EXISTS tag_name_index'</span>);
|
|
|
591 |
</span><span id="500" class="l"><a class="l" href="#500">500: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'DROP INDEX IF EXISTS cache_id_expire_index'</span>);
|
|
|
592 |
</span><span id="501" class="l"><a class="l" href="#501">501: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'DROP TABLE IF EXISTS version'</span>);
|
|
|
593 |
</span><span id="502" class="l"><a class="l" href="#502">502: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'DROP TABLE IF EXISTS cache'</span>);
|
|
|
594 |
</span><span id="503" class="l"><a class="l" href="#503">503: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'DROP TABLE IF EXISTS tag'</span>);
|
|
|
595 |
</span><span id="504" class="l"><a class="l" href="#504">504: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'CREATE TABLE version (num INTEGER PRIMARY KEY)'</span>);
|
|
|
596 |
</span><span id="505" class="l"><a class="l" href="#505">505: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'CREATE TABLE cache(id TEXT PRIMARY KEY, content BLOB, lastModified INTEGER, expire INTEGER)'</span>);
|
|
|
597 |
</span><span id="506" class="l"><a class="l" href="#506">506: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'CREATE TABLE tag (name TEXT, id TEXT)'</span>);
|
|
|
598 |
</span><span id="507" class="l"><a class="l" href="#507">507: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'CREATE INDEX tag_id_index ON tag(id)'</span>);
|
|
|
599 |
</span><span id="508" class="l"><a class="l" href="#508">508: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'CREATE INDEX tag_name_index ON tag(name)'</span>);
|
|
|
600 |
</span><span id="509" class="l"><a class="l" href="#509">509: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'CREATE INDEX cache_id_expire_index ON cache(id, expire)'</span>);
|
|
|
601 |
</span><span id="510" class="l"><a class="l" href="#510">510: </a> <span class="php-var">$this</span>->requeter(<span class="php-quote">'INSERT INTO version (num) VALUES (1)'</span>);
|
|
|
602 |
</span><span id="511" class="l"><a class="l" href="#511">511: </a> }
|
|
|
603 |
</span><span id="512" class="l"><a class="l" href="#512">512: </a>
|
|
|
604 |
</span><span id="513" class="l"><a class="l" href="#513">513: </a> <span class="php-comment">/**
|
|
|
605 |
</span></span><span id="514" class="l"><a class="l" href="#514">514: </a><span class="php-comment"> * Check if the database structure is ok (with the good version)
|
|
|
606 |
</span></span><span id="515" class="l"><a class="l" href="#515">515: </a><span class="php-comment"> *
|
|
|
607 |
</span></span><span id="516" class="l"><a class="l" href="#516">516: </a><span class="php-comment"> * @return boolean True if ok
|
|
|
608 |
</span></span><span id="517" class="l"><a class="l" href="#517">517: </a><span class="php-comment"> */</span>
|
|
|
609 |
</span><span id="518" class="l"><a class="l" href="#518">518: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_verifierBddStructureVersion" href="#_verifierBddStructureVersion">verifierBddStructureVersion</a>() {
|
|
|
610 |
</span><span id="519" class="l"><a class="l" href="#519">519: </a> <span class="php-var">$version_ok</span> = <span class="php-keyword1">false</span>;
|
|
|
611 |
</span><span id="520" class="l"><a class="l" href="#520">520: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">'SELECT num FROM version'</span>);
|
|
|
612 |
</span><span id="521" class="l"><a class="l" href="#521">521: </a> <span class="php-keyword1">if</span> (<span class="php-var">$resultat</span>) {
|
|
|
613 |
</span><span id="522" class="l"><a class="l" href="#522">522: </a> <span class="php-var">$ligne</span> = @<span class="php-keyword2">sqlite_fetch_array</span>(<span class="php-var">$resultat</span>);
|
|
|
614 |
</span><span id="523" class="l"><a class="l" href="#523">523: </a> <span class="php-keyword1">if</span> (<span class="php-var">$ligne</span>) {
|
|
|
615 |
</span><span id="524" class="l"><a class="l" href="#524">524: </a> <span class="php-keyword1">if</span> (((int) <span class="php-var">$ligne</span>[<span class="php-quote">'num'</span>]) == <span class="php-num">1</span>) {
|
|
|
616 |
</span><span id="525" class="l"><a class="l" href="#525">525: </a> <span class="php-var">$version_ok</span> = <span class="php-keyword1">true</span>;
|
|
|
617 |
</span><span id="526" class="l"><a class="l" href="#526">526: </a> } <span class="php-keyword1">else</span> {
|
|
|
618 |
</span><span id="527" class="l"><a class="l" href="#527">527: </a> <span class="php-comment">// TODO : ajouter un log CacheSqlite::verifierBddStructureVersion() : vielle version de la structure de la base de données de cache détectée => le cache est entrain d'être supprimé</span>
|
|
|
619 |
</span><span id="528" class="l"><a class="l" href="#528">528: </a> }
|
|
|
620 |
</span><span id="529" class="l"><a class="l" href="#529">529: </a> }
|
|
|
621 |
</span><span id="530" class="l"><a class="l" href="#530">530: </a> }
|
|
|
622 |
</span><span id="531" class="l"><a class="l" href="#531">531: </a> <span class="php-keyword1">return</span> <span class="php-var">$version_ok</span>;
|
|
|
623 |
</span><span id="532" class="l"><a class="l" href="#532">532: </a> }
|
|
|
624 |
</span><span id="533" class="l"><a class="l" href="#533">533: </a>
|
|
|
625 |
</span><span id="534" class="l"><a class="l" href="#534">534: </a> <span class="php-comment">/**
|
|
|
626 |
</span></span><span id="535" class="l"><a class="l" href="#535">535: </a><span class="php-comment"> * Clean some cache records
|
|
|
627 |
</span></span><span id="536" class="l"><a class="l" href="#536">536: </a><span class="php-comment"> *
|
|
|
628 |
</span></span><span id="537" class="l"><a class="l" href="#537">537: </a><span class="php-comment"> * Available modes are :
|
|
|
629 |
</span></span><span id="538" class="l"><a class="l" href="#538">538: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_ALL (default) => remove all cache entries ($tags is not used)
|
|
|
630 |
</span></span><span id="539" class="l"><a class="l" href="#539">539: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_OLD => remove too old cache entries ($tags is not used)
|
|
|
631 |
</span></span><span id="540" class="l"><a class="l" href="#540">540: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_MATCHING_TAG => remove cache entries matching all given tags
|
|
|
632 |
</span></span><span id="541" class="l"><a class="l" href="#541">541: </a><span class="php-comment"> * ($tags can be an array of strings or a single string)
|
|
|
633 |
</span></span><span id="542" class="l"><a class="l" href="#542">542: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_NOT_MATCHING_TAG => remove cache entries not {matching one of the given tags}
|
|
|
634 |
</span></span><span id="543" class="l"><a class="l" href="#543">543: </a><span class="php-comment"> * ($tags can be an array of strings or a single string)
|
|
|
635 |
</span></span><span id="544" class="l"><a class="l" href="#544">544: </a><span class="php-comment"> * Zend_Cache::CLEANING_MODE_MATCHING_ANY_TAG => remove cache entries matching any given tags
|
|
|
636 |
</span></span><span id="545" class="l"><a class="l" href="#545">545: </a><span class="php-comment"> * ($tags can be an array of strings or a single string)
|
|
|
637 |
</span></span><span id="546" class="l"><a class="l" href="#546">546: </a><span class="php-comment"> *
|
|
|
638 |
</span></span><span id="547" class="l"><a class="l" href="#547">547: </a><span class="php-comment"> * @param string $mode Clean mode
|
|
|
639 |
</span></span><span id="548" class="l"><a class="l" href="#548">548: </a><span class="php-comment"> * @param array $tags Array of tags
|
|
|
640 |
</span></span><span id="549" class="l"><a class="l" href="#549">549: </a><span class="php-comment"> * @return boolean True if no problem
|
|
|
641 |
</span></span><span id="550" class="l"><a class="l" href="#550">550: </a><span class="php-comment"> */</span>
|
|
|
642 |
</span><span id="551" class="l"><a class="l" href="#551">551: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_nettoyerSqlite" href="#_nettoyerSqlite">nettoyerSqlite</a>(<span class="php-var">$mode</span> = Cache::NETTOYAGE_MODE_TOUS, <span class="php-var">$tags</span> = <span class="php-keyword1">array</span>()) {
|
|
|
643 |
</span><span id="552" class="l"><a class="l" href="#552">552: </a> <span class="php-var">$nettoyage_ok</span> = <span class="php-keyword1">false</span>;
|
|
|
644 |
</span><span id="553" class="l"><a class="l" href="#553">553: </a> <span class="php-keyword1">switch</span> (<span class="php-var">$mode</span>) {
|
|
|
645 |
</span><span id="554" class="l"><a class="l" href="#554">554: </a> <span class="php-keyword1">case</span> Cache::NETTOYAGE_MODE_TOUS:
|
|
|
646 |
</span><span id="555" class="l"><a class="l" href="#555">555: </a> <span class="php-var">$suppression_cache</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">'DELETE FROM cache'</span>);
|
|
|
647 |
</span><span id="556" class="l"><a class="l" href="#556">556: </a> <span class="php-var">$suppression_tag</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">'DELETE FROM tag'</span>);
|
|
|
648 |
</span><span id="557" class="l"><a class="l" href="#557">557: </a> <span class="php-var">$nettoyage_ok</span> = <span class="php-var">$suppression_cache</span> && <span class="php-var">$suppression_tag</span>;
|
|
|
649 |
</span><span id="558" class="l"><a class="l" href="#558">558: </a> <span class="php-keyword1">break</span>;
|
|
|
650 |
</span><span id="559" class="l"><a class="l" href="#559">559: </a> <span class="php-keyword1">case</span> Cache::NETTOYAGE_MODE_EXPIRATION:
|
|
|
651 |
</span><span id="560" class="l"><a class="l" href="#560">560: </a> <span class="php-var">$mktime</span> = <span class="php-keyword2">time</span>();
|
|
|
652 |
</span><span id="561" class="l"><a class="l" href="#561">561: </a> <span class="php-var">$suppression_tag</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"DELETE FROM tag WHERE id IN (SELECT id FROM cache WHERE expire > 0 AND expire <= </span><span class="php-var">$mktime</span><span class="php-quote">)"</span>);
|
|
|
653 |
</span><span id="562" class="l"><a class="l" href="#562">562: </a> <span class="php-var">$suppression_cache</span> = <span class="php-var">$this</span>->requeter(<span class="php-quote">"DELETE FROM cache WHERE expire > 0 AND expire <= </span><span class="php-var">$mktime</span><span class="php-quote">"</span>);
|
|
|
654 |
</span><span id="563" class="l"><a class="l" href="#563">563: </a> <span class="php-keyword1">return</span> <span class="php-var">$suppression_tag</span> && <span class="php-var">$suppression_cache</span>;
|
|
|
655 |
</span><span id="564" class="l"><a class="l" href="#564">564: </a> <span class="php-keyword1">break</span>;
|
|
|
656 |
</span><span id="565" class="l"><a class="l" href="#565">565: </a> <span class="php-keyword1">case</span> Cache::NETTOYAGE_MODE_AVEC_LES_TAGS:
|
|
|
657 |
</span><span id="566" class="l"><a class="l" href="#566">566: </a> <span class="php-var">$ids</span> = <span class="php-var">$this</span>->getIdsAvecLesTags(<span class="php-var">$tags</span>);
|
|
|
658 |
</span><span id="567" class="l"><a class="l" href="#567">567: </a> <span class="php-var">$resultat</span> = <span class="php-keyword1">true</span>;
|
|
|
659 |
</span><span id="568" class="l"><a class="l" href="#568">568: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$ids</span> <span class="php-keyword1">as</span> <span class="php-var">$id</span>) {
|
|
|
660 |
</span><span id="569" class="l"><a class="l" href="#569">569: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->supprimer(<span class="php-var">$id</span>) && <span class="php-var">$resultat</span>;
|
|
|
661 |
</span><span id="570" class="l"><a class="l" href="#570">570: </a> }
|
|
|
662 |
</span><span id="571" class="l"><a class="l" href="#571">571: </a> <span class="php-keyword1">return</span> <span class="php-var">$resultat</span>;
|
|
|
663 |
</span><span id="572" class="l"><a class="l" href="#572">572: </a> <span class="php-keyword1">break</span>;
|
|
|
664 |
</span><span id="573" class="l"><a class="l" href="#573">573: </a> <span class="php-keyword1">case</span> Cache::NETTOYAGE_MODE_SANS_LES_TAGS:
|
|
|
665 |
</span><span id="574" class="l"><a class="l" href="#574">574: </a> <span class="php-var">$ids</span> = <span class="php-var">$this</span>->getIdsSansLesTags(<span class="php-var">$tags</span>);
|
|
|
666 |
</span><span id="575" class="l"><a class="l" href="#575">575: </a> <span class="php-var">$resultat</span> = <span class="php-keyword1">true</span>;
|
|
|
667 |
</span><span id="576" class="l"><a class="l" href="#576">576: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$ids</span> <span class="php-keyword1">as</span> <span class="php-var">$id</span>) {
|
|
|
668 |
</span><span id="577" class="l"><a class="l" href="#577">577: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->supprimer(<span class="php-var">$id</span>) && <span class="php-var">$resultat</span>;
|
|
|
669 |
</span><span id="578" class="l"><a class="l" href="#578">578: </a> }
|
|
|
670 |
</span><span id="579" class="l"><a class="l" href="#579">579: </a> <span class="php-keyword1">return</span> <span class="php-var">$resultat</span>;
|
|
|
671 |
</span><span id="580" class="l"><a class="l" href="#580">580: </a> <span class="php-keyword1">break</span>;
|
|
|
672 |
</span><span id="581" class="l"><a class="l" href="#581">581: </a> <span class="php-keyword1">case</span> Cache::NETTOYAGE_MODE_AVEC_UN_TAG:
|
|
|
673 |
</span><span id="582" class="l"><a class="l" href="#582">582: </a> <span class="php-var">$ids</span> = <span class="php-var">$this</span>->getIdsAvecUnTag(<span class="php-var">$tags</span>);
|
|
|
674 |
</span><span id="583" class="l"><a class="l" href="#583">583: </a> <span class="php-var">$resultat</span> = <span class="php-keyword1">true</span>;
|
|
|
675 |
</span><span id="584" class="l"><a class="l" href="#584">584: </a> <span class="php-keyword1">foreach</span> (<span class="php-var">$ids</span> <span class="php-keyword1">as</span> <span class="php-var">$id</span>) {
|
|
|
676 |
</span><span id="585" class="l"><a class="l" href="#585">585: </a> <span class="php-var">$resultat</span> = <span class="php-var">$this</span>->supprimer(<span class="php-var">$id</span>) && <span class="php-var">$resultat</span>;
|
|
|
677 |
</span><span id="586" class="l"><a class="l" href="#586">586: </a> }
|
|
|
678 |
</span><span id="587" class="l"><a class="l" href="#587">587: </a> <span class="php-keyword1">return</span> <span class="php-var">$resultat</span>;
|
|
|
679 |
</span><span id="588" class="l"><a class="l" href="#588">588: </a> <span class="php-keyword1">break</span>;
|
|
|
680 |
</span><span id="589" class="l"><a class="l" href="#589">589: </a> <span class="php-keyword1">default</span>:
|
|
|
681 |
</span><span id="590" class="l"><a class="l" href="#590">590: </a> <span class="php-keyword1">break</span>;
|
|
|
682 |
</span><span id="591" class="l"><a class="l" href="#591">591: </a> }
|
|
|
683 |
</span><span id="592" class="l"><a class="l" href="#592">592: </a> <span class="php-keyword1">return</span> <span class="php-var">$nettoyage_ok</span>;
|
|
|
684 |
</span><span id="593" class="l"><a class="l" href="#593">593: </a> }
|
|
|
685 |
</span><span id="594" class="l"><a class="l" href="#594">594: </a>
|
|
|
686 |
</span><span id="595" class="l"><a class="l" href="#595">595: </a> <span class="php-comment">/**
|
|
|
687 |
</span></span><span id="596" class="l"><a class="l" href="#596">596: </a><span class="php-comment"> * Check if the database structure is ok (with the good version), if no : build it
|
|
|
688 |
</span></span><span id="597" class="l"><a class="l" href="#597">597: </a><span class="php-comment"> *
|
|
|
689 |
</span></span><span id="598" class="l"><a class="l" href="#598">598: </a><span class="php-comment"> * @throws Zend_Cache_Exception
|
|
|
690 |
</span></span><span id="599" class="l"><a class="l" href="#599">599: </a><span class="php-comment"> * @return boolean True if ok
|
|
|
691 |
</span></span><span id="600" class="l"><a class="l" href="#600">600: </a><span class="php-comment"> */</span>
|
|
|
692 |
</span><span id="601" class="l"><a class="l" href="#601">601: </a> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_verifierEtCreerStructureBdd" href="#_verifierEtCreerStructureBdd">verifierEtCreerStructureBdd</a>() {
|
|
|
693 |
</span><span id="602" class="l"><a class="l" href="#602">602: </a> <span class="php-keyword1">if</span> (! <span class="php-var">$this</span>->structure_ok) {
|
|
|
694 |
</span><span id="603" class="l"><a class="l" href="#603">603: </a> <span class="php-keyword1">if</span> (! <span class="php-var">$this</span>->verifierBddStructureVersion()) {
|
|
|
695 |
</span><span id="604" class="l"><a class="l" href="#604">604: </a> <span class="php-var">$this</span>->creerStructure();
|
|
|
696 |
</span><span id="605" class="l"><a class="l" href="#605">605: </a> <span class="php-keyword1">if</span> (! <span class="php-var">$this</span>->verifierBddStructureVersion()) {
|
|
|
697 |
</span><span id="606" class="l"><a class="l" href="#606">606: </a> <span class="php-var">$e</span> = <span class="php-quote">"Impossible de construire la base de données de cache dans "</span>.<span class="php-var">$this</span>->options[<span class="php-quote">'stockage_chemin'</span>];
|
|
|
698 |
</span><span id="607" class="l"><a class="l" href="#607">607: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_WARNING);
|
|
|
699 |
</span><span id="608" class="l"><a class="l" href="#608">608: </a> <span class="php-var">$this</span>->structure_ok = <span class="php-keyword1">false</span>;
|
|
|
700 |
</span><span id="609" class="l"><a class="l" href="#609">609: </a> }
|
|
|
701 |
</span><span id="610" class="l"><a class="l" href="#610">610: </a> }
|
|
|
702 |
</span><span id="611" class="l"><a class="l" href="#611">611: </a> <span class="php-var">$this</span>->structure_ok = <span class="php-keyword1">true</span>;
|
|
|
703 |
</span><span id="612" class="l"><a class="l" href="#612">612: </a> }
|
|
|
704 |
</span><span id="613" class="l"><a class="l" href="#613">613: </a> <span class="php-keyword1">return</span> <span class="php-var">$this</span>->structure_ok;
|
|
|
705 |
</span><span id="614" class="l"><a class="l" href="#614">614: </a> }
|
|
|
706 |
</span><span id="615" class="l"><a class="l" href="#615">615: </a>
|
|
|
707 |
</span><span id="616" class="l"><a class="l" href="#616">616: </a>}
|
|
|
708 |
</span><span id="617" class="l"><a class="l" href="#617">617: </a></span><span class="xlang">?></span></code></pre>
|
|
|
709 |
|
|
|
710 |
<div id="footer">
|
| 465 |
jpm |
711 |
API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
|
| 464 |
jpm |
712 |
</div>
|
|
|
713 |
</div>
|
|
|
714 |
</div>
|
|
|
715 |
</body>
|
|
|
716 |
</html>
|