Changeset 38938 for trunk/tests/phpunit/tests/query/metaQuery.php
- Timestamp:
- 10/26/2016 01:23:24 AM (8 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/tests/phpunit/tests/query/metaQuery.php
r35242 r38938 391 391 public function test_meta_query_relation_or() { 392 392 $post_id = self::factory()->post->create(); 393 add_post_meta( $post_id, 'foo', rand_str() ); 394 add_post_meta( $post_id, 'foo', rand_str() ); 393 add_post_meta( $post_id, 'foo', 'foo_val_1' ); 394 add_post_meta( $post_id, 'foo', 'foo_val_2' ); 395 395 396 $post_id2 = self::factory()->post->create(); 396 add_post_meta( $post_id2, 'bar', 'val2' ); 397 add_post_meta( $post_id2, 'bar', 'bar_val_1' ); 398 397 399 $post_id3 = self::factory()->post->create(); 398 add_post_meta( $post_id3, 'baz', rand_str() ); 400 add_post_meta( $post_id3, 'baz', 'baz_val_1' ); 401 399 402 $post_id4 = self::factory()->post->create(); 400 add_post_meta( $post_id4, 'froo', rand_str() ); 403 add_post_meta( $post_id4, 'froo', 'froo_val_1' ); 404 401 405 $post_id5 = self::factory()->post->create(); 402 add_post_meta( $post_id5, 'tango', 'val2' ); 406 add_post_meta( $post_id5, 'tango', 'tango_val_1' ); 407 408 $post_id6 = self::factory()->post->create(); 409 add_post_meta( $post_id6, 'bar', 'bar_val_2' ); 410 411 $query = new WP_Query( array( 412 'update_post_meta_cache' => false, 413 'update_post_term_cache' => false, 414 'fields' => 'ids', 415 'meta_query' => array( 416 array( 417 'key' => 'foo' 418 ), 419 array( 420 'key' => 'bar', 421 'value' => 'bar_val_1' 422 ), 423 array( 424 'key' => 'baz' 425 ), 426 array( 427 'key' => 'froo' 428 ), 429 'relation' => 'OR', 430 ), 431 ) ); 432 433 $expected = array( $post_id, $post_id2, $post_id3, $post_id4 ); 434 $this->assertEqualSets( $expected, $query->posts ); 435 } 436 437 public function test_meta_query_relation_and() { 438 $post_id = self::factory()->post->create(); 439 add_post_meta( $post_id, 'foo', 'foo_val_1' ); 440 add_post_meta( $post_id, 'foo', 'foo_val_2' ); 441 442 $post_id2 = self::factory()->post->create(); 443 add_post_meta( $post_id2, 'bar', 'val_2' ); 444 add_post_meta( $post_id2, 'foo', 'foo_val_3' ); 445 446 $post_id3 = self::factory()->post->create(); 447 add_post_meta( $post_id3, 'baz', 'baz_val_1' ); 448 449 $post_id4 = self::factory()->post->create(); 450 add_post_meta( $post_id4, 'froo', 'froo_val_1' ); 451 452 $post_id5 = self::factory()->post->create(); 453 add_post_meta( $post_id5, 'tango', 'val_2' ); 454 403 455 $post_id6 = self::factory()->post->create(); 404 456 add_post_meta( $post_id6, 'bar', 'val1' ); 405 406 $query = new WP_Query( array( 407 'update_post_meta_cache' => false, 408 'update_post_term_cache' => false, 409 'fields' => 'ids', 457 add_post_meta( $post_id6, 'foo', 'foo_val_4' ); 458 459 $post_id7 = self::factory()->post->create(); 460 add_post_meta( $post_id7, 'foo', 'foo_val_5' ); 461 add_post_meta( $post_id7, 'froo', 'froo_val_2' ); 462 add_post_meta( $post_id7, 'baz', 'baz_val_2' ); 463 add_post_meta( $post_id7, 'bar', 'val_2' ); 464 465 $query = new WP_Query( array( 410 466 'meta_query' => array( 411 467 array( … … 414 470 array( 415 471 'key' => 'bar', 416 'value' => 'val2' 417 ), 418 array( 419 'key' => 'baz' 420 ), 421 array( 422 'key' => 'froo' 423 ), 424 'relation' => 'OR', 425 ), 426 ) ); 427 428 $expected = array( $post_id, $post_id2, $post_id3, $post_id4 ); 429 $this->assertEqualSets( $expected, $query->posts ); 430 } 431 432 public function test_meta_query_relation_and() { 433 $post_id = self::factory()->post->create(); 434 add_post_meta( $post_id, 'foo', rand_str() ); 435 add_post_meta( $post_id, 'foo', rand_str() ); 436 $post_id2 = self::factory()->post->create(); 437 add_post_meta( $post_id2, 'bar', 'val2' ); 438 add_post_meta( $post_id2, 'foo', rand_str() ); 439 $post_id3 = self::factory()->post->create(); 440 add_post_meta( $post_id3, 'baz', rand_str() ); 441 $post_id4 = self::factory()->post->create(); 442 add_post_meta( $post_id4, 'froo', rand_str() ); 443 $post_id5 = self::factory()->post->create(); 444 add_post_meta( $post_id5, 'tango', 'val2' ); 445 $post_id6 = self::factory()->post->create(); 446 add_post_meta( $post_id6, 'bar', 'val1' ); 447 add_post_meta( $post_id6, 'foo', rand_str() ); 448 $post_id7 = self::factory()->post->create(); 449 add_post_meta( $post_id7, 'foo', rand_str() ); 450 add_post_meta( $post_id7, 'froo', rand_str() ); 451 add_post_meta( $post_id7, 'baz', rand_str() ); 452 add_post_meta( $post_id7, 'bar', 'val2' ); 453 454 $query = new WP_Query( array( 455 'meta_query' => array( 456 array( 457 'key' => 'foo' 458 ), 459 array( 460 'key' => 'bar', 461 'value' => 'val2' 472 'value' => 'val_2' 462 473 ), 463 474 array( … … 566 577 public function test_meta_query_compare_not_exists() { 567 578 $post_id = self::factory()->post->create(); 568 add_post_meta( $post_id, 'foo', rand_str() ); 579 add_post_meta( $post_id, 'foo', 'foo_val_1' ); 580 569 581 $post_id2 = self::factory()->post->create(); 570 add_post_meta( $post_id2, 'bar', rand_str() ); 582 add_post_meta( $post_id2, 'bar', 'bar_val_1' ); 583 571 584 $post_id3 = self::factory()->post->create(); 572 add_post_meta( $post_id3, 'bar', rand_str() ); 585 add_post_meta( $post_id3, 'bar', 'bar_val_2' ); 586 573 587 $post_id4 = self::factory()->post->create(); 574 add_post_meta( $post_id4, 'baz', rand_str() ); 588 add_post_meta( $post_id4, 'baz', 'baz_val_1' ); 589 575 590 $post_id5 = self::factory()->post->create(); 576 add_post_meta( $post_id5, 'foo', rand_str());591 add_post_meta( $post_id5, 'foo', 'foo_val_2' ); 577 592 578 593 $query = new WP_Query( array( … … 1453 1468 add_post_meta( $post_id4, 'baz', 'bar' ); 1454 1469 $post_id5 = self::factory()->post->create(); 1455 add_post_meta( $post_id5, 'foo', rand_str());1470 add_post_meta( $post_id5, 'foo', 'tango' ); 1456 1471 1457 1472 $posts = get_posts( array(
Note: See TracChangeset
for help on using the changeset viewer.