Changeset 42768 for trunk/tests/phpunit/tests/query/metaQuery.php

Timestamp:

03/01/2018 04:02:41 AM (7 years ago)

Author:

boonebgorges

Message:

Allow LIKE queries against the 'key' value in meta queries.

The new compare_key=LIKE parameter works in conjunction with key in a
similar way to the compare=LIKE and value: by doing a "compares" LIKE
query. This allows developers to do partial matches against keys when
doing meta queries.

Props mariovalney, chasewg.
Fixes #42409.

File:

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

trunk/tests/phpunit/tests/query/metaQuery.php

@@ -1849 +1849 @@
         $this->assertEqualSets( array( 'foo_key', 'foo_key-1', 'foo_key-2' ), array_keys( $q->meta_query->get_clauses() ) );
     }
+
+    /**
+     * @ticket 42409
+     */
+    public function test_compare_key_like() {
+        $posts = self::factory()->post->create_many( 3 );
+
+        add_post_meta( $posts[0], 'aaa_foo_aaa', 'abc' );
+        add_post_meta( $posts[1], 'aaa_bar_aaa', 'abc' );
+        add_post_meta( $posts[2], 'aaa_foo_bbb', 'abc' );
+
+        $q = new WP_Query(
+            array(
+                'meta_query' => array(
+                    array(
+                        'compare_key' => 'LIKE',
+                        'key'         => 'aa_foo',
+                    ),
+                ),
+                'fields' => 'ids',
+            )
+        );
+
+        $this->assertEqualSets( array( $posts[0], $posts[2] ), $q->posts );
+    }
+
+    /**
+     * @ticket 42409
+     */
+    public function test_meta_compare_key_like() {
+        $posts = self::factory()->post->create_many( 3 );
+
+        add_post_meta( $posts[0], 'aaa_foo_aaa', 'abc' );
+        add_post_meta( $posts[1], 'aaa_bar_aaa', 'abc' );
+        add_post_meta( $posts[2], 'aaa_foo_bbb', 'abc' );
+
+        $q = new WP_Query(
+            array(
+                'meta_compare_key' => 'LIKE',
+                'meta_key'         => 'aa_foo',
+                'fields'           => 'ids',
+            )
+        );
+
+        $this->assertEqualSets( array( $posts[0], $posts[2] ), $q->posts );
+    }
+
+    /**
+     * @ticket 42409
+     */
+    public function test_compare_key_like_with_not_exists_compare() {
+        $posts = self::factory()->post->create_many( 3 );
+
+        add_post_meta( $posts[0], 'aaa_foo_aaa', 'abc' );
+        add_post_meta( $posts[1], 'aaa_bar_aaa', 'abc' );
+        add_post_meta( $posts[2], 'bar', 'abc' );
+
+        $q = new WP_Query(
+            array(
+                'meta_query' => array(
+                    'relation' => 'AND',
+                    array(
+                        'compare_key' => 'LIKE',
+                        'key'         => 'bar',
+                        'compare'     => 'NOT EXISTS',
+                    ),
+                ),
+                'fields' => 'ids',
+            )
+        );
+
+        $this->assertEqualSets( array( $posts[0] ), $q->posts );
+
+    }
 }