Changeset 29027 for trunk/tests/phpunit/tests/post/query.php

Timestamp:

07/08/2014 05:15:53 PM (10 years ago)

Author:

wonderboymusic

Message:

Allow an array() to be passed as the value for orderby to WP_Query. Allows for an independent order value for each key.

Example: 'orderby' => array( 'title' => 'DESC', 'menu_order' => 'ASC' ).

Adds docs and unit tests.

Props wonderboymusic, johnbillion, DrewAPicture, dd32, andy.
See #17065.

File:

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

trunk/tests/phpunit/tests/post/query.php

@@ -762 +762 @@
         $this->assertNotContains( "post_status <> 'auto-draft'", $q3->request );
     }
+
+    /**
+     *
+     * @ticket 17065
+     */
+    function test_orderby_array() {
+        global $wpdb;
+
+        $q1 = new WP_Query( array(
+            'orderby' => array(
+                'type' => 'DESC',
+                'name' => 'ASC'
+            )
+        ) );
+        $this->assertContains(
+            "ORDER BY $wpdb->posts.post_type DESC, $wpdb->posts.post_name ASC",
+            $q1->request
+        );
+
+        $q2 = new WP_Query( array( 'orderby' => array() ) );
+        $this->assertNotContains( 'ORDER BY', $q2->request );
+        $this->assertNotContains( 'ORDER', $q2->request );
+
+        $q3 = new WP_Query( array( 'post_type' => 'post' ) );
+        $this->assertContains(
+            "ORDER BY $wpdb->posts.post_date DESC",
+            $q3->request
+        );
+
+        $q4 = new WP_Query( array( 'post_type' => 'post' ) );
+        $this->assertContains(
+            "ORDER BY $wpdb->posts.post_date DESC",
+            $q4->request
+        );
+    }
+
+    /**
+     *
+     * @ticket 17065
+     */
+    function test_order() {
+        global $wpdb;
+
+        $q1 = new WP_Query( array(
+            'orderby' => array(
+                'post_type' => 'foo'
+            )
+        ) );
+        $this->assertContains(
+            "ORDER BY $wpdb->posts.post_type DESC",
+            $q1->request
+        );
+
+        $q2 = new WP_Query( array(
+            'orderby' => 'title',
+            'order'   => 'foo'
+        ) );
+        $this->assertContains(
+            "ORDER BY $wpdb->posts.post_title DESC",
+            $q2->request
+        );
+
+        $q3 = new WP_Query( array(
+            'order' => 'asc'
+        ) );
+        $this->assertContains(
+            "ORDER BY $wpdb->posts.post_date ASC",
+            $q3->request
+        );
+    }
 }