Changeset 27075 for trunk/tests/phpunit/tests/db.php

Timestamp:

02/02/2014 10:06:42 PM (10 years ago)

Author:

nacin

Message:

When the MySQL server has "gone away," attempt to reconnect and retry the query.

props pento.
see #5932.

File:

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

trunk/tests/phpunit/tests/db.php

@@ -39 +39 @@
         $this->_queries[] = $sql;
         return $sql;
+    }
+
+    /**
+     * Test that WPDB will reconnect when the DB link dies
+     * @ticket 5932
+     */
+    public function test_db_reconnect() {
+        global $wpdb;
+
+        $var = $wpdb->get_var( "SELECT ID FROM $wpdb->users LIMIT 1" );
+        $this->assertGreaterThan( 0, $var );
+
+        mysql_close( $wpdb->dbh );
+        unset( $wpdb->dbh );
+
+        $var = $wpdb->get_var( "SELECT ID FROM $wpdb->users LIMIT 1" );
+        $this->assertGreaterThan( 0, $var );
     }