<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* LiteSpeed CLI - database cleanup

[2] Fix | Delete

*

[3] Fix | Delete

* Add CLI database cleanup commands.

[4] Fix | Delete

*

[5] Fix | Delete

* @package LiteSpeed

[6] Fix | Delete

* @since 7.3

[7] Fix | Delete

*/

[8] Fix | Delete

[9] Fix | Delete

namespace LiteSpeed\CLI;

[10] Fix | Delete

[11] Fix | Delete

defined('WPINC') || exit();

[12] Fix | Delete

[13] Fix | Delete

use LiteSpeed\Debug2;

[14] Fix | Delete

use LiteSpeed\DB_Optm;

[15] Fix | Delete

use WP_CLI;

[16] Fix | Delete

[17] Fix | Delete

/**

[18] Fix | Delete

* LiteSpeed Cache Database CLI

[19] Fix | Delete

*/

[20] Fix | Delete

class Database {

[21] Fix | Delete

/**

[22] Fix | Delete

* Current blog id the optimization is working on.

[23] Fix | Delete

*

[24] Fix | Delete

* @var int|false $current_blog Current blog id.

[25] Fix | Delete

*/

[26] Fix | Delete

private $current_blog = false;

[27] Fix | Delete

/**

[28] Fix | Delete

* Database class.

[29] Fix | Delete

*

[30] Fix | Delete

* @var DB_Optim $db Database class.

[31] Fix | Delete

*/

[32] Fix | Delete

private $db;

[33] Fix | Delete

[34] Fix | Delete

/**

[35] Fix | Delete

* Class constructor.

[36] Fix | Delete

*/

[37] Fix | Delete

public function __construct() {

[38] Fix | Delete

Debug2::debug('CLI_Database init');

[39] Fix | Delete

[40] Fix | Delete

$this->db = DB_Optm::cls();

[41] Fix | Delete

}

[42] Fix | Delete

[43] Fix | Delete

/**

[44] Fix | Delete

* List all site domains and ids on the network.

[45] Fix | Delete

*/

[46] Fix | Delete

public function network_list() {

[47] Fix | Delete

if ( !is_multisite() ) {

[48] Fix | Delete

WP_CLI::error('This is not a multisite installation!');

[49] Fix | Delete

[50] Fix | Delete

return;

[51] Fix | Delete

}

[52] Fix | Delete

$buf = WP_CLI::colorize("%CThe list of installs:%n\n");

[53] Fix | Delete

[54] Fix | Delete

$sites = get_sites();

[55] Fix | Delete

foreach ( $sites as $site ) {

[56] Fix | Delete

$buf .= WP_CLI::colorize( '%Y' . $site->domain . $site->path . ':%n ID ' . $site->blog_id ) . "\n";

[57] Fix | Delete

}

[58] Fix | Delete

[59] Fix | Delete

WP_CLI::line($buf);

[60] Fix | Delete

}

[61] Fix | Delete

[62] Fix | Delete

/**

[63] Fix | Delete

* Change to blog sent as param.

[64] Fix | Delete

*

[65] Fix | Delete

* @param array $args Description.

[66] Fix | Delete

*/

[67] Fix | Delete

private function change_to_blog( $args ) {

[68] Fix | Delete

if ( !isset( $args[0] ) || 'blog' !== $args[0] ) {

[69] Fix | Delete

return;

[70] Fix | Delete

}

[71] Fix | Delete

[72] Fix | Delete

$this->current_blog = get_current_blog_id();

[73] Fix | Delete

$blogid = $args[1];

[74] Fix | Delete

if ( !is_numeric( $blogid ) ) {

[75] Fix | Delete

$error = WP_CLI::colorize( '%RError: invalid blog id entered.%n' );

[76] Fix | Delete

WP_CLI::line( $error );

[77] Fix | Delete

$this->network_list( $args );

[78] Fix | Delete

return;

[79] Fix | Delete

}

[80] Fix | Delete

$site = get_blog_details( $blogid );

[81] Fix | Delete

if ( false === $site ) {

[82] Fix | Delete

$error = WP_CLI::colorize( '%RError: invalid blog id entered.%n' );

[83] Fix | Delete

WP_CLI::line( $error );

[84] Fix | Delete

$this->network_list( $args );

[85] Fix | Delete

return;

[86] Fix | Delete

}

[87] Fix | Delete

switch_to_blog( $blogid );

[88] Fix | Delete

}

[89] Fix | Delete

[90] Fix | Delete

/**

[91] Fix | Delete

* Change to previous blog.

[92] Fix | Delete

*/

[93] Fix | Delete

private function change_to_default() {

[94] Fix | Delete

// Check if previous blog set.

[95] Fix | Delete

if ( $this->current_blog ) {

[96] Fix | Delete

switch_to_blog( $this->current_blog );

[97] Fix | Delete

// Switched to previous blog.

[98] Fix | Delete

$this->current_blog = false;

[99] Fix | Delete

}

[100] Fix | Delete

}

[101] Fix | Delete

[102] Fix | Delete

/**

[103] Fix | Delete

* Show CLI response.

[104] Fix | Delete

*

[105] Fix | Delete

* @param boolean $result Flag if result is success or failure.

[106] Fix | Delete

* @param string $action Action name.

[107] Fix | Delete

*/

[108] Fix | Delete

private function show_response( $result, $action ) {

[109] Fix | Delete

if ($result) {

[110] Fix | Delete

WP_CLI::success( $result );

[111] Fix | Delete

} else {

[112] Fix | Delete

WP_CLI::error( 'Error running optimization: ' . $action );

[113] Fix | Delete

}

[114] Fix | Delete

}

[115] Fix | Delete

[116] Fix | Delete

/**

[117] Fix | Delete

* Clean actions function.

[118] Fix | Delete

*

[119] Fix | Delete

* @param int $args Action arguments.

[120] Fix | Delete

* @param array $types What data to clean.

[121] Fix | Delete

*/

[122] Fix | Delete

private function clean_action( $args, $types ) {

[123] Fix | Delete

$this->change_to_blog( $args );

[124] Fix | Delete

foreach ( $types as $type ) {

[125] Fix | Delete

$result = $this->db->handler_clean_db_cli( $type );

[126] Fix | Delete

$this->show_response( $result, $type );

[127] Fix | Delete

}

[128] Fix | Delete

$this->change_to_default();

[129] Fix | Delete

}

[130] Fix | Delete

[131] Fix | Delete

/**

[132] Fix | Delete

* Clear posts data(revisions, orphaned, auto drafts, trashed posts).

[133] Fix | Delete

* # Start clearing posts data.

[134] Fix | Delete

* $ wp litespeed-database clear_posts

[135] Fix | Delete

* $ wp litespeed-database clear_posts blog 2

[136] Fix | Delete

*

[137] Fix | Delete

* @param string $args Action arguments.

[138] Fix | Delete

*/

[139] Fix | Delete

public function clear_posts( $args ) {

[140] Fix | Delete

$types = array(

[141] Fix | Delete

'revision',

[142] Fix | Delete

'orphaned_post_meta',

[143] Fix | Delete

'auto_draft',

[144] Fix | Delete

'trash_post',

[145] Fix | Delete

);

[146] Fix | Delete

$this->clean_action( $args, $types );

[147] Fix | Delete

}

[148] Fix | Delete

[149] Fix | Delete

/**

[150] Fix | Delete

* Clear comments(spam and trash comments).

[151] Fix | Delete

* # Start clearing comments.

[152] Fix | Delete

* $ wp litespeed-database clear_comments

[153] Fix | Delete

* $ wp litespeed-database clear_comments blog 2

[154] Fix | Delete

*

[155] Fix | Delete

* @param string $args Action arguments.

[156] Fix | Delete

*/

[157] Fix | Delete

public function clear_comments( $args ) {

[158] Fix | Delete

$types = array(

[159] Fix | Delete

'spam_comment',

[160] Fix | Delete

'trash_comment',

[161] Fix | Delete

);

[162] Fix | Delete

$this->clean_action( $args, $types );

[163] Fix | Delete

}

[164] Fix | Delete

[165] Fix | Delete

/**

[166] Fix | Delete

* Clear trackbacks/pingbacks.

[167] Fix | Delete

* # Start clearing trackbacks/pingbacks.

[168] Fix | Delete

* $ wp litespeed-database clear_trackbacks

[169] Fix | Delete

* $ wp litespeed-database clear_trackbacks blog 2

[170] Fix | Delete

*

[171] Fix | Delete

* @param string $args Action arguments.

[172] Fix | Delete

*/

[173] Fix | Delete

public function clear_trackbacks( $args ) {

[174] Fix | Delete

$types = array(

[175] Fix | Delete

'trackback-pingback',

[176] Fix | Delete

);

[177] Fix | Delete

$this->clean_action( $args, $types );

[178] Fix | Delete

}

[179] Fix | Delete

[180] Fix | Delete

/**

[181] Fix | Delete

* Clear transients.

[182] Fix | Delete

* # Start clearing transients.

[183] Fix | Delete

* $ wp litespeed-database clear_transients

[184] Fix | Delete

* $ wp litespeed-database clear_transients blog 2

[185] Fix | Delete

*

[186] Fix | Delete

* @param string $args Action arguments.

[187] Fix | Delete

*/

[188] Fix | Delete

public function clear_transients( $args ) {

[189] Fix | Delete

$types = array(

[190] Fix | Delete

'expired_transient',

[191] Fix | Delete

'all_transients',

[192] Fix | Delete

);

[193] Fix | Delete

$this->clean_action( $args, $types );

[194] Fix | Delete

}

[195] Fix | Delete

[196] Fix | Delete

/**

[197] Fix | Delete

* Optimize tables.

[198] Fix | Delete

* # Start optimizing tables.

[199] Fix | Delete

* $ wp litespeed-database optimize_tables

[200] Fix | Delete

* $ wp litespeed-database optimize_tables blog 2

[201] Fix | Delete

*

[202] Fix | Delete

* @param string $args Action arguments.

[203] Fix | Delete

*/

[204] Fix | Delete

public function optimize_tables( $args ) {

[205] Fix | Delete

$types = array(

[206] Fix | Delete

'optimize_tables',

[207] Fix | Delete

);

[208] Fix | Delete

$this->clean_action( $args, $types );

[209] Fix | Delete

}

[210] Fix | Delete

[211] Fix | Delete

/**

[212] Fix | Delete

* Optimize database by running all possible operations.

[213] Fix | Delete

* # Start optimizing all.

[214] Fix | Delete

* $ wp litespeed-database optimize_all

[215] Fix | Delete

* $ wp litespeed-database optimize_all blog 2

[216] Fix | Delete

*

[217] Fix | Delete

* @param string $args Action arguments.

[218] Fix | Delete

*/

[219] Fix | Delete

public function optimize_all( $args ) {

[220] Fix | Delete

$types = array(

[221] Fix | Delete

'all',

[222] Fix | Delete

);

[223] Fix | Delete

$this->clean_action( $args, $types );

[224] Fix | Delete

}

[225] Fix | Delete

}

[226] Fix | Delete

[227] Fix | Delete