Changeset 37654

Timestamp:

06/08/2016 03:03:16 AM (8 years ago)

Author:

pento

Message:

Tests: Disable foreign_key_checks while dropping existing tables.

To ensure a clean run, the test suite drops all tables before installing, by simply looping over the table list and dropping them if they exist. This works well for Core, but may fail when a plugin has created a table with foreign key constraints in a previous test run.

Many plugins choose to base their test suite on the Core setup, so making life easier for them is a plus, even if Core doesn't directly need this change.

Props javorszky.

Fixes #37046.

File:

• trunk/tests/phpunit/includes/install.php (modified) (2 diffs)

trunk/tests/phpunit/includes/install.php

@@ -41 +41 @@
 echo "Installing..." . PHP_EOL;
 
+$wpdb->query( "SET foreign_key_checks = 0" );
 foreach ( $wpdb->tables() as $table => $prefixed_table ) {
     $wpdb->query( "DROP TABLE IF EXISTS $prefixed_table" );
@@ -52 +53 @@
         $wpdb->$table = $prefixed_table;
 }
+$wpdb->query( "SET foreign_key_checks = 1" );
 
 // Prefill a permalink structure so that WP doesn't try to determine one itself.