|
@@ 369-383 (lines=15) @@
|
| 366 |
|
/** |
| 367 |
|
* @ticket 30064 |
| 368 |
|
*/ |
| 369 |
|
public function test_orderby_include() |
| 370 |
|
{ |
| 371 |
|
global $wpdb; |
| 372 |
|
|
| 373 |
|
$q = new WP_User_Query( |
| 374 |
|
array( |
| 375 |
|
'orderby' => 'include', |
| 376 |
|
'include' => array( self::$author_ids[1], self::$author_ids[0], self::$author_ids[3] ), |
| 377 |
|
'fields' => '', |
| 378 |
|
) |
| 379 |
|
); |
| 380 |
|
|
| 381 |
|
$expected_orderby = 'ORDER BY FIELD( ' . $wpdb->users . '.ID, ' . self::$author_ids[1] . ',' . self::$author_ids[0] . ',' . self::$author_ids[3] . ' )'; |
| 382 |
|
$this->assertContains($expected_orderby, $q->query_orderby); |
| 383 |
|
|
| 384 |
|
// assertEquals() respects order but ignores type (get_results() returns numeric strings). |
| 385 |
|
$this->assertEquals(array( self::$author_ids[1], self::$author_ids[0], self::$author_ids[3] ), $q->get_results()); |
| 386 |
|
} |
|
@@ 391-405 (lines=15) @@
|
| 388 |
|
/** |
| 389 |
|
* @ticket 30064 |
| 390 |
|
*/ |
| 391 |
|
public function test_orderby_include_duplicate_values() |
| 392 |
|
{ |
| 393 |
|
global $wpdb; |
| 394 |
|
|
| 395 |
|
$q = new WP_User_Query( |
| 396 |
|
array( |
| 397 |
|
'orderby' => 'include', |
| 398 |
|
'include' => array( self::$author_ids[1], self::$author_ids[0], self::$author_ids[1], self::$author_ids[3] ), |
| 399 |
|
'fields' => '', |
| 400 |
|
) |
| 401 |
|
); |
| 402 |
|
|
| 403 |
|
$expected_orderby = 'ORDER BY FIELD( ' . $wpdb->users . '.ID, ' . self::$author_ids[1] . ',' . self::$author_ids[0] . ',' . self::$author_ids[3] . ' )'; |
| 404 |
|
$this->assertContains($expected_orderby, $q->query_orderby); |
| 405 |
|
|
| 406 |
|
// assertEquals() respects order but ignores type (get_results() returns numeric strings). |
| 407 |
|
$this->assertEquals(array( self::$author_ids[1], self::$author_ids[0], self::$author_ids[3] ), $q->get_results()); |
| 408 |
|
} |
patilswapnilv /
shortcodely
