Changeset 25248 for trunk/tests/phpunit/tests/query/results.php

Timestamp:

09/04/2013 09:32:11 PM (12 years ago)

Author:

wonderboymusic

Message:

Introduce author__in and author__not_in query vars. Fixes issue with multiple author exclusion when comma-separated string is passed for author. Adds a bunch of missing unit tests.

Props pollett for initial patch.
Fixes #16854.

File:

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

trunk/tests/phpunit/tests/query/results.php

@@ -389 +389 @@
         $this->assertNotRegExp( '#AND 1=0#', $this->q->request );
     }
+
+    function test_query_author_vars() {
+        $author_1 = $this->factory->user->create( array( 'user_login' => 'admin1', 'user_pass' => rand_str(), 'role' => 'author' ) );
+        $post_1 = $this->factory->post->create( array( 'post_title' => rand_str(), 'post_author' => $author_1, 'post_date' => '2007-01-01 00:00:00' ) );
+
+        $author_2 = $this->factory->user->create( array( 'user_login' => rand_str(), 'user_pass' => rand_str(), 'role' => 'author' ) );
+        $post_2 = $this->factory->post->create( array( 'post_title' => rand_str(), 'post_author' => $author_2, 'post_date' => '2007-01-01 00:00:00' ) );
+
+        $author_3 = $this->factory->user->create( array( 'user_login' => rand_str(), 'user_pass' => rand_str(), 'role' => 'author' ) );
+        $post_3 = $this->factory->post->create( array( 'post_title' => rand_str(), 'post_author' => $author_3, 'post_date' => '2007-01-01 00:00:00' ) );
+
+        $author_4 = $this->factory->user->create( array( 'user_login' => rand_str(), 'user_pass' => rand_str(), 'role' => 'author' ) );
+        $post_4 = $this->factory->post->create( array( 'post_title' => rand_str(), 'post_author' => $author_4, 'post_date' => '2007-01-01 00:00:00' ) );
+
+        $posts = $this->q->query( array(
+            'author' => '',
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1, $author_2, $author_3, $author_4 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author' => 0,
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1, $author_2, $author_3, $author_4 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author' => '0',
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1, $author_2, $author_3, $author_4 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author' => $author_1,
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author' => "$author_1",
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author' => "{$author_1},{$author_2}",
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1, $author_2 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author' => "-{$author_1},{$author_2}",
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_2, $author_3, $author_4 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author' => "{$author_1},-{$author_2}",
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1, $author_3, $author_4 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author' => "-{$author_1},-{$author_2}",
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_3, $author_4 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author__in' => array( $author_1, $author_2 ),
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1, $author_2 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author__not_in' => array( $author_1, $author_2 ),
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_3, $author_4 ), $author_ids );
+
+        $posts = $this->q->query( array(
+            'author_name' => 'admin1',
+            'post__in' => array( $post_1, $post_2, $post_3, $post_4 )
+        ) );
+        $author_ids = array_unique( wp_list_pluck( $posts, 'post_author' ) );
+        $this->assertEqualSets( array( $author_1 ), $author_ids );
+    }
 }