Display most recent options and post meta using wp cli

<?php
/**
 * Plugin Name: EA Recent DB
 * Description: Displays most recent options and post meta using wp cli
 * Version:     1.0.0
 * Author:      Bill Erickson & Jared Atchison
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License version 2, as published by the
 * Free Software Foundation.  You may NOT assume that you can use any other
 * version of the GPL.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.
 *
 * @package    EARecentDB
 * @since      1.0.0
 * @copyright  Copyright (c) 2014, Bill Erickson & Jared Atchison
 * @license    GPL-2.0+
 */

if ( ! ( defined('WP_CLI') && WP_CLI ) )
	return;

class EA_Recent_DB extends WP_CLI_Command {

    /**
     * Displays most recent entries in wp_options table
     * 
     * ## OPTIONS
     * 
     * [--count=<count>]
     * : How many to show
     * 
     * ## EXAMPLES
     * 
     *     wp recent-db option --count=5
     *
     * @synopsis [--count=<count>]
     */
    function option( $args, $assoc_args ) {
        $count = isset( $assoc_args['count'] ) && !empty( $assoc_args['count'] ) ? (int) $assoc_args['count'] : 1;

		// Get options
		global $wpdb;
		$results = $wpdb->get_results( 
			$wpdb->prepare( "SELECT * FROM $wpdb->options ORDER BY option_id DESC LIMIT 0, %d", (int) $count ),
			OBJECT
		);
		if( $results ) {
			$output = '';
			foreach( $results as $result )
				$output .= '
				
				Option ID: ' . $result->option_id . '
				Option Name: ' . $result->option_name . '
				Option Value: ' . $result->option_value . '
				';
		} else {
			$output = 'No results found';
		}
		
        // Print Results
        WP_CLI::success( $output );
    }

    /**
     * Displays most recent entries in wp_postmeta table
     * 
     * ## OPTIONS
     * 
     * [--count=<count>]
     * : How many to show
     *
     * [--post_id=<post_id>]
     * : Limit to meta associated with this post
     * 
     * ## EXAMPLES
     * 
     *     wp recent-db postmeta --count=5 --post_id=2
     *
     * @synopsis [--count=<count>] [--post_id=<post_id>]
     */
    function postmeta( $args, $assoc_args ) {
        $count = isset( $assoc_args['count'] ) && !empty( $assoc_args['count'] ) ? (int) $assoc_args['count'] : 1;
        $post_id = isset( $assoc_args['post_id'] ) && !empty( $assoc_args['post_id'] ) ? (int) $assoc_args['post_id'] : false;

		// Get post meta
		global $wpdb;
		if( $post_id ) {
			$results = $wpdb->get_results( 
				$wpdb->prepare( "SELECT * FROM $wpdb->postmeta WHERE post_id = %d ORDER BY meta_id DESC LIMIT 0, %d", $post_id, $count ),
				OBJECT
			);		
		} else {
			$results = $wpdb->get_results( 
				$wpdb->prepare( "SELECT * FROM $wpdb->postmeta ORDER BY meta_id DESC LIMIT 0, %d", $count ),
				OBJECT
			);		
		}
		if( $results ) {
			
			$output = '';
			foreach( $results as $result )
				$output .= '
				
				Meta ID: ' . $result->meta_id . '
				Post ID: ' . $result->post_id . '
				Meta Key: ' . $result->meta_key . '
				Meta Value: ' . $result->meta_value . '
				';
		} else {
			$output = 'No results found';
		}
		
        // Print Results
        WP_CLI::success( $output );
	}

}
WP_CLI::add_command( 'recent-db', 'EA_Recent_DB' );

Bill Erickson

Bill Erickson is a freelance WordPress developer and a contributing developer to the Genesis framework. For the past 14 years he has worked with attorneys, publishers, corporations, and non-profits, building custom websites tailored to their needs and goals.

Ready to upgrade your website?

I build custom WordPress websites that look great and are easy to manage.

Let's Talk