<?php

[0] Fix | Delete

[1] Fix | Delete

namespace WPForms\Tasks\Actions;

[2] Fix | Delete

[3] Fix | Delete

use WPForms\Tasks\Task;

[4] Fix | Delete

use WPForms\Tasks\Tasks;

[5] Fix | Delete

use WPForms_Entry_Handler;

[6] Fix | Delete

use WPForms_Entry_Meta_Handler;

[7] Fix | Delete

[8] Fix | Delete

/**

[9] Fix | Delete

* Class Migration175Task.

[10] Fix | Delete

*

[11] Fix | Delete

* @since 1.7.5

[12] Fix | Delete

*/

[13] Fix | Delete

class Migration175Task extends Task {

[14] Fix | Delete

[15] Fix | Delete

/**

[16] Fix | Delete

* Action name for this task.

[17] Fix | Delete

*

[18] Fix | Delete

* @since 1.7.5

[19] Fix | Delete

*/

[20] Fix | Delete

const ACTION = 'wpforms_process_migration_175';

[21] Fix | Delete

[22] Fix | Delete

/**

[23] Fix | Delete

* Status option name.

[24] Fix | Delete

*

[25] Fix | Delete

* @since 1.7.5

[26] Fix | Delete

*/

[27] Fix | Delete

const STATUS = 'wpforms_process_migration_175_status';

[28] Fix | Delete

[29] Fix | Delete

/**

[30] Fix | Delete

* Start status.

[31] Fix | Delete

*

[32] Fix | Delete

* @since 1.7.5

[33] Fix | Delete

*/

[34] Fix | Delete

const START = 'start';

[35] Fix | Delete

[36] Fix | Delete

/**

[37] Fix | Delete

* In progress status.

[38] Fix | Delete

*

[39] Fix | Delete

* @since 1.7.5

[40] Fix | Delete

*/

[41] Fix | Delete

const IN_PROGRESS = 'in progress';

[42] Fix | Delete

[43] Fix | Delete

/**

[44] Fix | Delete

* Completed status.

[45] Fix | Delete

*

[46] Fix | Delete

* @since 1.7.5

[47] Fix | Delete

*/

[48] Fix | Delete

const COMPLETED = 'completed';

[49] Fix | Delete

[50] Fix | Delete

/**

[51] Fix | Delete

* Chunk size to use.

[52] Fix | Delete

* Specifies how many entries to convert in one db request.

[53] Fix | Delete

*

[54] Fix | Delete

* @since 1.7.5

[55] Fix | Delete

*/

[56] Fix | Delete

const CHUNK_SIZE = 5000;

[57] Fix | Delete

[58] Fix | Delete

/**

[59] Fix | Delete

* Chunk size of the migration task.

[60] Fix | Delete

* Specifies how many entry ids to load at once for further conversion.

[61] Fix | Delete

*

[62] Fix | Delete

* @since 1.7.5

[63] Fix | Delete

*/

[64] Fix | Delete

const TASK_CHUNK_SIZE = self::CHUNK_SIZE * 10;

[65] Fix | Delete

[66] Fix | Delete

/**

[67] Fix | Delete

* Entry handler.

[68] Fix | Delete

*

[69] Fix | Delete

* @since 1.7.5

[70] Fix | Delete

*

[71] Fix | Delete

* @var WPForms_Entry_Handler

[72] Fix | Delete

*/

[73] Fix | Delete

private $entry_handler;

[74] Fix | Delete

[75] Fix | Delete

/**

[76] Fix | Delete

* Entry meta handler.

[77] Fix | Delete

*

[78] Fix | Delete

* @since 1.7.5

[79] Fix | Delete

*

[80] Fix | Delete

* @var WPForms_Entry_Meta_Handler

[81] Fix | Delete

*/

[82] Fix | Delete

private $entry_meta_handler;

[83] Fix | Delete

[84] Fix | Delete

/**

[85] Fix | Delete

* Temporary table name.

[86] Fix | Delete

*

[87] Fix | Delete

* @since 1.7.5

[88] Fix | Delete

*

[89] Fix | Delete

* @var string

[90] Fix | Delete

*/

[91] Fix | Delete

private $temp_table_name;

[92] Fix | Delete

[93] Fix | Delete

/**

[94] Fix | Delete

* Class constructor.

[95] Fix | Delete

*

[96] Fix | Delete

* @since 1.7.5

[97] Fix | Delete

*/

[98] Fix | Delete

public function __construct() {

[99] Fix | Delete

[100] Fix | Delete

parent::__construct( self::ACTION );

[101] Fix | Delete

}

[102] Fix | Delete

[103] Fix | Delete

/**

[104] Fix | Delete

* Initialize the task with all the proper checks.

[105] Fix | Delete

*

[106] Fix | Delete

* @since 1.7.5

[107] Fix | Delete

*/

[108] Fix | Delete

public function init() {

[109] Fix | Delete

[110] Fix | Delete

global $wpdb;

[111] Fix | Delete

[112] Fix | Delete

$this->entry_handler = wpforms()->obj( 'entry' );

[113] Fix | Delete

$this->entry_meta_handler = wpforms()->obj( 'entry_meta' );

[114] Fix | Delete

$this->temp_table_name = "{$wpdb->prefix}wpforms_temp_entry_ids";

[115] Fix | Delete

[116] Fix | Delete

if ( ! $this->entry_handler || ! $this->entry_meta_handler ) {

[117] Fix | Delete

return;

[118] Fix | Delete

}

[119] Fix | Delete

[120] Fix | Delete

// Bail out if migration is not started or completed.

[121] Fix | Delete

$status = get_option( self::STATUS );

[122] Fix | Delete

[123] Fix | Delete

if ( ! $status || $status === self::COMPLETED ) {

[124] Fix | Delete

return;

[125] Fix | Delete

}

[126] Fix | Delete

[127] Fix | Delete

$this->hooks();

[128] Fix | Delete

[129] Fix | Delete

if ( $status === self::START ) {

[130] Fix | Delete

// Mark that migration is in progress.

[131] Fix | Delete

update_option( self::STATUS, self::IN_PROGRESS );

[132] Fix | Delete

[133] Fix | Delete

// Alter entry meta table.

[134] Fix | Delete

$this->alter_entry_meta_table();

[135] Fix | Delete

[136] Fix | Delete

// Init migration.

[137] Fix | Delete

$this->init_migration();

[138] Fix | Delete

}

[139] Fix | Delete

}

[140] Fix | Delete

[141] Fix | Delete

/**

[142] Fix | Delete

* Modify field in the entry meta table.

[143] Fix | Delete

*

[144] Fix | Delete

* @since 1.7.5

[145] Fix | Delete

*/

[146] Fix | Delete

private function alter_entry_meta_table() {

[147] Fix | Delete

[148] Fix | Delete

global $wpdb;

[149] Fix | Delete

[150] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[151] Fix | Delete

$wpdb->query( "ALTER TABLE {$this->entry_meta_handler->table_name} MODIFY type VARCHAR(255)" );

[152] Fix | Delete

}

[153] Fix | Delete

[154] Fix | Delete

/**

[155] Fix | Delete

* Add index to a table.

[156] Fix | Delete

*

[157] Fix | Delete

* @since 1.7.5

[158] Fix | Delete

*

[159] Fix | Delete

* @param string $table_name Table.

[160] Fix | Delete

* @param string $index_name Index name.

[161] Fix | Delete

* @param string $key_part Key part.

[162] Fix | Delete

*

[163] Fix | Delete

* @return void

[164] Fix | Delete

*/

[165] Fix | Delete

private function add_index( $table_name, $index_name, $key_part ) {

[166] Fix | Delete

[167] Fix | Delete

global $wpdb;

[168] Fix | Delete

[169] Fix | Delete

// Check id index already exists.

[170] Fix | Delete

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[171] Fix | Delete

$result = $wpdb->get_var(

[172] Fix | Delete

"SELECT COUNT(1) IndexIsThere

[173] Fix | Delete

FROM INFORMATION_SCHEMA.STATISTICS

[174] Fix | Delete

WHERE table_schema = DATABASE()

[175] Fix | Delete

AND table_name = '$table_name'

[176] Fix | Delete

AND index_name = '$index_name'"

[177] Fix | Delete

);

[178] Fix | Delete

[179] Fix | Delete

if ( $result === '1' ) {

[180] Fix | Delete

return;

[181] Fix | Delete

}

[182] Fix | Delete

[183] Fix | Delete

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[184] Fix | Delete

[185] Fix | Delete

// Change the column length for the wp_wpforms_entry_meta.type column to 255 and add an index.

[186] Fix | Delete

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[187] Fix | Delete

$wpdb->query( "CREATE INDEX $index_name ON $table_name ( $key_part )" );

[188] Fix | Delete

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[189] Fix | Delete

}

[190] Fix | Delete

[191] Fix | Delete

/**

[192] Fix | Delete

* Add hooks.

[193] Fix | Delete

*

[194] Fix | Delete

* @since 1.7.5

[195] Fix | Delete

*/

[196] Fix | Delete

private function hooks() {

[197] Fix | Delete

[198] Fix | Delete

// Register the migrate action.

[199] Fix | Delete

add_action( self::ACTION, [ $this, 'migrate' ] );

[200] Fix | Delete

[201] Fix | Delete

// Register after process queue action.

[202] Fix | Delete

add_action( 'action_scheduler_after_process_queue', [ $this, 'after_process_queue' ] );

[203] Fix | Delete

}

[204] Fix | Delete

[205] Fix | Delete

/**

[206] Fix | Delete

* Migrate an entry.

[207] Fix | Delete

*

[208] Fix | Delete

* @param int $action_index Action index.

[209] Fix | Delete

*

[210] Fix | Delete

* @since 1.7.5

[211] Fix | Delete

*/

[212] Fix | Delete

public function migrate( $action_index ) {

[213] Fix | Delete

[214] Fix | Delete

global $wpdb;

[215] Fix | Delete

[216] Fix | Delete

$db_indexes = [

[217] Fix | Delete

- 3 => [

[218] Fix | Delete

'table_name' => $this->entry_meta_handler->table_name,

[219] Fix | Delete

'index_name' => 'form_id',

[220] Fix | Delete

'key_part' => 'form_id',

[221] Fix | Delete

],

[222] Fix | Delete

- 2 => [

[223] Fix | Delete

'table_name' => $this->entry_meta_handler->table_name,

[224] Fix | Delete

'index_name' => 'type',

[225] Fix | Delete

'key_part' => 'type',

[226] Fix | Delete

],

[227] Fix | Delete

- 1 => [

[228] Fix | Delete

'table_name' => $this->entry_meta_handler->table_name,

[229] Fix | Delete

'index_name' => 'data',

[230] Fix | Delete

'key_part' => 'data(32)',

[231] Fix | Delete

],

[232] Fix | Delete

];

[233] Fix | Delete

[234] Fix | Delete

// We create indexes in the background as it could take significant time on a big database.

[235] Fix | Delete

if ( array_key_exists( $action_index, $db_indexes ) ) {

[236] Fix | Delete

$this->add_index(

[237] Fix | Delete

$db_indexes[ $action_index ]['table_name'],

[238] Fix | Delete

$db_indexes[ $action_index ]['index_name'],

[239] Fix | Delete

$db_indexes[ $action_index ]['key_part']

[240] Fix | Delete

);

[241] Fix | Delete

[242] Fix | Delete

return;

[243] Fix | Delete

}

[244] Fix | Delete

[245] Fix | Delete

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[246] Fix | Delete

[247] Fix | Delete

// The query length in migrate_payment_data() is about 500 chars for 1 entry (7 metas).

[248] Fix | Delete

// The length of the query is defined by MAX_ALLOWED_PACKET variable, which defaults to 4 MB on MySQL 5.7.

[249] Fix | Delete

// We increase MAX_ALLOWED_PACKET variable to fit the number of entries specified in self::CHUNK_SIZE.

[250] Fix | Delete

$new_max_allowed_packet = 500 * self::CHUNK_SIZE;

[251] Fix | Delete

$max_allowed_packet = (int) $wpdb->get_var( "SHOW VARIABLES LIKE 'MAX_ALLOWED_PACKET'", 1 );

[252] Fix | Delete

[253] Fix | Delete

if ( $new_max_allowed_packet > $max_allowed_packet ) {

[254] Fix | Delete

$wpdb->query( "SET MAX_ALLOWED_PACKET = $new_max_allowed_packet" );

[255] Fix | Delete

}

[256] Fix | Delete

[257] Fix | Delete

// Using OFFSET makes a way longer request, as MySQL has to access all rows before OFFSET.

[258] Fix | Delete

// We follow very fast way with indexed column (id > $action_index).

[259] Fix | Delete

$entry_ids = $wpdb->get_col(

[260] Fix | Delete

$wpdb->prepare(

[261] Fix | Delete

"SELECT entry_id FROM $this->temp_table_name

[262] Fix | Delete

WHERE id > %d LIMIT %d",

[263] Fix | Delete

$action_index,

[264] Fix | Delete

self::TASK_CHUNK_SIZE

[265] Fix | Delete

)

[266] Fix | Delete

);

[267] Fix | Delete

[268] Fix | Delete

$i = 0;

[269] Fix | Delete

$entry_ids_count = count( $entry_ids );

[270] Fix | Delete

[271] Fix | Delete

// This cycle is twice less memory consuming than array_chunk( $entry_ids ).

[272] Fix | Delete

while ( $i < $entry_ids_count ) {

[273] Fix | Delete

$entry_ids_chunk = array_slice( $entry_ids, $i, self::CHUNK_SIZE );

[274] Fix | Delete

[275] Fix | Delete

$this->migrate_payment_data( implode( ',', $entry_ids_chunk ) );

[276] Fix | Delete

[277] Fix | Delete

$i += self::CHUNK_SIZE;

[278] Fix | Delete

}

[279] Fix | Delete

[280] Fix | Delete

if ( $new_max_allowed_packet > $max_allowed_packet ) {

[281] Fix | Delete

$wpdb->query( "SET MAX_ALLOWED_PACKET = $max_allowed_packet" );

[282] Fix | Delete

}

[283] Fix | Delete

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[284] Fix | Delete

}

[285] Fix | Delete

[286] Fix | Delete

/**

[287] Fix | Delete

* After process queue action.

[288] Fix | Delete

* Set status as completed.

[289] Fix | Delete

*

[290] Fix | Delete

* @since 1.7.5

[291] Fix | Delete

*/

[292] Fix | Delete

public function after_process_queue() {

[293] Fix | Delete

[294] Fix | Delete

$tasks = wpforms()->obj( 'tasks' );

[295] Fix | Delete

[296] Fix | Delete

if ( ! $tasks || $tasks->is_scheduled( self::ACTION ) ) {

[297] Fix | Delete

return;

[298] Fix | Delete

}

[299] Fix | Delete

[300] Fix | Delete

$this->drop_temp_table();

[301] Fix | Delete

[302] Fix | Delete

// Mark that migration is finished.

[303] Fix | Delete

update_option( self::STATUS, self::COMPLETED );

[304] Fix | Delete

}

[305] Fix | Delete

[306] Fix | Delete

/**

[307] Fix | Delete

* Init migration.

[308] Fix | Delete

*

[309] Fix | Delete

* @since 1.7.5

[310] Fix | Delete

* @noinspection PhpUndefinedFunctionInspection

[311] Fix | Delete

*/

[312] Fix | Delete

private function init_migration() {

[313] Fix | Delete

[314] Fix | Delete

// Get all payment entries.

[315] Fix | Delete

$count = $this->get_unprocessed_payment_entry_ids();

[316] Fix | Delete

[317] Fix | Delete

if ( ! $count ) {

[318] Fix | Delete

$this->drop_temp_table();

[319] Fix | Delete

}

[320] Fix | Delete

[321] Fix | Delete

// We need 3 preliminary steps to create indexes.

[322] Fix | Delete

$index = - 3;

[323] Fix | Delete

[324] Fix | Delete

while ( $index < $count ) {

[325] Fix | Delete

// We do not use Task class here as we do not need meta. So, we reduce the number of DB requests.

[326] Fix | Delete

as_enqueue_async_action(

[327] Fix | Delete

self::ACTION,

[328] Fix | Delete

[ $index ],

[329] Fix | Delete

Tasks::GROUP

[330] Fix | Delete

);

[331] Fix | Delete

[332] Fix | Delete

$index = $index < 0 ? $index + 1 : $index + self::CHUNK_SIZE;

[333] Fix | Delete

}

[334] Fix | Delete

}

[335] Fix | Delete

[336] Fix | Delete

/**

[337] Fix | Delete

* Migrate payment data to the correct table.

[338] Fix | Delete

*

[339] Fix | Delete

* @param string $entry_ids_list List of entry ids.

[340] Fix | Delete

*

[341] Fix | Delete

* @since 1.7.5

[342] Fix | Delete

*/

[343] Fix | Delete

private function migrate_payment_data( $entry_ids_list ) {

[344] Fix | Delete

[345] Fix | Delete

global $wpdb;

[346] Fix | Delete

[347] Fix | Delete

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[348] Fix | Delete

$wpdb->query(

[349] Fix | Delete

"SELECT entry_id, form_id, user_id, status, meta, date

[350] Fix | Delete

FROM {$this->entry_handler->table_name}

[351] Fix | Delete

WHERE entry_id IN ( $entry_ids_list )"

[352] Fix | Delete

);

[353] Fix | Delete

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[354] Fix | Delete

[355] Fix | Delete

$values = [];

[356] Fix | Delete

[357] Fix | Delete

foreach ( $wpdb->last_result as $entry ) {

[358] Fix | Delete

$meta = json_decode( $entry->meta, true );

[359] Fix | Delete

[360] Fix | Delete

if ( ! is_array( $meta ) ) {

[361] Fix | Delete

continue;

[362] Fix | Delete

}

[363] Fix | Delete

[364] Fix | Delete

foreach ( $meta as $meta_key => $meta_value ) {

[365] Fix | Delete

// If meta_key doesn't begin with `payment_`, prefix it.

[366] Fix | Delete

$meta_key = strpos( $meta_key, 'payment_' ) === 0 ? $meta_key : "payment_$meta_key";

[367] Fix | Delete

[368] Fix | Delete

// We do not use $wpdb->prepare here, as it is 5 times slower.

[369] Fix | Delete

// Prepare takes 1.3 sec to prepare 1000 entries (6000 meta records).

[370] Fix | Delete

// It is incomparable with the two queries here.

[371] Fix | Delete

// With sprintf, the total processing time of this method is 0.15 sec for 1000 entries.

[372] Fix | Delete

$values[] = sprintf(

[373] Fix | Delete

"( %d, %d, %d, '%s', '%s', '%s', '%s' )",

[374] Fix | Delete

$entry->entry_id,

[375] Fix | Delete

$entry->form_id,

[376] Fix | Delete

$entry->user_id,

[377] Fix | Delete

$entry->status,

[378] Fix | Delete

$meta_key,

[379] Fix | Delete

$meta_value,

[380] Fix | Delete

$entry->date

[381] Fix | Delete

);

[382] Fix | Delete

}

[383] Fix | Delete

}

[384] Fix | Delete

[385] Fix | Delete

// Bail out if there is no found payment meta.

[386] Fix | Delete

if ( empty( $values ) ) {

[387] Fix | Delete

return;

[388] Fix | Delete

}

[389] Fix | Delete

[390] Fix | Delete

$values = implode( ', ', $values );

[391] Fix | Delete

[392] Fix | Delete

// The following query length is about 500 chars for 1 entry (7 metas).

[393] Fix | Delete

[394] Fix | Delete

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[395] Fix | Delete

$wpdb->query(

[396] Fix | Delete

"INSERT INTO {$this->entry_meta_handler->table_name}

[397] Fix | Delete

( entry_id, form_id, user_id, status, type, data, date )

[398] Fix | Delete

VALUES $values"

[399] Fix | Delete

);

[400] Fix | Delete

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

[401] Fix | Delete

}

[402] Fix | Delete

[403] Fix | Delete

/**

[404] Fix | Delete

* Get entry ids which do not have relevant entry field records.

[405] Fix | Delete

* Store them in a temporary table.

[406] Fix | Delete

*

[407] Fix | Delete

* @since 1.7.5

[408] Fix | Delete

*

[409] Fix | Delete

* @return int

[410] Fix | Delete

*/

[411] Fix | Delete

private function get_unprocessed_payment_entry_ids() {

[412] Fix | Delete

[413] Fix | Delete

global $wpdb;

[414] Fix | Delete

[415] Fix | Delete

$this->drop_temp_table();

[416] Fix | Delete

[417] Fix | Delete

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[418] Fix | Delete

$wpdb->query(

[419] Fix | Delete

"CREATE TABLE $this->temp_table_name

[420] Fix | Delete

(

[421] Fix | Delete

id BIGINT AUTO_INCREMENT PRIMARY KEY,

[422] Fix | Delete

entry_id BIGINT NOT NULL

[423] Fix | Delete

)"

[424] Fix | Delete

);

[425] Fix | Delete

[426] Fix | Delete

$wpdb->query(

[427] Fix | Delete

"INSERT INTO $this->temp_table_name (entry_id)

[428] Fix | Delete

SELECT entry_id

[429] Fix | Delete

FROM {$this->entry_handler->table_name}

[430] Fix | Delete

WHERE type = 'payment'

[431] Fix | Delete

AND entry_id NOT IN

[432] Fix | Delete

(SELECT entry_id FROM {$this->entry_meta_handler->table_name} WHERE type LIKE 'payment_%')"

[433] Fix | Delete

);

[434] Fix | Delete

[435] Fix | Delete

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[436] Fix | Delete

[437] Fix | Delete

return $wpdb->rows_affected;

[438] Fix | Delete

}

[439] Fix | Delete

[440] Fix | Delete

/**

[441] Fix | Delete

* Drop a temporary table.

[442] Fix | Delete

*

[443] Fix | Delete

* @since 1.7.5

[444] Fix | Delete

*/

[445] Fix | Delete

private function drop_temp_table() {

[446] Fix | Delete

[447] Fix | Delete

global $wpdb;

[448] Fix | Delete

[449] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.SchemaChange

[450] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS $this->temp_table_name" );

[451] Fix | Delete

}

[452] Fix | Delete

}

[453] Fix | Delete

[454] Fix | Delete