Changeset 53482 for trunk/tests/phpunit/tests/query.php

Timestamp:

06/10/2022 01:37:52 PM (2 years ago)

Author:

spacedmonkey

Message:

Prime users cache in WP_Query and post REST API controller.

For a call to WP_Query or a post REST API request that contains posts from multiple authors, call the cache_users function, to ensure that all user data for post authors is primed in
a single database query. This results in far fewer database queries on multiple author sites.

Props spacedmonkey, timothyblynjacobs, peterwilsoncc.
Fixes #55716.

File:

• trunk/tests/phpunit/tests/query.php (modified) (1 diff)

trunk/tests/phpunit/tests/query.php

@@ -622 +622 @@
 
     /**
+     * @ticket 55716
+     */
+    public function test_prime_user_cache() {
+        $action = new MockAction();
+        add_filter( 'update_user_metadata_cache', array( $action, 'filter' ), 10, 2 );
+        $user_ids = array();
+        $count    = 5;
+        for ( $i = 0; $i < $count; $i ++ ) {
+            $user_ids[ $i ] = self::factory()->user->create();
+            self::factory()->post->create(
+                array(
+                    'post_type'   => 'post',
+                    'post_author' => $user_ids[ $i ],
+                )
+            );
+        }
+
+        $q = new WP_Query(
+            array(
+                'post_type'      => 'post',
+                'posts_per_page' => $count,
+            )
+        );
+        while ( $q->have_posts() ) {
+            $q->the_post();
+        }
+
+        $args      = $action->get_args();
+        $last_args = end( $args );
+        $this->assertSameSets( $user_ids, $last_args[1], 'Ensure that user ids are primed' );
+    }
+
+    /**
      * @ticket 35601
      */