Changeset 43010 for trunk/tests/phpunit/tests/multisite/siteMeta.php

Timestamp:

04/27/2018 11:40:35 AM (8 years ago)

Author:

flixos90

Message:

Multisite: Add meta query functionality to WP_Site_Query.

After the introduction of site metadata in [42836], it should be possible to query sites by that data.

Fixes #40229.

File:

• trunk/tests/phpunit/tests/multisite/siteMeta.php (modified) (1 diff)

trunk/tests/phpunit/tests/multisite/siteMeta.php

@@ -257 +257 @@
         $this->assertSame( $num_queries + 1, $wpdb->num_queries);
     }
+
+    /**
+     * @ticket 40229
+     */
+    public function test_add_site_meta_should_bust_get_sites_cache() {
+        if ( ! is_site_meta_supported() ) {
+            $this->markTestSkipped( 'Tests only runs with the blogmeta database table installed' );
+        }
+
+        add_site_meta( self::$site_id, 'foo', 'bar' );
+
+        // Prime cache.
+        $found = get_sites( array(
+            'fields' => 'ids',
+            'meta_query' => array(
+                array(
+                    'key' => 'foo',
+                    'value' => 'bar',
+                ),
+            ),
+        ) );
+
+        $this->assertEqualSets( array( self::$site_id ), $found );
+
+        add_site_meta( self::$site_id2, 'foo', 'bar' );
+
+        $found = get_sites( array(
+            'fields' => 'ids',
+            'meta_query' => array(
+                array(
+                    'key' => 'foo',
+                    'value' => 'bar',
+                ),
+            ),
+        ) );
+
+        $this->assertEqualSets( array( self::$site_id, self::$site_id2 ), $found );
+    }
+
+    /**
+     * @ticket 40229
+     */
+    public function test_update_site_meta_should_bust_get_sites_cache() {
+        if ( ! is_site_meta_supported() ) {
+            $this->markTestSkipped( 'Tests only runs with the blogmeta database table installed' );
+        }
+
+        add_site_meta( self::$site_id, 'foo', 'bar' );
+        add_site_meta( self::$site_id2, 'foo', 'baz' );
+
+        // Prime cache.
+        $found = get_sites( array(
+            'fields' => 'ids',
+            'meta_query' => array(
+                array(
+                    'key' => 'foo',
+                    'value' => 'bar',
+                ),
+            ),
+        ) );
+
+        $this->assertEqualSets( array( self::$site_id ), $found );
+
+        update_site_meta( self::$site_id2, 'foo', 'bar' );
+
+        $found = get_sites( array(
+            'fields' => 'ids',
+            'meta_query' => array(
+                array(
+                    'key' => 'foo',
+                    'value' => 'bar',
+                ),
+            ),
+        ) );
+
+        $this->assertEqualSets( array( self::$site_id, self::$site_id2 ), $found );
+    }
+
+    /**
+     * @ticket 40229
+     */
+    public function test_delete_site_meta_should_bust_get_sites_cache() {
+        if ( ! is_site_meta_supported() ) {
+            $this->markTestSkipped( 'Tests only runs with the blogmeta database table installed' );
+        }
+
+        add_site_meta( self::$site_id, 'foo', 'bar' );
+        add_site_meta( self::$site_id2, 'foo', 'bar' );
+
+        // Prime cache.
+        $found = get_sites( array(
+            'fields' => 'ids',
+            'meta_query' => array(
+                array(
+                    'key' => 'foo',
+                    'value' => 'bar',
+                ),
+            ),
+        ) );
+
+        $this->assertEqualSets( array( self::$site_id, self::$site_id2 ), $found );
+
+        delete_site_meta( self::$site_id2, 'foo', 'bar' );
+
+        $found = get_sites( array(
+            'fields' => 'ids',
+            'meta_query' => array(
+                array(
+                    'key' => 'foo',
+                    'value' => 'bar',
+                ),
+            ),
+        ) );
+
+        $this->assertEqualSets( array( self::$site_id ), $found );
+    }
 }