Changeset 33946

Timestamp:

09/08/2015 03:23:29 AM (11 years ago)

Author:

pento

Message:

Tests: Check that readme.html is recommending an actively supported version of MySQL.

Per the MySQL support guidelines (​https://www.mysql.com/support/), Oracle provides active support for MySQL releases for 5 years from the General Availality release.

See #33758.

File:

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

trunk/tests/phpunit/tests/basic.php

@@ -39 +39 @@
 
                 $this->assertContains( $matches[1], $phpmatches[1], "readme.html's Recommended PHP version is too old. Remember to update the WordPress.org Requirements page, too." );
+
+                preg_match( '#Recommendations.*MySQL</a> version <strong>([0-9.]*)#s', $readme, $matches );
+
+                $response = wp_remote_get( "https://dev.mysql.com/doc/relnotes/mysql/{$matches[1]}/en/" );
+                if ( 200 != wp_remote_retrieve_response_code( $response ) ) {
+                        $this->markTestSkipped( 'Could not contact dev.MySQL.com to check versions.' );
+                }
+                $mysql = wp_remote_retrieve_body( $response );
+
+                preg_match( '#(\d{4}-\d{2}-\d{2}), General Availability#', $mysql, $mysqlmatches );
+
+                // Per https://www.mysql.com/support/, Oracle actively supports MySQL releases for 5 years from GA release
+                $mysql_eol = strtotime( $mysqlmatches[1] . ' +5 years' );
+
+                $this->assertLessThan( $mysql_eol, time(), "readme.html's Recommended MySQL version is too old. Remember to update the WordPress.org Requirements page, too." );
         }