Automatically change database during acceptance and functional tests
You should always back up any site you run tests on if you care about the site content.
Now this disclaimer has been made ad nauseam; there's a simple way to use a different database when during tests.
Identifying requests
The first component of this solution is identifying the source of the current HTTP request.
WordPress makes this identification before deciding which database to use.
To provide the WordPress installation with this information, you can set the
headers entry of the WPBrowser or WPWebDriver module in the suite configuration file.As an example here is an
acceptance suite configuration file setting two custom headers, X_WPBROWSER_REQUEST and X_TEST_REQUEST, on each request sent by the WPWebDriver module:1
actor: AcceptanceTester
2
modules:
3
enabled:
4
- WPDb
5
- WPBrowser
6
- \Helper\Acceptance
7
config:
8
WPDb:
9
dsn: 'mysql:host=localhost;dbname=tests'
10
user: 'root'
11
password: 'root'
12
dump: 'tests/_data/dump.sql'
13
populate: true
14
cleanup: true
15
waitlock: 10
16
url: 'http://wp.test'
17
urlReplacement: true
18
tablePrefix: 'wp_'
19
WPBrowser:
20
url: 'http://wp.test'
21
adminUsername: 'admin'
22
adminPassword: 'admin'
23
adminPath: '/wp-admin'
24
headers:
25
X_WPBROWSER_REQUEST: 1
26
X_TEST_REQUEST: 1
Copied!
The two headers are sent on each HTTP request type, not just onGETtype requests.
Using a different database to handle test requests
Now that each request made by the
WPWebDriver module contains those two headers, it's time for WordPress to check those and change the database to use accordingly.The database to use is set by the
DB_NAME constant that is, in turn, set in the wp-config.php file.
Different setups could involve more complex configurations for the wp-config.php file but, for the sake of simplicity, I assume the default WordPress wp-config.php file structure.
In the example below, the default database name is wordpress, while the name of the test database is tests.1
- define( 'DB_NAME', 'wordpress' );
2
+ if( isset( $_SERVER['HTTP_X_TEST_REQUEST'] ) && $_SERVER['HTTP_X_TEST_REQUEST'] ) {
3
+ define( 'DB_NAME', 'tests' );
4
+ } else {
5
+ define( 'DB_NAME', 'wordpress' );
6
+ }
Copied!
The diff shows the replacement done in the WordPress installation
wp-config.php file.For copy-and-paste pleasure, replace the line starting with:
1
define( 'DB_NAME', 'default_db_name' );
Copied!
With this snippet:
1
if( isset( $_SERVER['HTTP_X_TEST_REQUEST'] ) && $_SERVER['HTTP_X_TEST_REQUEST'] ) {
2
define( 'DB_NAME', 'test_db_name' );
3
} else {
4
define( 'DB_NAME', 'default_db_name' );
5
}
Copied!
Where
default_db_name is the name of the database your test WordPress installation normally uses.Happy, and safer, testing.
Last modified 2yr ago