Skip to content

Instantly share code, notes, and snippets.

@stephenfeather

stephenfeather/class-delete-schema-command.php

Created July 6, 2023 21:04
Show Gist options
  • Save stephenfeather/e83a0bee464155698ea574e9f0fe7c16 to your computer and use it in GitHub Desktop.
Save stephenfeather/e83a0bee464155698ea574e9f0fe7c16 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. stephenfeather created this gist Jul 6, 2023.
    90 changes: 90 additions & 0 deletions class-delete-schema-command.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,90 @@
    <?php
    /**
    * Plugin Name: Delete Schema WP-CLI Command
    * Description: Deletes 'rank_math_rich_snippet' meta key and runs delete_schema function for WooCommerce products with 'rank_math_schema_Off' value.
    * Version: 1.0.0
    * Author: Stephen Feather
    * Copywrite: 2023 Stephen Feather
    * License: GPL2
    *
    * @comment As a Rank Math Pro customer we were pretty pissed to find over 60k products with schema disabled. This plugin is a one-off to fix that.
    */

    if ( ! defined( 'WP_CLI' ) || ! WP_CLI ) {
    return;
    }

    /**
    * Delete Schema Command.
    */
    class Delete_Schema_Command {

    /**
    * Deletes 'rank_math_rich_snippet' meta key and runs delete_schema function for WooCommerce products with 'rank_math_schema_Off' value.
    *
    * ## EXAMPLES
    *
    * wp delete-schema
    *
    * @when after_wp_load
    */
    public function __invoke() {
    global $wpdb;

    // Get product IDs with 'rank_math_schema_Off' meta value.
    $product_ids = $wpdb->get_col(
    $wpdb->prepare(
    "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = %s ORDER BY post_id ASC",
    'rank_math_schema_Off'
    )
    );

    $current_count = 1;
    $deleted_count = 0;
    $failed_count = 0;

    // Delete 'rank_math_rich_snippet' meta key and run delete_schema function for each product.
    foreach ( $product_ids as $product_id ) {
    WP_CLI::log( sprintf( 'Deleting rank_math_rich_snippet and rank_math_schema_Off for product %d of %d.', $current_count, count( $product_ids ) ) );
    $current_count++;
    // Delete 'rank_math_rich_snippet' meta key.
    delete_post_meta( $product_id, 'rank_math_rich_snippet' );
    $delete_schema_status = $this->delete_schema( $product_id );
    // Run delete_schema function.
    if ( $delete_schema_status ) {
    $deleted_count++;
    } else {
    $failed_count++;
    }
    }

    $total_count = count( $product_ids );

    $summary_message = sprintf(
    'rank_math_schema_Off removed for %d out of %d WooCommerce products. %d deletions failed.',
    $deleted_count,
    $total_count,
    $failed_count
    );

    WP_CLI::success( $summary_message );
    }

    /**
    * Runs the delete_schema function for a given product ID.
    *
    * @param int $product_id The ID of the product to run delete_schema for.
    * @return bool True if successful, false if failed.
    */
    public function delete_schema( $product_id ) {
    // Perform actions in the delete_schema function.
    global $wpdb;
    $where = $wpdb->prepare( 'WHERE post_id = %d AND meta_key LIKE %s', $product_id, $wpdb->esc_like( 'rank_math_schema_' ) . '%' );
    $result = $wpdb->query( "DELETE FROM {$wpdb->postmeta} {$where}" ); // phpcs:ignore
    return false !== $result;
    }
    }

    if ( defined( 'WP_CLI' ) && WP_CLI ) {
    WP_CLI::add_command( 'delete-schema', 'Delete_Schema_Command' );
    }