Find latest/published version of post using wp-cli

Answering my own question, the current revision has these properties as compared to revisions:

  • The post_status will be “publish” not “inherit”.
  • The post_parent will be 0
  • The post_type will be “post” not “revision”.

Additionally, the ID of the current revision doesn’t change when you update the post; instead, the older version is given a new ID.

Example:

  • I created a post called “test post” with content “this is revision one.”. It was assigned ID 28623. When I did “wp post get 28623”, the interesting part of the output was:

ID      28623
post_date       2017-12-13 16:26:02
post_content    this is revision one.
post_title      test post
post_status     publish
comment_status  open
ping_status     open
post_name       test-post
post_modified   2017-12-13 16:26:02
post_parent     0
post_type       post
  • I then edited the content to read “this is revision two” and did “wp post get 28623” again. The results this time:

ID      28623
post_date       2017-12-13 16:26:02
post_content    this is revision two.
post_title      test post
post_status     publish
comment_status  open
ping_status     open
post_name       test-post
post_modified   2017-12-13 16:28:47
post_parent     0
post_type       post

Notice that post id 28623 itself has changed fields, and the live version if still id 28623. The post_date remains the same but the post_modified has changed.

What happened to the old version? I did “wp post get 28624”. The results:


ID      28624
post_date       2017-12-13 16:26:02
post_content    this is revision one.
post_title      test post
post_status     inherit
comment_status  closed
ping_status     closed
post_name       28623-revision-v1
post_modified   2017-12-13 16:26:02
post_parent     28623
post_type       revision

The old version has been copied to a new row in the database. Note that there’s no guarantee that the revision will have the ID immediately following the original post’s id: wordpress will just use the next available id (it worked in my case because I didn’t make any posts between the post and its revision).

  • Additionally:

    • the post_status is now “inherit”, not “publish”

    • the post_type is “revision” not “post”

    • the post_parent is 28623, not 0

    • the post_name has changed to “28623-revision-v1” instead of “test-post”, and no longer references the title. If the original post is at “(something)/test-post”, you might be tempted to visit “(something)/28623-revision-v1” to see the revision. However, WordPress will yield a “page not found” error, since it doesn’t allow end users to see revisions.

    • the post_modified is still equal to the post_date, since this was the original version

    • the “comment_status” and “ping_status” are now closed, since it wouldn’t make sense to comment on or ping a revision. Of course, live posts can also have these both be “closed”, but, if you allow comments/pings on a post, that permission will automatically be removed for older revisions.

  • I then reverted back to the original version, and did “wp post get 28623” to get:


ID      28623
post_author     1
post_date       2017-12-13 16:26:02
post_content    this is revision one.
post_title      test post
post_status     publish
comment_status  open
ping_status     open
post_name       test-post
post_modified   2017-12-13 16:46:20
post_type       post

Notice that the post has now returned to the original version, with one exception: the post_modified date no longer matches the post_date. In other words, if you modify a post and then modify it back, that’s considered two modifications, not an undo of a modification (you can see this in the admin interface by noticing the “revisions” count is now 3, not 1 or 2).

Another way to see this is to do “wp post get 28624”:


ID      28624
post_date       2017-12-13 16:26:02
post_content    this is revision one.
post_title      test post
post_status     inherit
comment_status  closed
ping_status     closed
post_name       28623-revision-v1
post_modified   2017-12-13 16:26:02
post_parent     28623
post_type       revision

Notice that, even though we’ve reverted to version 1, a separate copy of version 1 exists as a revision. Version 2 was given a new id as we see by doing “wp post get 28625”.


ID      28625
post_date       2017-12-13 16:28:47
post_content    this is revision two.
post_title      test post
post_status     inherit
comment_status  closed
ping_status     closed
post_name       28623-revision-v1
post_modified   2017-12-13 16:28:47
post_modified_gmt       2017-12-13 16:28:47
post_parent     28623
post_type       revision

Related Posts:

  1. Detect if WP is running under WP-CLI
  2. WP CLI “Error establishing a database connection” in localhost (MAMP)
  3. wp-cli Enabling Maintainance Mode
  4. How do I run a PHP script from WordPress environment, like `wp shell`?
  5. Using wp-cli can I not query pages by their title?
  6. wp-cli 0.14.1 MySQL error
  7. How to use wp-cli.yml file?
  8. WP cli –path does not seem to work
  9. Enable Auto-updates for all plugins using wp-cli? (since wordpress 5.5)
  10. How do I activate an mu-plugin with WP-CLI?
  11. How to create a WP-CLI command with $_POST?
  12. wp-cli doesn’t find and wordpress installation
  13. wp-cli import theme sample data
  14. WP-CLI works on non WP-CLI installed WordPress instance?
  15. What could cause WP-CLI search-replace to not replace all instances of a string?
  16. WPCLI – update plugins, themes, and core, all in one row, instead 3 rows?
  17. Using Travis CI to run unit tests and running phpunit locally [closed]
  18. “Could not open input file” error even when WP-CLI is in the path
  19. WP-CLI over SSH – wp command not found
  20. wp-cli create post and media import
  21. Import Media To CPT with CLI & Filter Custom Taxonomy
  22. wp-cli with MAMP shows sh: mysql: command not found
  23. What is the difference between the Package Language and the Site Language?
  24. PHP warning are displaying when using WP CLI [closed]
  25. WP CLI – show users whose ID is larger than given ID
  26. How can I replace all regex matches using the WP_CLI search-replace tool
  27. Is it possible to use WP-CLI via PHP-framework?
  28. What tools respect `.distignore`?
  29. How to prevent WP-CLI shell from exiting when an exception occurs?
  30. wp-cli silently fails with 255 when running wp core install
  31. wp-cli: run post generate and post meta add together
  32. Setting boolean and array values using wp theme mod set
  33. Ask WP-CLI latest core WordPress version released
  34. How can I get the WP-CLI eval-file command to report errors to stderr?
  35. WP CLI: there has been critical error
  36. In a continuous integration environment how do you implement the database entries for plugins and themes
  37. wp-cli: wp term generate xxxxx – Error: ‘xxxxx’ is not a registered taxonomy
  38. MAMP PRO WP-CLI Error: Error establishing a database connection
  39. “Class ‘Phar’ not found” error setting up WP-CLI with Cygwin
  40. Running WP-CLI without SSH
  41. WP CLI Shell not working on Windows
  42. How do you kill WP-CLI execution?
  43. Is it possible to delete a range of posts by ID with WP-CLI?
  44. How to specify to wp-cli for the `wp config create` (`wp core config`) command that the DB user is an ‘all hosts’ user?
  45. Formatting messed up when piping wp commands
  46. wpcli: Error on post_content or post_title if accents
  47. Lock User and Enforce Password change via wp-cli
  48. BackupBuddy WP CLI Invalid Profile Error
  49. WP CLI not outputting anything
  50. Only the WP CLI command, wp –info, runs under my cPanel account
  51. WP-CLI search-replace posts content for certain URLs
  52. Bulk remove custom post type and its attachments with wp-cli?
  53. Resetting internal WordPress state during its cycle
  54. WP-CLI can not find Url
  55. Running custom defined WP-CLI commands without WordPress installation present
  56. Wrong output order when mixing WP_CLI::API and php-cli-tools
  57. WP-CLI not working from Bash script
  58. MySQL 5.6 Causes Errors with WP CLI
  59. Using WP-CLI, how do I delete a post by title or slug, not ID?
  60. wp-cli only displays PHP version for all input options
  61. WP CLI: search and replace specific directory name of URL
  62. WP-CLI plugin install causes PHP fatal error – Using $this when not in object context
  63. How to delete a single post using wp cli in command line?
  64. Adding content from file with wp post create
  65. Why doesn’t ‘wp’ command work in my WP-CLI installation?
  66. How to move back a command in WP-CLI from wp shell?
  67. wp_clear_object_cache() is deprecated. What should I use instead?
  68. How to run wp cli from a wp hook?
  69. wp-cli PHP Notice after moving server behind load balancer
  70. What is the purpose of the “user” global parameter in wp-cli.yml config?
  71. One-click WP site generation wih wp-cli on Windows
  72. PHPUnit via WP-CLI: Warning: Cannot modify header information … bootstrap.php:68
  73. WP-CLI: Does “wp post create” will create post normally and will ping to Ping Service?
  74. Trying to install/configure wp-cli for WordPress
  75. Logs for WP CLI
  76. WP-Cli Autoloads Non-existant Framework
  77. Give WP-Cli User Home Directory Privileges
  78. How to add an array to a command “wp config set”?
  79. WP-CLI: detect altered core files and restore them automatically
  80. WP-CLI plugin activate – ‘activate’ is not a registered subcommand of ‘plugin’
  81. wp-cli core install unknown: fatal: file /etc/postfix/main.cf: parameter mail_owner: user postfix has same user ID as _postfix
  82. How to specify which editor is used when editing posts with WP-CLI?
  83. bash script wp-cli search-replace 0 replacements, but command-line 3000+
  84. Is WP-CLI safe to use in a hosting environment? Why?
  85. WP-CLI – How to install a plugin from a remote server
  86. How to fix “Not enough memory” on Windows 7 and PHP 7.2.0 (cli)
  87. Wp-cli from a plugin?
  88. Is it possible to update a single page using WP-CLI?
  89. Is it possible to use WP CLI to update a theme that is not in the WordPress Repo?
  90. Can I use WP-CLI from a remote computer?
  91. ignoring, hidding mu plugins when wp-cli is run
  92. Install WordPress using PHP
  93. How to install WordPress with Composer?
  94. wp-cli output ‘column display format’ / wrapping
  95. When might you need to specify the “url” argument/option in WP-CLI?
  96. WP-CLi Uable to Install / Update Plugins
  97. Remote Export DB w. WP-cli.phar Over SSH
  98. Post Count for Multisite?
  99. is it possible to use wp cli to export custom post types
  100. Why doesn’t “wp db cli” enable tab completion?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)