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

Timestamp:

09/05/2018 10:44:02 AM (8 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,
+                                ),
+                        ),
+                );
+        }
 }