Changeset 9021 for trunk/tests/phpunit/testcases/groups/class-bp-groups-group.php

Timestamp:

09/15/2014 04:21:47 PM (12 years ago)

Author:

boonebgorges

Message:

Add unit tests for group meta_query when queries with the same 'key' are joined by OR

This query is failing when the 'compare' operator is 'LIKE'.

See #5874

File:

• trunk/tests/phpunit/testcases/groups/class-bp-groups-group.php (modified) (1 diff)

trunk/tests/phpunit/testcases/groups/class-bp-groups-group.php

@@ -175 +175 @@
          * @group get
          * @group group_meta_query
+         * @ticket BP5874
+         */
+        public function test_get_with_meta_query_multiple_clauses_relation_or_shared_meta_key() {
+                $now = time();
+                $g1 = $this->factory->group->create( array(
+                        'last_activity' => date( 'Y-m-d H:i:s', $now - 60*60 ),
+                ) );
+                $g2 = $this->factory->group->create( array(
+                        'last_activity' => date( 'Y-m-d H:i:s', $now - 60*60*2 ),
+                ) );
+                $g3 = $this->factory->group->create( array(
+                        'last_activity' => date( 'Y-m-d H:i:s', $now - 60*60*3 ),
+                ) );
+                groups_update_groupmeta( $g1, 'foo', 'bar' );
+                groups_update_groupmeta( $g2, 'foo', 'baz' );
+                groups_update_groupmeta( $g3, 'foo', 'barry' );
+
+                $groups = BP_Groups_Group::get( array(
+                        'meta_query' => array(
+                                'relation' => 'OR',
+                                array(
+                                        'key' => 'foo',
+                                        'value' => 'bar',
+                                ),
+                                array(
+                                        'key' => 'foo',
+                                        'value' => 'baz',
+                                ),
+                        ),
+                ) );
+                $ids = wp_list_pluck( $groups['groups'], 'id' );
+                $this->assertEquals( array( $g1, $g2 ), $ids );
+                $this->assertEquals( 2, $groups['total'] );
+        }
+
+        /**
+         * @group get
+         * @group group_meta_query
+         * @ticket BP5874
+         */
+        public function test_get_with_meta_query_multiple_clauses_relation_or_shared_meta_key_relation_like() {
+                $now = time();
+                $g1 = $this->factory->group->create( array(
+                        'last_activity' => date( 'Y-m-d H:i:s', $now - 60*60 ),
+                ) );
+                $g2 = $this->factory->group->create( array(
+                        'last_activity' => date( 'Y-m-d H:i:s', $now - 60*60*2 ),
+                ) );
+                $g3 = $this->factory->group->create( array(
+                        'last_activity' => date( 'Y-m-d H:i:s', $now - 60*60*3 ),
+                ) );
+                groups_update_groupmeta( $g1, 'foo', 'bar' );
+                groups_update_groupmeta( $g2, 'foo', 'baz' );
+                groups_update_groupmeta( $g3, 'foo', 'barry' );
+
+                $groups = BP_Groups_Group::get( array(
+                        'meta_query' => array(
+                                'relation' => 'OR',
+                                array(
+                                        'key' => 'foo',
+                                        'value' => 'bar',
+                                        'compare' => 'LIKE',
+                                ),
+                                array(
+                                        'key' => 'foo',
+                                        'value' => 'baz',
+                                        'compare' => 'LIKE',
+                                ),
+                        ),
+                ) );
+                $ids = wp_list_pluck( $groups['groups'], 'id' );
+                $this->assertEquals( array( $g1, $g2 ), $ids );
+                $this->assertEquals( 2, $groups['total'] );
+        }
+
+        /**
+         * @group get
+         * @group group_meta_query
          * @ticket BP5824
          */