Changeset 43628 for trunk/tests/phpunit/tests/admin/includesSchema.php

Timestamp:

09/05/2018 10:44:02 AM (7 years ago)

Author:

flixos90

Message:

Upgrade/Install: Introduce populate_network_meta(), moving logic out of populate_network().

Fixes #44895. See #41333.

File:

• trunk/tests/phpunit/tests/admin/includesSchema.php (modified) (9 diffs)

trunk/tests/phpunit/tests/admin/includesSchema.php

@@ -1 +1 @@
 <?php
+// phpcs:ignoreFile WordPress.WP.PreparedSQL.NotPrepared
 
 /**
@@ -7 +8 @@
 
     private static $options;
+    private static $sitemeta;
 
     /**
@@ -15 +17 @@
 
         self::$options  = 'testprefix_options';
-
-        $options = self::$options;
+        self::$sitemeta = 'testprefix_sitemeta';
+
+        $options  = self::$options;
+        $sitemeta = self::$sitemeta;
 
         require_once( ABSPATH . 'wp-admin/includes/schema.php' );
@@ -35 +39 @@
             "
         );
+        $wpdb->query(
+            "
+            CREATE TABLE {$sitemeta} (
+                meta_id bigint(20) unsigned NOT NULL auto_increment,
+                site_id bigint(20) unsigned NOT NULL default '0',
+                meta_key varchar(255) default NULL,
+                meta_value longtext,
+                PRIMARY KEY  (meta_id),
+                KEY meta_key (meta_key({$max_index_length})),
+                KEY site_id (site_id)
+            ) {$charset_collate}
+            "
+        );
     }
 
@@ -43 +60 @@
         global $wpdb;
 
-        $options = self::$options;
+        $options  = self::$options;
+        $sitemeta = self::$sitemeta;
 
         $wpdb->query( "DROP TABLE IF EXISTS {$options}" );
+        $wpdb->query( "DROP TABLE IF EXISTS {$sitemeta}" );
     }
 
@@ -54 +73 @@
     function test_populate_options( $options, $expected ) {
         global $wpdb;
-
-        remove_all_filters( 'option_admin_email' );
-        remove_all_filters( 'pre_option_admin_email' );
-        remove_all_filters( 'default_option_admin_email' );
 
         $orig_options  = $wpdb->options;
@@ -93 +108 @@
             array(
                 array(
-                    'posts_per_rss'    => 7,
-                    'rss_use_excerpt'  => 1,
+                    'posts_per_rss'   => 7,
+                    'rss_use_excerpt' => 1,
                 ),
                 array(
@@ -130 +145 @@
             array(
                 array(
-                    'rss_0123456789abcdef0123456789abcdef'    => '1',
+                    'rss_0123456789abcdef0123456789abcdef' => '1',
                     'rss_0123456789abcdef0123456789abcdef_ts' => '1',
                 ),
                 array(
                     // These options would be obsolete magpie cache data and should never exist.
-                    'rss_0123456789abcdef0123456789abcdef'    => false,
+                    'rss_0123456789abcdef0123456789abcdef' => false,
                     'rss_0123456789abcdef0123456789abcdef_ts' => false,
                 ),
@@ -141 +156 @@
         );
     }
+
+    /**
+     * @ticket 44895
+     * @dataProvider data_populate_network_meta
+     */
+    function test_populate_network_meta( $meta, $expected ) {
+        global $wpdb;
+
+        $orig_sitemeta  = $wpdb->sitemeta;
+        $wpdb->sitemeta = self::$sitemeta;
+
+        populate_network_meta( 42, $meta );
+
+        $results = array();
+        foreach ( $expected as $meta_key => $value ) {
+            if ( is_multisite() ) {
+                $results[ $meta_key ] = get_network_option( 42, $meta_key );
+            } else {
+                $results[ $meta_key ] = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM {$wpdb->sitemeta} WHERE meta_key = %s AND site_id = %d", $meta_key, 42 ) );
+            }
+        }
+
+        $wpdb->query( "TRUNCATE TABLE {$wpdb->sitemeta}" );
+
+        $wpdb->sitemeta = $orig_sitemeta;
+
+        $this->assertEquals( $expected, $results );
+    }
+
+    public function data_populate_network_meta() {
+        return array(
+            array(
+                array(),
+                array(
+                    // Random meta to check.
+                    'registration'      => 'none',
+                    'blog_upload_space' => 100,
+                    'fileupload_maxk'   => 1500,
+                ),
+            ),
+            array(
+                array(
+                    'site_name' => 'My Great Network',
+                    'WPLANG'    => 'fr_FR',
+                ),
+                array(
+                    // Random meta to check.
+                    'site_name'         => 'My Great Network',
+                    'registration'      => 'none',
+                    'blog_upload_space' => 100,
+                    'fileupload_maxk'   => 1500,
+                    'WPLANG'            => 'fr_FR',
+                ),
+            ),
+            array(
+                array(
+                    'custom_meta' => '1',
+                ),
+                array(
+                    // Random meta to check.
+                    'custom_meta'       => '1',
+                    'registration'      => 'none',
+                    'blog_upload_space' => 100,
+                    'fileupload_maxk'   => 1500,
+                ),
+            ),
+        );
+    }
 }