Changeset 40115

Timestamp:

02/24/2017 10:02:48 PM (8 years ago)

Author:

SergeyBiryukov

Message:

REST API: Shim post_date_gmt for drafts / empty dates in the REST API.

Internally, WordPress uses a special post_date_gmt value of 0000-00-00 00:00:00 to indicate that a draft's date is "floating" and should be updated whenever the post is saved. This makes it much more difficult for API clients to know the correct date of a draft post.

This commit provides a best guess at a date_gmt value for draft posts in this situation using the date field and the site's current timezone offset.

Props joehoyle, jnylen0.
Merges [40108] to the 4.7 branch.
Fixes #38883.

Location:

branches/4.7

Files:

• . (modified) (1 prop)
• src/wp-includes/rest-api/endpoints/class-wp-rest-posts-controller.php (modified) (2 diffs)
• tests/phpunit/includes/testcase-rest-post-type-controller.php (modified) (2 diffs)
• tests/phpunit/tests/rest-api/rest-posts-controller.php (modified) (5 diffs)

branches/4.7/src/wp-includes/rest-api/endpoints/class-wp-rest-posts-controller.php

@@ -1386 +1386 @@
 
         if ( ! empty( $schema['properties']['date_gmt'] ) ) {
-            $data['date_gmt'] = $this->prepare_date_response( $post->post_date_gmt );
+            // For drafts, `post_date_gmt` may not be set, indicating that the
+            // date of the draft should be updated each time it is saved (see
+            // #38883).  In this case, shim the value based on the `post_date`
+            // field with the site's timezone offset applied.
+            if ( '0000-00-00 00:00:00' === $post->post_date_gmt ) {
+                $post_date_gmt = date( 'Y-m-d H:i:s', strtotime( $post->post_date ) - ( get_option( 'gmt_offset' ) * 3600 ) );
+            } else {
+                $post_date_gmt = $post->post_date_gmt;
+            }
+            $data['date_gmt'] = $this->prepare_date_response( $post_date_gmt );
         }
 
@@ -1402 +1411 @@
 
         if ( ! empty( $schema['properties']['modified_gmt'] ) ) {
-            $data['modified_gmt'] = $this->prepare_date_response( $post->post_modified_gmt );
+            // For drafts, `post_modified_gmt` may not be set (see
+            // `post_date_gmt` comments above).  In this case, shim the value
+            // based on the `post_modified` field with the site's timezone
+            // offset applied.
+            if ( '0000-00-00 00:00:00' === $post->post_modified_gmt ) {
+                $post_modified_gmt = date( 'Y-m-d H:i:s', strtotime( $post->post_modified ) - ( get_option( 'gmt_offset' ) * 3600 ) );
+            } else {
+                $post_modified_gmt = $post->post_modified_gmt;
+            }
+            $data['modified_gmt'] = $this->prepare_date_response( $post_modified_gmt );
         }
 

branches/4.7/tests/phpunit/includes/testcase-rest-post-type-controller.php

@@ -11 +11 @@
         $this->assertEquals( get_permalink( $post->ID ), $data['link'] );
         if ( '0000-00-00 00:00:00' === $post->post_date_gmt ) {
-            $this->assertNull( $data['date_gmt'] );
+            $post_date_gmt = date( 'Y-m-d H:i:s', strtotime( $post->post_date ) - ( get_option( 'gmt_offset' ) * 3600 ) );
+            $this->assertEquals( mysql_to_rfc3339( $post_date_gmt ), $data['date_gmt'] );
+        } else {
+            $this->assertEquals( mysql_to_rfc3339( $post->post_date_gmt ), $data['date_gmt'] );
         }
         $this->assertEquals( mysql_to_rfc3339( $post->post_date ), $data['date'] );
 
         if ( '0000-00-00 00:00:00' === $post->post_modified_gmt ) {
-            $this->assertNull( $data['modified_gmt'] );
+            $post_modified_gmt = date( 'Y-m-d H:i:s', strtotime( $post->post_modified ) - ( get_option( 'gmt_offset' ) * 3600 ) );
+            $this->assertEquals( mysql_to_rfc3339( $post_modified_gmt ), $data['modified_gmt'] );
+        } else {
+            $this->assertEquals( mysql_to_rfc3339( $post->post_modified_gmt ), $data['modified_gmt'] );
         }
         $this->assertEquals( mysql_to_rfc3339( $post->post_modified ), $data['modified'] );
@@ -140 +146 @@
         if ( 'edit' === $context ) {
             $this->assertEquals( $post->guid, $data['guid']['raw'] );
-
-            if ( '0000-00-00 00:00:00' === $post->post_date_gmt ) {
-                $this->assertNull( $data['date_gmt'] );
-            } else {
-                $this->assertEquals( mysql_to_rfc3339( $post->post_date_gmt ), $data['date_gmt'] );
-            }
-
-            if ( '0000-00-00 00:00:00' === $post->post_modified_gmt ) {
-                $this->assertNull( $data['modified_gmt'] );
-            } else {
-                $this->assertEquals( mysql_to_rfc3339( $post->post_modified_gmt ), $data['modified_gmt'] );
-            }
         }
 

branches/4.7/tests/phpunit/tests/rest-api/rest-posts-controller.php

@@ -1196 +1196 @@
 
         $this->assertEquals( $results['date_gmt'], $data['date_gmt'] );
-        // TODO expect null here for drafts (see https://core.trac.wordpress.org/ticket/5698#comment:14)
         $post_date_gmt = str_replace( 'T', ' ', $results['date_gmt'] );
         $this->assertEquals( $post_date_gmt, $post->post_date_gmt );
@@ -1295 +1294 @@
     public function test_create_post_as_contributor() {
         wp_set_current_user( self::$contributor_id );
-
-        $request = new WP_REST_Request( 'POST', '/wp/v2/posts' );
-        $params = $this->set_post_data(array(
+        update_option( 'timezone_string', 'America/Chicago' );
+
+        $request = new WP_REST_Request( 'POST', '/wp/v2/posts' );
+        $params = $this->set_post_data( array(
+            // This results in a special `post_date_gmt` value of
+            // '0000-00-00 00:00:00'.  See #38883.
             'status' => 'pending',
-        ));
-
-        $request->set_body_params( $params );
-        $response = $this->server->dispatch( $request );
+        ) );
+
+        $request->set_body_params( $params );
+        $response = $this->server->dispatch( $request );
+        $this->assertEquals( 201, $response->get_status() );
+
+        $data = $response->get_data();
+        $post = get_post( $data['id'] );
+        $this->assertEquals( '0000-00-00 00:00:00', $post->post_date_gmt );
+        $this->assertNotEquals( '0000-00-00T00:00:00', $data['date_gmt'] );
+
         $this->check_create_post_response( $response );
+
+        update_option( 'timezone_string', '' );
     }
 
@@ -1376 +1387 @@
         $this->assertEquals( 'draft', $data['status'] );
         $this->assertEquals( 'draft', $new_post->post_status );
-        // Confirm dates are null
-        $this->assertNull( $data['date_gmt'] );
-        $this->assertNull( $data['modified_gmt'] );
+        // Confirm dates are shimmed for gmt_offset
+        $post_modified_gmt = date( 'Y-m-d H:i:s', strtotime( $new_post->post_modified ) + ( get_option( 'gmt_offset' ) * 3600 ) );
+        $post_date_gmt = date( 'Y-m-d H:i:s', strtotime( $new_post->post_date ) + ( get_option( 'gmt_offset' ) * 3600 ) );
+
+        $this->assertEquals( mysql_to_rfc3339( $post_modified_gmt ), $data['modified_gmt'] );
+        $this->assertEquals( mysql_to_rfc3339( $post_date_gmt ), $data['date_gmt'] );
     }
 
@@ -2063 +2077 @@
 
         $this->assertEquals( $results['date_gmt'], $data['date_gmt'] );
-        // TODO expect null here for drafts (see https://core.trac.wordpress.org/ticket/5698#comment:14)
         $post_date_gmt = str_replace( 'T', ' ', $results['date_gmt'] );
         $this->assertEquals( $post_date_gmt, $post->post_date_gmt );
@@ -2092 +2105 @@
 
         $this->assertErrorResponse( 'rest_invalid_param', $response, 400 );
+    }
+
+    public function test_empty_post_date_gmt_shimmed_using_post_date() {
+        global $wpdb;
+
+        wp_set_current_user( self::$editor_id );
+        update_option( 'timezone_string', 'America/Chicago' );
+
+        // Need to set dates using wpdb directly because `wp_update_post` and
+        // `wp_insert_post` have additional validation on dates.
+        $post_id = $this->factory->post->create();
+        $wpdb->update(
+            $wpdb->posts,
+            array(
+                'post_date'     => '2016-02-23 12:00:00',
+                'post_date_gmt' => '0000-00-00 00:00:00',
+            ),
+            array(
+                'ID' => $post_id,
+            ),
+            array( '%s', '%s' ),
+            array( '%d' )
+        );
+        wp_cache_delete( $post_id, 'posts' );
+
+        $post = get_post( $post_id );
+        $this->assertEquals( $post->post_date,     '2016-02-23 12:00:00' );
+        $this->assertEquals( $post->post_date_gmt, '0000-00-00 00:00:00' );
+
+        $request = new WP_REST_Request( 'GET', sprintf( '/wp/v2/posts/%d', $post_id ) );
+        $response = $this->server->dispatch( $request );
+        $this->assertEquals( 200, $response->get_status() );
+        $data = $response->get_data();
+
+        $this->assertEquals( '2016-02-23T12:00:00', $data['date'] );
+        $this->assertEquals( '2016-02-23T18:00:00', $data['date_gmt'] );
+
+        $request = new WP_REST_Request( 'PUT', sprintf( '/wp/v2/posts/%d', $post_id ) );
+        $request->set_param( 'date', '2016-02-23T13:00:00' );
+        $response = $this->server->dispatch( $request );
+        $this->assertEquals( 200, $response->get_status() );
+        $data = $response->get_data();
+
+        $this->assertEquals( '2016-02-23T13:00:00', $data['date'] );
+        $this->assertEquals( '2016-02-23T19:00:00', $data['date_gmt'] );
+
+        $post = get_post( $post_id );
+        $this->assertEquals( $post->post_date,     '2016-02-23 13:00:00' );
+        $this->assertEquals( $post->post_date_gmt, '2016-02-23 19:00:00' );
+
+        update_option( 'timezone_string', '' );
     }