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

Timestamp:

09/25/2015 03:58:59 AM (10 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/wpGetObjectTerms.php (modified) (1 diff)

trunk/tests/phpunit/tests/term/wpGetObjectTerms.php

@@ -419 +419 @@
     }
 
+    /**
+     * @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' );
+
+        $p = $this->factory->post->create();
+        wp_set_object_terms( $p, $terms, 'wptests_tax' );
+
+        $found = wp_get_object_terms( $p, 'wptests_tax' );
+
+        $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' );
+
+        $p = $this->factory->post->create();
+        wp_set_object_terms( $p, $terms, 'wptests_tax' );
+
+        $found = wp_get_object_terms( $p, 'wptests_tax', array(
+            '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' );
+
+        $p = $this->factory->post->create();
+        wp_set_object_terms( $p, $terms, 'wptests_tax' );
+
+        $found = wp_get_object_terms( $p, 'wptests_tax', array(
+            'meta_query' => array(
+                array(
+                    'key' => 'foo',
+                    'value' => 'bar',
+                ),
+            ),
+        ) );
+
+        $this->assertEqualSets( array( $terms[0], $terms[1] ), wp_list_pluck( $found, 'term_id' ) );
+    }
+
     public function filter_get_object_terms( $terms ) {
         $term_ids = wp_list_pluck( $terms, 'term_id' );