PluginProbe
SQLite Object Cache / 1.6.2
SQLite Object Cache v1.6.2
1.6.5 trunk 0.1.7 1.0.0 1.1.0 1.1.1 1.2.0 1.2.1 1.2.2 1.2.3 1.3.0 1.3.1 1.3.2 1.3.4 1.3.5 1.3.6 1.3.7 1.3.8 1.4.0 1.4.1 1.5.1 1.5.4 1.5.5 1.5.6 1.5.7 All 30 releases
← All changes | includes/class-sqlite-object-cache.php +608 -408 1.5.61.6.2 View file →
@@ -5,9 +5,9 @@
5 5 * @package WordPress Plugin Template/Includes
6 6 */
7 7
8 8 if ( ! defined( 'ABSPATH' ) ) {
9 - exit;
9 + exit;
10 10 }
11 11
12 12 /**
13 13 * Main plugin class.
@@ -14,512 +14,712 @@
14 14 *
15 15 * Only make one instance of this, please.
16 16 */
17 17 class SQLite_Object_Cache {
18 - const CLEAN_EVENT_HOOK = 'sqlite_object_cache_clean';
18 + const CLEAN_EVENT_HOOK = 'sqlite_object_cache_clean';
19 19
20 - /**
21 - * Local instance of SQLite_Object_Cache_Admin_API
22 - *
23 - * @var SQLite_Object_Cache_Admin_API|null
24 - */
25 - public $admin;
20 + /**
21 + * Settings class object
22 + *
23 + * @var object
24 + * @access public
25 + * @since 1.0.0
26 + */
27 + public $settings;
26 28
27 - /**
28 - * Settings class object
29 - *
30 - * @var object
31 - * @access public
32 - * @since 1.0.0
33 - */
34 - public $settings;
29 + /**
30 + * The version number.
31 + *
32 + * @var string
33 + * @access public
34 + * @since 1.0.0
35 + */
36 + public $_version;
35 37
36 - /**
37 - * The version number.
38 - *
39 - * @var string
40 - * @access public
41 - * @since 1.0.0
42 - */
43 - public $_version;
38 + /**
39 + * The token.
40 + *
41 + * @var string
42 + * @access public
43 + * @since 1.0.0
44 + */
45 + public $_token;
44 46
45 - /**
46 - * The token.
47 - *
48 - * @var string
49 - * @access public
50 - * @since 1.0.0
51 - */
52 - public $_token;
47 + /**
48 + * The main plugin file.
49 + *
50 + * @var string
51 + * @access public
52 + * @since 1.0.0
53 + */
54 + public $file;
53 55
54 - /**
55 - * The main plugin file.
56 - *
57 - * @var string
58 - * @access public
59 - * @since 1.0.0
60 - */
61 - public $file;
56 + /**
57 + * The main plugin directory.
58 + *
59 + * @var string
60 + * @access public
61 + * @since 1.0.0
62 + */
63 + public $dir;
62 64
63 - /**
64 - * The main plugin directory.
65 - *
66 - * @var string
67 - * @access public
68 - * @since 1.0.0
69 - */
70 - public $dir;
65 + /**
66 + * The plugin assets directory.
67 + *
68 + * @var string
69 + * @access public
70 + * @since 1.0.0
71 + */
72 + public $assets_dir;
71 73
72 - /**
73 - * The plugin assets directory.
74 - *
75 - * @var string
76 - * @access public
77 - * @since 1.0.0
78 - */
79 - public $assets_dir;
74 + /**
75 + * The plugin assets URL.
76 + *
77 + * @var string
78 + * @access public
79 + * @since 1.0.0
80 + */
81 + public $assets_url;
80 82
81 - /**
82 - * The plugin assets URL.
83 - *
84 - * @var string
85 - * @access public
86 - * @since 1.0.0
87 - */
88 - public $assets_url;
83 + /**
84 + * Suffix for JavaScripts.
85 + *
86 + * @var string
87 + * @access public
88 + * @since 1.0.0
89 + */
90 + public $script_suffix;
89 91
90 - /**
91 - * Suffix for JavaScripts.
92 - *
93 - * @var string
94 - * @access public
95 - * @since 1.0.0
96 - */
97 - public $script_suffix;
92 + /**
93 + * Path for the drop-in when it is working.
94 + * @var string
95 + */
96 + public $dropinfiledest;
98 97
99 - /**
100 - * Path for the drop-in when it is working.
101 - * @var string
102 - */
103 - public $dropinfiledest;
98 + /**
99 + * Path for the drop-in in the plugin tree.
100 + * @var string
101 + */
102 + public $dropinfilesource;
104 103
105 - /**
106 - * Path for the drop-in in the plugin tree.
107 - * @var string
108 - */
109 - public $dropinfilesource;
104 + /**
105 + * Minimum required sqlite version.
106 + *
107 + * @var string
108 + */
109 + public $minimum_sqlite_version = '3.7.0';
110 110
111 - /**
112 - * Minimum required sqlite version.
113 - *
114 - * @var string
115 - */
116 - public $minimum_sqlite_version = '3.7.0';
111 + /**
112 + * Constructor function.
113 + *
114 + * @param string $file File constructor.
115 + * @param string $version Plugin version.
116 + */
117 + public function __construct( $file = '', $version = '1.6.2' ) {
118 + $this->_version = $version;
119 + $this->_token = 'sqlite_object_cache';
117 120
118 - /**
119 - * Constructor function.
120 - *
121 - * @param string $file File constructor.
122 - * @param string $version Plugin version.
123 - */
124 - public function __construct( $file = '', $version = '1.5.6' ) {
125 - $this->_version = $version;
126 - $this->_token = 'sqlite_object_cache';
121 + // Load plugin environment variables.
122 + $this->file = $file;
123 + $this->dir =
124 + trailingslashit( dirname( trailingslashit( WP_PLUGIN_DIR ) . plugin_basename( $this->file ) ) );
125 + $this->assets_dir = trailingslashit( $this->dir . 'assets' );
126 + $this->dropinfilesource = $this->assets_dir . 'drop-in/object-cache.php';
127 + $this->dropinfiledest = trailingslashit( WP_CONTENT_DIR ) . 'object-cache.php';
127 128
128 - // Load plugin environment variables.
129 - $this->file = $file;
130 - $this->dir =
131 - trailingslashit( dirname( WP_CONTENT_DIR . '/plugins/' . plugin_basename( $this->file ) ) );
132 - $this->assets_dir = trailingslashit( $this->dir . 'assets' );
133 - $this->dropinfilesource = $this->assets_dir . 'drop-in/object-cache.php';
134 - $this->dropinfiledest = trailingslashit( WP_CONTENT_DIR ) . 'object-cache.php';
129 + $this->assets_url = esc_url( trailingslashit( plugins_url( '/assets/', $this->file ) ) );
135 130
136 - $this->assets_url = esc_url( trailingslashit( plugins_url( '/assets/', $this->file ) ) );
131 + register_activation_hook( $this->file, array( $this, 'on_activation' ) );
132 + register_deactivation_hook( $this->file, array( $this, 'on_deactivation' ) );
137 133
138 - $this->script_suffix = defined( 'SCRIPT_DEBUG' ) && SCRIPT_DEBUG ? '' : '.min';
134 + if ( is_admin() ) {
135 + /* Suppress backups of .sqlite files if possible. */
136 + new SQLite_Backup_Exclusion();
139 137
140 - register_activation_hook( $this->file, array( $this, 'on_activation' ) );
141 - register_deactivation_hook( $this->file, array( $this, 'on_deactivation' ) );
138 + /* Health check */
139 + new SQLite_Object_Cache_Opcache();
142 140
143 - if ( is_admin() ) {
144 - // Load API for generic admin functions.
145 - $this->admin = new SQLite_Object_Cache_Admin_API();
146 - // Suppress backups
147 - new SQLite_Backup_Exclusion();
141 + add_action( 'admin_notices', function () {
142 + $flushed = get_site_transient( 'sqlite-object-cache-flush-on-update' );
143 + if ( $flushed ) {
144 + delete_site_transient( 'sqlite-object-cache-flush-on-update' );
145 + $message = __( 'Flushed the SQLite Object Cache successfully after a software installation or upgrade.', 'sqlite-object-cache' );
146 + ?>
147 + <div class="notice notice-success sqlite-object-cache is-dismissible">
148 + <p><?php echo esc_html( $message ); ?></p>
149 + </div>
150 + <?php
151 + }
152 + } );
153 + }
154 +
155 + add_action( 'admin_init', array( $this, 'maybe_update_dropin' ) );
156 +
157 + /* Ensure nothing is cached after software upgrades. */
158 + add_action( 'upgrader_process_complete', function () {
159 + add_action( 'shutdown', function () {
160 + wp_cache_flush();
161 + set_site_transient( 'sqlite-object-cache-flush-on-update', true, HOUR_IN_SECONDS );
162 + }, 999 );
163 + wp_cache_flush();
164 + }, 0 );
165 +
166 +
167 + /* Handle cron cache cleanup */
168 + add_action( self::CLEAN_EVENT_HOOK, array( $this, 'clean_job' ), 10, 0 );
169 + if ( ! wp_next_scheduled( self::CLEAN_EVENT_HOOK ) ) {
170 + wp_schedule_event( time() + HOUR_IN_SECONDS, 'hourly', self::CLEAN_EVENT_HOOK );
171 + }
172 + /* Handle probabilistic non-cron cleanup, one request in 2500. */
173 + /* We don't need cryptographic-grade random numbering here. */
174 + // phpcs:ignore WordPress.WP.AlternativeFunctions.rand_rand
175 + if ( 1 === rand( 1, 2500 ) ) {
176 + add_action( 'shutdown', function () {
177 + $this->clean_job( 1.25 );
178 + }, 999, 0 );
179 + }
180 +
181 + /* Admin bar flush button - works on both frontend and backend. */
182 + $option = get_option( $this->_token . '_settings', array() );
183 + if ( array_key_exists ('adminbarflush', $option ) && 'on' === $option['adminbarflush'] ) {
184 + add_action( 'init', array( $this, 'handle_admin_bar_flush' ) );
185 + add_action ( 'init', function() {
186 + if ( ! ( is_multisite() && ! is_main_site() ) && current_user_can( 'manage_options') ) {
187 + add_action( 'admin_bar_menu', array( $this, 'admin_bar_flush_button' ), 100 );
188 + add_action( 'admin_notices', array( $this, 'maybe_show_flush_notice' ) );
189 + }
190 + });
191 + }
148 192 }
149 193
150 - add_action( 'admin_init', array( $this, 'maybe_update_dropin' ) );
194 + /**
195 + * WP_Cron task to clean cache entries.
196 + *
197 + * @param float $grace_factor Default 1.0
198 + *
199 + * @return void
200 + */
201 + public function clean_job( $grace_factor = 1.0 ) {
202 + $option = get_option( $this->_token . '_settings', array() );
203 + $target_size = empty ( $option['target_size'] ) ? 16 : $option['target_size'];
204 + $target_size *= ( 1024 * 1024 );
205 + $threshold_size = (int) ( $target_size * $grace_factor );
151 206
152 - /* handle cron cache cleanup */
153 - add_action( self::CLEAN_EVENT_HOOK, array( $this, 'clean_job' ), 10, 0 );
154 - if ( ! wp_next_scheduled( self::CLEAN_EVENT_HOOK ) ) {
155 - wp_schedule_event( time() + HOUR_IN_SECONDS, 'hourly', self::CLEAN_EVENT_HOOK );
207 + global $wp_object_cache;
208 + if ( ! method_exists( $wp_object_cache, 'sqlite_get_size' ) ) {
209 + return;
210 + }
211 + /* Clean up old statistics. Do this even when the cache is not over size. */
212 + $retention = empty ( $option['retainmeasurements'] ) ? 24 : $option['retainmeasurements'];
213 + $wp_object_cache->sqlite_reset_statistics( $retention * HOUR_IN_SECONDS );
214 +
215 + $current_size = $wp_object_cache->sqlite_get_size();
216 + /* Skip this if the current size is small enough. */
217 + if ( $current_size <= $threshold_size ) {
218 + return;
219 + }
220 +
221 + /* Remove expired items (transients mostly). */
222 + if ( $wp_object_cache->sqlite_remove_expired() ) {
223 + /* If anything was removed, get the size again. */
224 + $current_size = $wp_object_cache->sqlite_get_size();
225 + }
226 +
227 + /* Skip this if the size is small enough, after removing expired items. */
228 + if ( $current_size <= $threshold_size ) {
229 + return;
230 + }
231 +
232 + /* Delete the least-recently-updated items to get to the target size. */
233 + $wp_object_cache->sqlite_delete_old( $target_size, $current_size );
156 234 }
157 - /* Handle probabilistic non-cron cleanup, one request in 2000. */
158 - if ( 1 === rand( 1, 2000 ) ) {
159 - add_action( 'shutdown', function () {
160 - $this->clean_job( 1.25 );
161 - }, 999, 0 );
235 +
236 + /**
237 + * Plugin activation hook
238 + *
239 + * @return void
240 + */
241 + public function on_activation() {
242 +
243 + $this->sync_apcu_global_to_option( true );
244 + if ( true === $this->has_sqlite() ) {
245 + add_action( 'shutdown', array( $this, 'update_dropin' ) );
246 + add_action( 'shutdown', array( $this, 'delete_all_transients_from_db' ) );
247 + }
162 248 }
163 - }
164 249
165 - /**
166 - * WP_Cron task to clean cache entries.
167 - *
168 - * @param float $grace_factor Default 1.0
169 - *
170 - * @return void
171 - */
172 - public function clean_job( $grace_factor = 1.0 ) {
173 - $option = get_option( $this->_token . '_settings', array() );
174 - $target_size = empty ( $option['target_size'] ) ? 16 : $option['target_size'];
175 - $target_size *= ( 1024 * 1024 );
176 - $threshold_size = (int) ( $target_size * $grace_factor );
250 + /**
251 + * Determine whether we can use SQLite3.
252 + *
253 + * @return bool|string true, or an error message.
254 + */
255 + public function has_sqlite() {
256 + if ( ! class_exists( 'SQLite3' ) || ! extension_loaded( 'sqlite3' ) ) {
257 + return __( 'You cannot use the SQLite Object Cache plugin. Your server does not have php\'s SQLite3 extension installed.', 'sqlite-object-cache' );
258 + }
177 259
178 - global $wp_object_cache;
179 - if ( ! method_exists( $wp_object_cache, 'sqlite_get_size' ) ) {
180 - return;
260 + $sqlite_version = $this->sqlite_get_version();
261 + if ( version_compare( $sqlite_version, $this->minimum_sqlite_version ) < 0 ) {
262 + return sprintf(
263 + /* translators: 1 actual SQLite version. 2 required SQLite version) */
264 + __( 'You cannot use the SQLite Object Cache plugin. Your server only offers SQLite3 version %1$s, but at least %2$s is required.', 'sqlite-object-cache' ),
265 + $sqlite_version, $this->minimum_sqlite_version );
266 + }
267 +
268 + return true;
181 269 }
182 - /* Clean up old statistics. Do this even when the cache is not over size. */
183 - $retention = empty ( $option['retainmeasurements'] ) ? 24 : $option['retainmeasurements'];
184 - $wp_object_cache->sqlite_reset_statistics( $retention * HOUR_IN_SECONDS );
185 270
186 - $current_size = $wp_object_cache->sqlite_get_size();
187 - /* Skip this if the current size is small enough. */
188 - if ( $current_size <= $threshold_size ) {
189 - return;
271 + /**
272 + * Get the version number for the SQLite extension.
273 + *
274 + * @return string|false SQLite's version number.
275 + */
276 + public function sqlite_get_version() {
277 +
278 + if ( class_exists( 'SQLite3' ) ) {
279 + $version = SQLite3::version();
280 +
281 + return $version['versionString'];
282 + }
283 +
284 + return false;
190 285 }
191 286
192 - /* Remove expired items (transients mostly). */
193 - if ( $wp_object_cache->sqlite_remove_expired() ) {
194 - /* If anything was removed, get the size again. */
195 - $current_size = $wp_object_cache->sqlite_get_size();
196 - }
287 + /**
288 + * Test if we can write in the WP_CONTENT_DIR and modify the `object-cache.php` drop-in
289 + *
290 + * @return true|WP_Error
291 + * @author Till Krüss
292 + *
293 + */
294 + public function test_filesystem_writing() {
295 + global $wp_filesystem;
197 296
198 - /* Skip this if the size is small enough, after removing expired items. */
199 - if ( $current_size <= $threshold_size ) {
200 - return;
201 - }
297 + if ( ! $this->initialize_filesystem( '', true ) ) {
298 + return new WP_Error( 'fs', __( 'Could not initialize filesystem.', 'sqlite-object-cache' ) );
299 + }
202 300
203 - /* Delete the least-recently-updated items to get to the target size. */
204 - $wp_object_cache->sqlite_delete_old( $target_size, $current_size );
205 - }
301 + $testfiledest = WP_CONTENT_DIR . '/sqlite-write-test.tmp';
206 302
207 - /**
208 - * Plugin activation hook
209 - *
210 - * @return void
211 - */
212 - public function on_activation() {
303 + if ( ! $wp_filesystem->exists( $this->dropinfilesource ) ) {
304 + return new WP_Error( 'exists', __( 'Object cache drop-in file doesn’t exist.', 'sqlite-object-cache' ) );
305 + }
213 306
214 - $this->sync_apcu_global_to_option( true );
215 - if ( true === $this->has_sqlite() ) {
216 - add_action( 'shutdown', array( $this, 'update_dropin' ) );
217 - }
218 - }
307 + if ( $wp_filesystem->exists( $testfiledest ) && ! $wp_filesystem->delete( $testfiledest ) ) {
308 + return new WP_Error( 'delete', __( 'Test file exists, but couldn’t be deleted.', 'sqlite-object-cache' ) );
309 + }
219 310
220 - /**
221 - * Determine whether we can use SQLite3.
222 - *
223 - * @return bool|string true, or an error message.
224 - */
225 - public function has_sqlite() {
226 - if ( ! class_exists( 'SQLite3' ) || ! extension_loaded( 'sqlite3' ) ) {
227 - return __( 'You cannot use the SQLite Object Cache plugin. Your server does not have php\'s SQLite3 extension installed.', 'sqlite-object-cache' );
311 + if ( ! $wp_filesystem->is_writable( WP_CONTENT_DIR ) ) {
312 + return new WP_Error( 'copy', __( 'Content directory is not writable.', 'sqlite-object-cache' ) );
313 + }
314 +
315 + if ( ! $wp_filesystem->copy( $this->dropinfilesource, $testfiledest, true, FS_CHMOD_FILE ) ) {
316 + return new WP_Error( 'copy', __( 'Failed to copy test file.', 'sqlite-object-cache' ) );
317 + }
318 +
319 + if ( ! $wp_filesystem->exists( $testfiledest ) ) {
320 + return new WP_Error( 'exists', __( 'Copied test file doesn’t exist.', 'sqlite-object-cache' ) );
321 + }
322 +
323 + $meta = get_file_data( $testfiledest, array( 'Version' => 'Version' ) );
324 +
325 + if ( $meta['Version'] !== $this->_version ) {
326 + return new WP_Error( 'version', __( 'Couldn’t verify test file contents.', 'sqlite-object-cache' ) );
327 + }
328 +
329 + if ( ! $wp_filesystem->delete( $testfiledest ) ) {
330 + return new WP_Error( 'delete', __( 'Copied test file couldn’t be deleted.', 'sqlite-object-cache' ) );
331 + }
332 +
333 + return true;
228 334 }
229 335
230 - $sqlite_version = $this->sqlite_get_version();
231 - if ( version_compare( $sqlite_version, $this->minimum_sqlite_version ) < 0 ) {
232 - return sprintf(
233 - /* translators: 1 actual SQLite version. 2 required SQLite version) */
234 - __( 'You cannot use the SQLite Object Cache plugin. Your server only offers SQLite3 version %1$s, but at least %2$s is required.', 'sqlite-object-cache' ),
235 - $sqlite_version, $this->minimum_sqlite_version );
236 - }
336 + /**
337 + * Initializes the WP filesystem API to be ready for use
338 + *
339 + * @param string $url The URL to post the form to.
340 + * @param bool $silent Whether to ask the user for credentials if necessary or not.
341 + *
342 + * @return bool
343 + * @author Till Krüss
344 + *
345 + */
346 + public function initialize_filesystem( $url, $silent = false ) {
347 + require_once ABSPATH . 'wp-admin/includes/file.php';
348 + if ( $silent ) {
349 + ob_start();
350 + }
237 351
238 - return true;
239 - }
352 + $credentials = request_filesystem_credentials( $url );
240 353
241 - /**
242 - * Get the version number for the SQLite extension.
243 - *
244 - * @return string|false SQLite's version number.
245 - */
246 - public function sqlite_get_version() {
354 + if ( false === $credentials ) {
355 + if ( $silent ) {
356 + ob_end_clean();
357 + }
247 358
248 - if ( class_exists( 'SQLite3' ) ) {
249 - $version = SQLite3::version();
359 + return false;
360 + }
250 361
251 - return $version['versionString'];
252 - }
362 + if ( ! WP_Filesystem( $credentials ) ) {
363 + request_filesystem_credentials( $url );
253 364
254 - return false;
255 - }
365 + if ( $silent ) {
366 + ob_end_clean();
367 + }
256 368
257 - /**
258 - * Test if we can write in the WP_CONTENT_DIR and modify the `object-cache.php` drop-in
259 - *
260 - * @return true|WP_Error
261 - * @author Till Krüss
262 - *
263 - */
264 - public function test_filesystem_writing() {
265 - global $wp_filesystem;
369 + return false;
370 + }
266 371
267 - if ( ! $this->initialize_filesystem( '', true ) ) {
268 - return new WP_Error( 'fs', __( 'Could not initialize filesystem.', 'sqlite-object-cache' ) );
372 + return true;
269 373 }
270 374
271 - $testfiledest = WP_CONTENT_DIR . '/sqlite-write-test.tmp';
375 + /**
376 + * Calls the drop-in update method if necessary
377 + *
378 + * @return void
379 + * @author Till Krüss
380 + */
381 + public function maybe_update_dropin() {
382 + if ( defined( 'WP_SQLITE_OBJECT_CACHE_DISABLE_DROPIN_AUTOUPDATE' ) && WP_SQLITE_OBJECT_CACHE_DISABLE_DROPIN_AUTOUPDATE ) {
383 + return;
384 + }
272 385
273 - if ( ! $wp_filesystem->exists( $this->dropinfilesource ) ) {
274 - return new WP_Error( 'exists', __( 'Object cache drop-in file doesn’t exist.', 'sqlite-object-cache' ) );
386 + $has = $this->has_sqlite();
387 + if ( ( true === $has ) && $this->object_cache_dropin_needs_updating() ) {
388 + add_action( 'shutdown', array( $this, 'update_dropin' ) );
389 + }
275 390 }
276 391
277 - if ( $wp_filesystem->exists( $testfiledest ) && ! $wp_filesystem->delete( $testfiledest ) ) {
278 - return new WP_Error( 'delete', __( 'Test file exists, but couldn’t be deleted.', 'sqlite-object-cache' ) );
392 + /**
393 + * Checks if the `object-cache.php` drop-in is outdated
394 + * @return bool
395 + * @author Till Krüss
396 + *
397 + */
398 + public function object_cache_dropin_needs_updating() {
399 + global $wp_object_cache;
400 + if ( ! method_exists( $wp_object_cache, 'dropin_get_version' ) ) {
401 + return true;
402 + }
403 + return version_compare( $wp_object_cache->dropin_get_version(), $this->_version, '<' );
279 404 }
280 405
281 - if ( ! $wp_filesystem->is_writable( WP_CONTENT_DIR ) ) {
282 - return new WP_Error( 'copy', __( 'Content directory is not writable.', 'sqlite-object-cache' ) );
406 + /**
407 + * Updates the `object-cache.php` drop-in
408 + *
409 + * @return void
410 + * @author Till Krüss
411 + */
412 + public function update_dropin() {
413 + global $wp_filesystem;
414 + $has = $this->has_sqlite();
415 + if ( true === $has && $this->initialize_filesystem( '', true ) ) {
416 +
417 + $this->delete_sqlite_files();
418 + $result = $wp_filesystem->copy( $this->dropinfilesource, $this->dropinfiledest, true, FS_CHMOD_FILE );
419 + /**
420 + * Fires on cache enable event
421 + *
422 + * @param bool $result Whether the filesystem event (copy of the `object-cache.php` file) was successful.
423 + *
424 + * @since 0.1.0
425 + */
426 + do_action( 'sqlite_object_cache_update_dropin', $result );
427 + }
283 428 }
284 429
285 - if ( ! $wp_filesystem->copy( $this->dropinfilesource, $testfiledest, true, FS_CHMOD_FILE ) ) {
286 - return new WP_Error( 'copy', __( 'Failed to copy test file.', 'sqlite-object-cache' ) );
287 - }
430 + /**
431 + * Validates the `object-cache.php` drop-in
432 + *
433 + * @return bool
434 + * @author Till Krüss
435 + */
436 + public function validate_object_cache_dropin() {
437 + global $wp_object_cache;
288 438
289 - if ( ! $wp_filesystem->exists( $testfiledest ) ) {
290 - return new WP_Error( 'exists', __( 'Copied test file doesn’t exist.', 'sqlite-object-cache' ) );
291 - }
439 + if ( ! method_exists( $wp_object_cache, 'dropin_get_version' ) ) {
440 + return false;
441 + }
292 442
293 - $meta = get_file_data( $testfiledest, array( 'Version' => 'Version' ) );
443 + $dropin = get_plugin_data( $this->dropinfiledest );
444 + $plugin = get_plugin_data( $this->dropinfilesource );
294 445
295 - if ( $meta['Version'] !== $this->_version ) {
296 - return new WP_Error( 'version', __( 'Couldn’t verify test file contents.', 'sqlite-object-cache' ) );
446 + /**
447 + * Filters the drop-in validation state
448 + *
449 + * @param bool $state The validation state of the drop-in.
450 + * @param string $dropin The `PluginURI` of the drop-in.
451 + * @param string $plugin The `PluginURI` of the plugin.
452 + *
453 + * @since 2.0.16
454 + */
455 + return apply_filters(
456 + 'sqlite_object_cache_validate_dropin',
457 + $dropin['PluginURI'] === $plugin['PluginURI'],
458 + $dropin['PluginURI'],
459 + $plugin['PluginURI']
460 + );
297 461 }
298 462
299 - if ( ! $wp_filesystem->delete( $testfiledest ) ) {
300 - return new WP_Error( 'delete', __( 'Copied test file couldn’t be deleted.', 'sqlite-object-cache' ) );
301 - }
463 + /**
464 + * Plugin deactivation hook
465 + *
466 + * @param string $plugin Plugin basename.
467 + *
468 + * @return void
469 + * @author Till Krüss
470 + */
471 + public function on_deactivation( $plugin ) {
302 472
303 - return true;
304 - }
473 + wp_cache_flush();
305 474
306 - /**
307 - * Initializes the WP filesystem API to be ready for use
308 - *
309 - * @param string $url The URL to post the form to.
310 - * @param bool $silent Whether to ask the user for credentials if necessary or not.
311 - *
312 - * @return bool
313 - * @author Till Krüss
314 - *
315 - */
316 - public function initialize_filesystem( $url, $silent = false ) {
317 - require_once ABSPATH . 'wp-admin/includes/file.php';
318 - if ( $silent ) {
319 - ob_start();
475 + wp_unschedule_hook( self::CLEAN_EVENT_HOOK );
476 + $this->delete_sqlite_files();
477 + $this->delete_dropin();
478 + $this->delete_all_transients_from_db();
320 479 }
321 480
322 - $credentials = request_filesystem_credentials( $url );
481 + private function delete_sqlite_files() {
482 + global $wp_filesystem;
483 + global $wp_object_cache;
323 484
324 - if ( false === $credentials ) {
325 - if ( $silent ) {
326 - ob_end_clean();
327 - }
485 + if ( method_exists( $wp_object_cache, 'sqlite_files' ) ) {
486 + if ( $this->initialize_filesystem( '', true ) ) {
487 + foreach ( $wp_object_cache->sqlite_files() as $file ) {
488 + $wp_filesystem->delete( $file );
489 + }
490 + }
491 + }
492 + }
328 493
329 - return false;
330 - }
494 + private function delete_dropin() {
495 + global $wp_filesystem;
496 + ob_start();
331 497
332 - if ( ! WP_Filesystem( $credentials ) ) {
333 - request_filesystem_credentials( $url );
498 + if ( $this->validate_object_cache_dropin() && $this->initialize_filesystem( '', true ) ) {
499 + $wp_filesystem->delete( $this->dropinfiledest );
500 + }
334 501
335 - if ( $silent ) {
336 502 ob_end_clean();
337 - }
338 -
339 - return false;
340 503 }
341 504
342 - return true;
343 - }
505 + /**
506 + * Deletes all transients from the database.
507 + *
508 + * It is necessary to do this when deactivating a persistent object cache
509 + * because the transients are kept there, and the ones in the database are
510 + * possibly stale.
511 + *
512 + * This hammers performance. But deactivating a persistent object cache is
513 + * not a common operation.
514 + *
515 + * @global wpdb $wpdb WordPress database abstraction object.
516 + */
517 + public function delete_all_transients_from_db() {
518 + global $wpdb;
519 + if ( ! is_multisite() ) {
520 + $this->clear_blog_transients();
521 + // Single site stores site transients in the options table.
522 + $this->clear_blog_transients( '_site_transient_' );
523 + } else {
524 + foreach ( get_sites( array( 'number' => 0, 'fields' => 'ids', 'no_found_rows' => true, 'orderby' => false ) ) as $site_id ) {
525 + try {
526 + switch_to_blog( $site_id );
527 + $this->clear_blog_transients();
528 + } catch ( Exception $ex ) {
529 + /* Empty, intentionally. Don't crash clearing transients. */
530 + } finally {
531 + restore_current_blog();
532 + }
533 + }
534 + // Multisite stores site transients in the sitemeta table.
535 + // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching
536 + $wpdb->query(
537 + $wpdb->prepare(
538 + "DELETE FROM {$wpdb->sitemeta} WHERE a.meta_key LIKE %s",
539 + $wpdb->esc_like( '_site_transient_' ) . '%'
540 + )
541 + );
344 542
345 - /**
346 - * Calls the drop-in update method if necessary
347 - *
348 - * @return void
349 - * @author Till Krüss
350 - */
351 - public function maybe_update_dropin() {
352 - if ( defined( 'WP_SQLITE_OBJECT_CACHE_DISABLE_DROPIN_AUTOUPDATE' ) && WP_SQLITE_OBJECT_CACHE_DISABLE_DROPIN_AUTOUPDATE ) {
353 - return;
543 + }
354 544 }
355 545
356 - $has = $this->has_sqlite();
357 - if ( ( true === $has ) && $this->object_cache_dropin_needs_updating() ) {
358 - add_action( 'shutdown', array( $this, 'update_dropin' ) );
546 + /**
547 + * DELETE transients from the current blog's options table.
548 + *
549 + * @param string $tag _site_transient_ or _transient_, the default.
550 + *
551 + * @return void
552 + */
553 + private function clear_blog_transients( $tag = '_transient_') {
554 + global $wpdb;
555 + // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching
556 + $wpdb->query(
557 + $wpdb->prepare(
558 + "DELETE FROM {$wpdb->options} WHERE option_name LIKE %s",
559 + $wpdb->esc_like( $tag ) . '%'
560 + )
561 + );
359 562 }
360 - }
361 563
362 - /**
363 - * Checks if the `object-cache.php` drop-in is outdated
364 - * @return bool
365 - * @author Till Krüss
366 - *
367 - */
368 - public function object_cache_dropin_needs_updating() {
369 - global $wp_object_cache;
370 - if ( ! method_exists( $wp_object_cache, 'dropin_get_version' ) ) {
371 - return true;
564 + /**
565 + * @return bool True if APCu support is activated for this plugin.
566 + */
567 + public function apcu_is_activated() {
568 + return defined( 'WP_SQLITE_OBJECT_CACHE_APCU' ) && WP_SQLITE_OBJECT_CACHE_APCU
569 + && $this->apcu_extension_is_enabled();
372 570 }
373 - return version_compare( $wp_object_cache->dropin_get_version(), $this->_version, '<' );
374 - }
375 571
376 - /**
377 - * Updates the `object-cache.php` drop-in
378 - *
379 - * @return void
380 - * @author Till Krüss
381 - */
382 - public function update_dropin() {
383 - global $wp_filesystem;
384 - $has = $this->has_sqlite();
385 - if ( true === $has && $this->initialize_filesystem( '', true ) ) {
386 -
387 - $this->delete_sqlite_files();
388 - $result = $wp_filesystem->copy( $this->dropinfilesource, $this->dropinfiledest, true, FS_CHMOD_FILE );
389 - /**
390 - * Fires on cache enable event
391 - *
392 - * @param bool $result Whether the filesystem event (copy of the `object-cache.php` file) was successful.
393 - *
394 - * @since 0.1.0
395 - */
396 - do_action( 'sqlite_object_cache_update_dropin', $result );
572 + /**
573 + * @return bool True if the APCu extension is loaded and enabled.
574 + */
575 + public function apcu_extension_is_enabled() {
576 + return function_exists( 'apcu_enabled' ) && apcu_enabled();
397 577 }
398 - }
399 578
400 - /**
401 - * Validates the `object-cache.php` drop-in
402 - *
403 - * @return bool
404 - * @author Till Krüss
405 - */
406 - public function validate_object_cache_dropin() {
407 - global $wp_object_cache;
579 + /**
580 + * Make sure WP_SQLITE_OBJECT_CACHE_APCU and $option['use_apcu'] match.
581 + *
582 + * @param bool $unconditional true if we should always change the option to match WP_SQLITE_OBJECT_CACHE_APCU.
583 + *
584 + * @return string 'on' or 'off': the current activation state of epcu.
585 + */
586 + public function sync_apcu_global_to_option( $unconditional = true ) {
587 + global $wp_object_cache;
588 + $option = get_option( $this->_token . '_settings', array() );
589 + $option_dirty = false;
590 + $updated_flag = array_key_exists( 'use_apcu_updated', $option );
591 + $use_apcu = array_key_exists( 'use_apcu', $option ) && 'on' === $option['use_apcu'] ? 'on' : 'off';
592 + if ( $updated_flag ) {
593 + unset ( $option['use_apcu_updated'] );
594 + $option_dirty = true;
595 + }
596 + $target_use_apcu = $this->apcu_is_activated() ? 'on' : 'off';
597 + if ( ! $unconditional && $updated_flag ) {
598 + $target_use_apcu = $use_apcu;
599 + }
600 + if ( $target_use_apcu !== $use_apcu ) {
601 + $option['use_apcu'] = $target_use_apcu;
602 + $option_dirty = true;
603 + }
604 + if ( $option_dirty ) {
605 + if ( method_exists( $wp_object_cache, 'apcu-clear_cache' ) ) {
606 + $wp_object_cache->apcu_clear_cache();
607 + }
608 + update_option( $this->_token . '_settings', $option, true );
609 + }
408 610
409 - if ( ! method_exists( $wp_object_cache, 'dropin_get_version' ) ) {
410 - return false;
611 + return $target_use_apcu;
411 612 }
412 613
413 - $dropin = get_plugin_data( $this->dropinfiledest );
414 - $plugin = get_plugin_data( $this->dropinfilesource );
415 -
416 614 /**
417 - * Filters the drop-in validation state
615 + * Add a flush button to the admin bar.
418 616 *
419 - * @param bool $state The validation state of the drop-in.
420 - * @param string $dropin The `PluginURI` of the drop-in.
421 - * @param string $plugin The `PluginURI` of the plugin.
617 + * @param WP_Admin_Bar $wp_admin_bar The admin bar instance.
422 618 *
423 - * @since 2.0.16
619 + * @return void
424 620 */
425 - return apply_filters(
426 - 'sqlite_object_cache_validate_dropin',
427 - $dropin['PluginURI'] === $plugin['PluginURI'],
428 - $dropin['PluginURI'],
429 - $plugin['PluginURI']
430 - );
431 - }
621 + public function admin_bar_flush_button( $wp_admin_bar ) {
622 + if ( ! is_admin_bar_showing() ) {
623 + return;
624 + }
432 625
433 - /**
434 - * Plugin deactivation hook
435 - *
436 - * @param string $plugin Plugin basename.
437 - *
438 - * @return void
439 - * @author Till Krüss
440 - */
441 - public function on_deactivation( $plugin ) {
626 + if ( ! current_user_can( 'manage_options' ) ) {
627 + return;
628 + }
442 629
443 - wp_cache_flush();
630 + // Only show on main site for multisite installations.
631 + if ( is_multisite() && ! is_main_site() ) {
632 + return;
633 + }
444 634
445 - wp_unschedule_hook( self::CLEAN_EVENT_HOOK );
446 - $this->delete_sqlite_files();
447 - $this->delete_dropin();
448 - }
635 + $flush_url = add_query_arg(
636 + array( 'sqlite_object_cache_action' => 'flush' ),
637 + remove_query_arg( 'sqlite_object_cache_action' )
638 + );
639 + $nonced_url = wp_nonce_url( $flush_url, 'sqlite_object_cache_flush' );
449 640
450 - private function delete_sqlite_files() {
451 - global $wp_filesystem;
452 - global $wp_object_cache;
641 + $wp_admin_bar->add_node(
642 + array(
643 + 'id' => 'sqlite-object-cache-flush',
644 + 'title' => __( 'Flush Object Cache', 'sqlite-object-cache' ),
645 + 'href' => $nonced_url,
646 + 'meta' => array(
647 + 'title' => __( 'Delete all object cache entries now, including all transients.', 'sqlite-object-cache' ),
648 + ),
649 + )
650 + );
651 + }
453 652
454 - if ( method_exists( $wp_object_cache, 'sqlite_files' ) ) {
455 - if ( $this->initialize_filesystem( '', true ) ) {
456 - foreach ( $wp_object_cache->sqlite_files() as $file ) {
457 - $wp_filesystem->delete( $file );
653 + /**
654 + * Handle the admin bar flush action.
655 + *
656 + * @return void
657 + */
658 + public function handle_admin_bar_flush() {
659 + if ( ! isset( $_GET['sqlite_object_cache_action'] ) ) {
660 + return;
458 661 }
459 - }
460 - }
461 - }
462 662
463 - private function delete_dropin() {
464 - global $wp_filesystem;
465 - ob_start();
663 + $action = sanitize_key( wp_unslash( $_GET['sqlite_object_cache_action'] ) );
466 664
467 - if ( $this->validate_object_cache_dropin() && $this->initialize_filesystem( '', true ) ) {
468 - $wp_filesystem->delete( $this->dropinfiledest );
469 - }
665 + if ( 'flush' !== $action ) {
666 + return;
667 + }
470 668
471 - ob_end_clean();
472 - }
669 + if ( ! current_user_can( 'manage_options' ) ) {
670 + wp_die( esc_html__( 'You do not have permission to flush the object cache.', 'sqlite-object-cache' ) );
671 + }
473 672
474 - /**
475 - * @return bool True if APCu support is activated for this plugin.
476 - */
477 - public function apcu_is_activated() {
478 - return defined( 'WP_SQLITE_OBJECT_CACHE_APCU' ) && WP_SQLITE_OBJECT_CACHE_APCU
479 - && $this->apcu_extension_is_enabled();
480 - }
673 + // Only allow flush on main site for multisite installations (matches button visibility).
674 + if ( is_multisite() && ! is_main_site() ) {
675 + wp_die( esc_html__( 'Cache flush is only available on the main site.', 'sqlite-object-cache' ) );
676 + }
481 677
482 - /**
483 - * @return bool True if the APCu extension is loaded and enabled.
484 - */
485 - public function apcu_extension_is_enabled() {
486 - return function_exists( 'apcu_enabled' ) && apcu_enabled();
487 - }
678 + check_admin_referer( 'sqlite_object_cache_flush' );
488 679
489 - /**
490 - * Make sure WP_SQLITE_OBJECT_CACHE_APCU and $option['use_apcu'] match.
491 - *
492 - * @param bool $unconditional true if we should always change the option to match WP_SQLITE_OBJECT_CACHE_APCU.
493 - *
494 - * @return string 'on' or 'off': the current activation state of epcu.
495 - */
496 - public function sync_apcu_global_to_option( $unconditional = true ) {
497 - global $wp_object_cache;
498 - $option = get_option( $this->_token . '_settings', array() );
499 - $option_dirty = false;
500 - $updated_flag = array_key_exists( 'use_apcu_updated', $option );
501 - $use_apcu = array_key_exists( 'use_apcu', $option ) && 'on' === $option['use_apcu'] ? 'on' : 'off';
502 - if ( $updated_flag ) {
503 - unset ( $option['use_apcu_updated'] );
504 - $option_dirty = true;
680 + wp_cache_flush();
681 +
682 + // Use a user-specific transient so only the initiating user sees the flush notice (applies to both single-site and multisite).
683 + $transient_key = 'sqlite_object_cache_flushed_' . get_current_user_id();
684 + set_transient( $transient_key, true, 30 );
685 +
686 + $referer = wp_get_referer();
687 + if ( $referer ) {
688 + $redirect_url = $referer;
689 + } else {
690 + $redirect_url = is_admin() ? admin_url() : home_url();
691 + }
692 + // Remove action and nonce query parameters from URL.
693 + $redirect_url = remove_query_arg( array( 'sqlite_object_cache_action', '_wpnonce' ), $redirect_url );
694 +
695 + wp_safe_redirect( $redirect_url );
696 + exit;
505 697 }
506 - $target_use_apcu = $this->apcu_is_activated() ? 'on' : 'off';
507 - if ( ! $unconditional && $updated_flag ) {
508 - $target_use_apcu = $use_apcu;
698 +
699 + /**
700 + * Check for flush transient and show notice if set.
701 + *
702 + * @return void
703 + */
704 + public function maybe_show_flush_notice() {
705 + $transient_key = 'sqlite_object_cache_flushed_' . get_current_user_id();
706 + if ( get_transient( $transient_key ) ) {
707 + delete_transient( $transient_key );
708 + $this->show_flush_notice();
709 + }
509 710 }
510 - if ( $target_use_apcu !== $use_apcu ) {
511 - $option['use_apcu'] = $target_use_apcu;
512 - $option_dirty = true;
711 +
712 + /**
713 + * Display a notice when the object cache was flushed via admin bar.
714 + *
715 + * @return void
716 + */
717 + public function show_flush_notice() {
718 + ?>
719 + <div class="notice notice-success sqlite-object-cache is-dismissible">
720 + <p><?php esc_html_e( 'SQLite Object Cache flushed successfully.', 'sqlite-object-cache' ); ?></p>
721 + </div>
722 + <?php
513 723 }
514 - if ( $option_dirty ) {
515 - if ( method_exists( $wp_object_cache, 'apcu-clear_cache' ) ) {
516 - $wp_object_cache->apcu_clear_cache();
517 - }
518 - update_option( $this->_token . '_settings', $option, true );
519 - }
520 -
521 - return $target_use_apcu;
522 - }
523 -
524 724
525 725 }