| 68 |
lars |
1 |
<?php
|
|
|
2 |
/**
|
|
|
3 |
* CodeIgniter
|
|
|
4 |
*
|
|
|
5 |
* An open source application development framework for PHP
|
|
|
6 |
*
|
|
|
7 |
* This content is released under the MIT License (MIT)
|
|
|
8 |
*
|
| 2254 |
lars |
9 |
* Copyright (c) 2014 - 2017, British Columbia Institute of Technology
|
| 68 |
lars |
10 |
*
|
|
|
11 |
* Permission is hereby granted, free of charge, to any person obtaining a copy
|
|
|
12 |
* of this software and associated documentation files (the "Software"), to deal
|
|
|
13 |
* in the Software without restriction, including without limitation the rights
|
|
|
14 |
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
|
|
|
15 |
* copies of the Software, and to permit persons to whom the Software is
|
|
|
16 |
* furnished to do so, subject to the following conditions:
|
|
|
17 |
*
|
|
|
18 |
* The above copyright notice and this permission notice shall be included in
|
|
|
19 |
* all copies or substantial portions of the Software.
|
|
|
20 |
*
|
|
|
21 |
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
|
|
|
22 |
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
|
|
|
23 |
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
|
|
|
24 |
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
|
|
|
25 |
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
|
|
|
26 |
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
|
|
|
27 |
* THE SOFTWARE.
|
|
|
28 |
*
|
|
|
29 |
* @package CodeIgniter
|
|
|
30 |
* @author EllisLab Dev Team
|
|
|
31 |
* @copyright Copyright (c) 2008 - 2014, EllisLab, Inc. (https://ellislab.com/)
|
| 2254 |
lars |
32 |
* @copyright Copyright (c) 2014 - 2017, British Columbia Institute of Technology (http://bcit.ca/)
|
| 68 |
lars |
33 |
* @license http://opensource.org/licenses/MIT MIT License
|
|
|
34 |
* @link https://codeigniter.com
|
|
|
35 |
* @since Version 1.0.0
|
|
|
36 |
* @filesource
|
|
|
37 |
*/
|
|
|
38 |
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
39 |
|
|
|
40 |
/**
|
|
|
41 |
* Database Cache Class
|
|
|
42 |
*
|
|
|
43 |
* @category Database
|
|
|
44 |
* @author EllisLab Dev Team
|
|
|
45 |
* @link https://codeigniter.com/user_guide/database/
|
|
|
46 |
*/
|
|
|
47 |
class CI_DB_Cache {
|
|
|
48 |
|
|
|
49 |
/**
|
|
|
50 |
* CI Singleton
|
|
|
51 |
*
|
|
|
52 |
* @var object
|
|
|
53 |
*/
|
|
|
54 |
public $CI;
|
|
|
55 |
|
|
|
56 |
/**
|
|
|
57 |
* Database object
|
|
|
58 |
*
|
|
|
59 |
* Allows passing of DB object so that multiple database connections
|
|
|
60 |
* and returned DB objects can be supported.
|
|
|
61 |
*
|
|
|
62 |
* @var object
|
|
|
63 |
*/
|
|
|
64 |
public $db;
|
|
|
65 |
|
|
|
66 |
// --------------------------------------------------------------------
|
|
|
67 |
|
|
|
68 |
/**
|
|
|
69 |
* Constructor
|
|
|
70 |
*
|
|
|
71 |
* @param object &$db
|
|
|
72 |
* @return void
|
|
|
73 |
*/
|
|
|
74 |
public function __construct(&$db)
|
|
|
75 |
{
|
|
|
76 |
// Assign the main CI object to $this->CI and load the file helper since we use it a lot
|
|
|
77 |
$this->CI =& get_instance();
|
|
|
78 |
$this->db =& $db;
|
|
|
79 |
$this->CI->load->helper('file');
|
|
|
80 |
|
|
|
81 |
$this->check_path();
|
|
|
82 |
}
|
|
|
83 |
|
|
|
84 |
// --------------------------------------------------------------------
|
|
|
85 |
|
|
|
86 |
/**
|
|
|
87 |
* Set Cache Directory Path
|
|
|
88 |
*
|
|
|
89 |
* @param string $path Path to the cache directory
|
|
|
90 |
* @return bool
|
|
|
91 |
*/
|
|
|
92 |
public function check_path($path = '')
|
|
|
93 |
{
|
|
|
94 |
if ($path === '')
|
|
|
95 |
{
|
|
|
96 |
if ($this->db->cachedir === '')
|
|
|
97 |
{
|
|
|
98 |
return $this->db->cache_off();
|
|
|
99 |
}
|
|
|
100 |
|
|
|
101 |
$path = $this->db->cachedir;
|
|
|
102 |
}
|
|
|
103 |
|
|
|
104 |
// Add a trailing slash to the path if needed
|
|
|
105 |
$path = realpath($path)
|
|
|
106 |
? rtrim(realpath($path), DIRECTORY_SEPARATOR).DIRECTORY_SEPARATOR
|
|
|
107 |
: rtrim($path, '/').'/';
|
|
|
108 |
|
|
|
109 |
if ( ! is_dir($path))
|
|
|
110 |
{
|
|
|
111 |
log_message('debug', 'DB cache path error: '.$path);
|
|
|
112 |
|
|
|
113 |
// If the path is wrong we'll turn off caching
|
|
|
114 |
return $this->db->cache_off();
|
|
|
115 |
}
|
|
|
116 |
|
|
|
117 |
if ( ! is_really_writable($path))
|
|
|
118 |
{
|
|
|
119 |
log_message('debug', 'DB cache dir not writable: '.$path);
|
|
|
120 |
|
|
|
121 |
// If the path is not really writable we'll turn off caching
|
|
|
122 |
return $this->db->cache_off();
|
|
|
123 |
}
|
|
|
124 |
|
|
|
125 |
$this->db->cachedir = $path;
|
|
|
126 |
return TRUE;
|
|
|
127 |
}
|
|
|
128 |
|
|
|
129 |
// --------------------------------------------------------------------
|
|
|
130 |
|
|
|
131 |
/**
|
|
|
132 |
* Retrieve a cached query
|
|
|
133 |
*
|
|
|
134 |
* The URI being requested will become the name of the cache sub-folder.
|
|
|
135 |
* An MD5 hash of the SQL statement will become the cache file name.
|
|
|
136 |
*
|
|
|
137 |
* @param string $sql
|
|
|
138 |
* @return string
|
|
|
139 |
*/
|
|
|
140 |
public function read($sql)
|
|
|
141 |
{
|
|
|
142 |
$segment_one = ($this->CI->uri->segment(1) == FALSE) ? 'default' : $this->CI->uri->segment(1);
|
|
|
143 |
$segment_two = ($this->CI->uri->segment(2) == FALSE) ? 'index' : $this->CI->uri->segment(2);
|
|
|
144 |
$filepath = $this->db->cachedir.$segment_one.'+'.$segment_two.'/'.md5($sql);
|
|
|
145 |
|
| 2107 |
lars |
146 |
if ( ! is_file($filepath) OR FALSE === ($cachedata = file_get_contents($filepath)))
|
| 68 |
lars |
147 |
{
|
|
|
148 |
return FALSE;
|
|
|
149 |
}
|
|
|
150 |
|
|
|
151 |
return unserialize($cachedata);
|
|
|
152 |
}
|
|
|
153 |
|
|
|
154 |
// --------------------------------------------------------------------
|
|
|
155 |
|
|
|
156 |
/**
|
|
|
157 |
* Write a query to a cache file
|
|
|
158 |
*
|
|
|
159 |
* @param string $sql
|
|
|
160 |
* @param object $object
|
|
|
161 |
* @return bool
|
|
|
162 |
*/
|
|
|
163 |
public function write($sql, $object)
|
|
|
164 |
{
|
|
|
165 |
$segment_one = ($this->CI->uri->segment(1) == FALSE) ? 'default' : $this->CI->uri->segment(1);
|
|
|
166 |
$segment_two = ($this->CI->uri->segment(2) == FALSE) ? 'index' : $this->CI->uri->segment(2);
|
|
|
167 |
$dir_path = $this->db->cachedir.$segment_one.'+'.$segment_two.'/';
|
|
|
168 |
$filename = md5($sql);
|
|
|
169 |
|
|
|
170 |
if ( ! is_dir($dir_path) && ! @mkdir($dir_path, 0750))
|
|
|
171 |
{
|
|
|
172 |
return FALSE;
|
|
|
173 |
}
|
|
|
174 |
|
|
|
175 |
if (write_file($dir_path.$filename, serialize($object)) === FALSE)
|
|
|
176 |
{
|
|
|
177 |
return FALSE;
|
|
|
178 |
}
|
|
|
179 |
|
|
|
180 |
chmod($dir_path.$filename, 0640);
|
|
|
181 |
return TRUE;
|
|
|
182 |
}
|
|
|
183 |
|
|
|
184 |
// --------------------------------------------------------------------
|
|
|
185 |
|
|
|
186 |
/**
|
|
|
187 |
* Delete cache files within a particular directory
|
|
|
188 |
*
|
|
|
189 |
* @param string $segment_one
|
|
|
190 |
* @param string $segment_two
|
|
|
191 |
* @return void
|
|
|
192 |
*/
|
|
|
193 |
public function delete($segment_one = '', $segment_two = '')
|
|
|
194 |
{
|
|
|
195 |
if ($segment_one === '')
|
|
|
196 |
{
|
|
|
197 |
$segment_one = ($this->CI->uri->segment(1) == FALSE) ? 'default' : $this->CI->uri->segment(1);
|
|
|
198 |
}
|
|
|
199 |
|
|
|
200 |
if ($segment_two === '')
|
|
|
201 |
{
|
|
|
202 |
$segment_two = ($this->CI->uri->segment(2) == FALSE) ? 'index' : $this->CI->uri->segment(2);
|
|
|
203 |
}
|
|
|
204 |
|
|
|
205 |
$dir_path = $this->db->cachedir.$segment_one.'+'.$segment_two.'/';
|
|
|
206 |
delete_files($dir_path, TRUE);
|
|
|
207 |
}
|
|
|
208 |
|
|
|
209 |
// --------------------------------------------------------------------
|
|
|
210 |
|
|
|
211 |
/**
|
|
|
212 |
* Delete all existing cache files
|
|
|
213 |
*
|
|
|
214 |
* @return void
|
|
|
215 |
*/
|
|
|
216 |
public function delete_all()
|
|
|
217 |
{
|
|
|
218 |
delete_files($this->db->cachedir, TRUE, TRUE);
|
|
|
219 |
}
|
|
|
220 |
|
|
|
221 |
}
|