Changeset 34529 for trunk/tests/phpunit/tests/term/getTerms.php

Timestamp:

09/25/2015 03:58:59 AM (11 years ago)

Author:

boonebgorges

Message:

Introduce metadata for taxonomy terms.

Adds a new table to the database schema (wp_termmeta), and a set of
*_term_meta() API functions. get_terms() and wp_get_object_terms()
now also support 'meta_query' parameters, with syntax identical to other
uses of WP_Meta_Query.

When fetching terms via get_terms() or wp_get_object_terms(), metadata for
matched terms is preloaded into the cache by default. Disable this behavior
by setting the new $update_term_meta_cache paramater to false.

To maximize performance, within WP_Query loops, the termmeta cache is *not*
primed by default. Instead, we use a lazy-loading technique: metadata for all
terms belonging to posts in the loop is loaded into the cache the first time
that get_term_meta() is called within the loop.

Props boonebgorges, sirzooro.
See #10142.

File:

• trunk/tests/phpunit/tests/term/getTerms.php (modified) (3 diffs)

trunk/tests/phpunit/tests/term/getTerms.php

@@ -23 +23 @@
 
         // last_changed and num_queries should bump
-        $terms = get_terms( 'post_tag' );
+        $terms = get_terms( 'post_tag', array( 'update_term_meta_cache' => false ) );
         $this->assertEquals( 3, count( $terms ) );
         $time1 = wp_cache_get( 'last_changed', 'terms' );
@@ -32 +32 @@
 
         // Again. last_changed and num_queries should remain the same.
-        $terms = get_terms( 'post_tag' );
+        $terms = get_terms( 'post_tag', array( 'update_term_meta_cache' => false ) );
         $this->assertEquals( 3, count( $terms ) );
         $this->assertEquals( $time1, wp_cache_get( 'last_changed', 'terms' ) );
@@ -1503 +1503 @@
     }
 
+    /**
+     * @ticket 10142
+     */
+    public function test_termmeta_cache_should_be_primed_by_default() {
+        global $wpdb;
+
+        register_taxonomy( 'wptests_tax', 'post' );
+        $terms = $this->factory->term->create_many( 3, array( 'taxonomy' => 'wptests_tax' ) );
+        add_term_meta( $terms[0], 'foo', 'bar' );
+        add_term_meta( $terms[1], 'foo', 'bar' );
+        add_term_meta( $terms[2], 'foo', 'bar' );
+
+        $found = get_terms( 'wptests_tax', array(
+            'hide_empty' => false,
+            'include' => $terms,
+        ) );
+
+        $num_queries = $wpdb->num_queries;
+
+        foreach ( $terms as $t ) {
+            $this->assertSame( 'bar', get_term_meta( $t, 'foo', true ) );
+        }
+
+        $this->assertSame( $num_queries, $wpdb->num_queries );
+    }
+
+    /**
+     * @ticket 10142
+     */
+    public function test_termmeta_cache_should_not_be_primed_when_update_term_meta_cache_is_false() {
+        global $wpdb;
+
+        register_taxonomy( 'wptests_tax', 'post' );
+        $terms = $this->factory->term->create_many( 3, array( 'taxonomy' => 'wptests_tax' ) );
+        add_term_meta( $terms[0], 'foo', 'bar' );
+        add_term_meta( $terms[1], 'foo', 'bar' );
+        add_term_meta( $terms[2], 'foo', 'bar' );
+
+        $found = get_terms( 'wptests_tax', array(
+            'hide_empty' => false,
+            'include' => $terms,
+            'update_term_meta_cache' => false,
+        ) );
+
+        $num_queries = $wpdb->num_queries;
+
+        foreach ( $terms as $t ) {
+            $this->assertSame( 'bar', get_term_meta( $t, 'foo', true ) );
+        }
+
+        $this->assertSame( $num_queries + 3, $wpdb->num_queries );
+    }
+
+    /**
+     * @ticket 10142
+     */
+    public function test_meta_query() {
+        register_taxonomy( 'wptests_tax', 'post' );
+        $terms = $this->factory->term->create_many( 5, array( 'taxonomy' => 'wptests_tax' ) );
+        add_term_meta( $terms[0], 'foo', 'bar' );
+        add_term_meta( $terms[1], 'foo', 'bar' );
+        add_term_meta( $terms[2], 'foo', 'baz' );
+        add_term_meta( $terms[3], 'foob', 'ar' );
+
+        $found = get_terms( 'wptests_tax', array(
+            'hide_empty' => false,
+            'meta_query' => array(
+                array(
+                    'key' => 'foo',
+                    'value' => 'bar',
+                ),
+            ),
+            'fields' => 'ids',
+        ) );
+
+        $this->assertEqualSets( array( $terms[0], $terms[1] ), $found );
+    }
+
     protected function create_hierarchical_terms_and_posts() {
         $terms = array();