patilswapnilv / shortcodely

        $this->assertContains("ORDER BY $wpdb->comments.comment_date_gmt", $q->request);

    }

    public function test_orderby_single() 

    {

        global $wpdb;

        $q = new WP_Comment_Query();

        $q->query(

            array(

            'orderby' => 'comment_agent',

            ) 

        );

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent", $q->request);

    }

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent", $q->request);

    }

    public function test_orderby_single_invalid() 

    {

        global $wpdb;

        $q = new WP_Comment_Query();

        $q->query(

            array(

            'orderby' => 'foo',

            ) 

        );

        $this->assertContains("ORDER BY $wpdb->comments.comment_date_gmt", $q->request);

    }

        $this->assertContains("ORDER BY $wpdb->comments.comment_date_gmt", $q->request);

    }

    public function test_orderby_space_separated() 

    {

        global $wpdb;

        $q = new WP_Comment_Query();

        $q->query(

            array(

            'orderby' => 'comment_agent comment_approved',

            ) 

        );

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent DESC, $wpdb->comments.comment_approved DESC", $q->request);

    }

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent DESC, $wpdb->comments.comment_approved DESC", $q->request);

    }

    public function test_orderby_comma_separated() 

    {

        global $wpdb;

        $q = new WP_Comment_Query();

        $q->query(

            array(

            'orderby' => 'comment_agent, comment_approved',

            ) 

        );

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent DESC, $wpdb->comments.comment_approved DESC", $q->request);

    }

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent DESC, $wpdb->comments.comment_approved DESC", $q->request);

    }

    public function test_orderby_flat_array() 

    {

        global $wpdb;

        $q = new WP_Comment_Query();

        $q->query(

            array(

            'orderby' => array( 'comment_agent', 'comment_approved' ),

            ) 

        );

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent DESC, $wpdb->comments.comment_approved DESC", $q->request);

    }

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent DESC, $wpdb->comments.comment_approved DESC", $q->request);

    }

    public function test_orderby_array_contains_invalid_item() 

    {

        global $wpdb;

        $q = new WP_Comment_Query();

        $q->query(

            array(

            'orderby' => array( 'comment_agent', 'foo', 'comment_approved' ),

            ) 

        );

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent DESC, $wpdb->comments.comment_approved DESC", $q->request);

    }

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent DESC, $wpdb->comments.comment_approved DESC", $q->request);

    }

    public function test_orderby_array_contains_all_invalid_items() 

    {

        global $wpdb;

        $q = new WP_Comment_Query();

        $q->query(

            array(

            'orderby' => array( 'foo', 'bar', 'baz' ),

            ) 

        );

        $this->assertContains("ORDER BY $wpdb->comments.comment_date_gmt", $q->request);

    }

    /**

     * @ticket 30478

     */

    public function test_orderby_array_should_sort_by_comment_ID_DESC_as_fallback_when_not_sorted_by_date() 

    {

        global $wpdb;

        $q = new WP_Comment_Query();

        $found = $q->query(

            array(

            'fields' => 'ids',

            'orderby' => array(

            'comment_agent' => 'ASC',

            ),

            ) 

        );

        $this->assertContains("ORDER BY $wpdb->comments.comment_agent ASC, $wpdb->comments.comment_ID DESC", $q->request);

    }