dbd: driver name (based on the DBD:: name).
driver is an alias for dbd. If the two keys are present, the driver key will be ignored.
If missing, all available drivers will match.
|o||version: exact database engine version|
|o||min_version: minimum database engine version|
|o||max_version: maximum database engine version|
regex_version: matching database engine version
Only database engines having a version string that matches the given regular expression will match.
The list of available, authorized DSN is stored in the local equivalent of ~/.test-database. Its a simple list of key/value pairs, with the dsn, driver_dsn or key keys being used to split successive entries:
# mysql dsn = dbi:mysql:database=mydb;host=localhost;port=1234 username = user password = s3k r3t # Oracle dsn = dbi:Oracle:test # set a unique key when creating databases key = thwapp # a "driver" with full access (create/drop databases) driver_dsn = dbi:mysql: username = root
The username and password keys are optional and undef will be used if they are not provided.
Empty lines and comments are ignored.
Optionaly, the key section is used to add a unique element to the databases created by the drivers (as defined by driver_dsn). It allows several hosts to share access to the same database server without risking a race condition when creating a new database. See Test::Database::Tutorial for a longer explanation.
Individual drivers may accept extra parameters. See their documentation for details. Unrecognized parameters and not used, and therefore ignored.
Philippe Bruhat (BooK), <email@example.com>
Please report any bugs or feature requests to bug-test-database at rt.cpan.org, or through the web interface at <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Test-Database>. I will be notified, and then youll automatically be notified of progress on your bug as I make changes.
You can find documentation for this module with the perldoc command.
You can also look for information at:
o RT: CPANs request tracker
o AnnoCPAN: Annotated CPAN documentation o CPAN Ratings o Search CPAN
Some of the items on the TODO list:
o Add a database engine autodetection script/module, to automatically write the .test-database configuration file.
Quoting Michael Schwern:
Theres plenty of modules which need a database, and they all have to be configured differently and theyre always a PITA when you first install and each and every time they upgrade.
User setup can be dealt with by making Test::Database a build dependency. As part of Test::Databases install process it walks the user through the configuration process. Once its done, it writes out a config file and then its done for good.
See <http://www.nntp.perl.org/group/perl.qa/2008/10/msg11645.html> for the thread that led to the creation of Test::Database.
Thanks to <firstname.lastname@example.org> for early comments.
Thanks to Nelson Ferraz for writing DBIx::Slice, the testing of which made me want to have a generic way to obtain a test database.
Thanks to Mark Lawrence for discussing this module with me, and sending me an alternative implementation to show me what he needed.
Thanks to Kristian Koehntopp for helping me write a mysql driver, and to Greg Sabino Mullane for writing a full Postgres driver, none of which made it into the final release because of the complete change in goals and implementation between versions 0.02 and 0.03.
The work leading to the new implementation (version 0.99 and later) was carried on during the Perl QA Hackathon, held in Birmingham in March 2009. Thanks to Birmingham.pm for organizing it and to Booking.com for sending me there.
Thanks to the early adopters: Alexis Sukrieh (SUKRIA), Nicholas Bamber (SILASMONK) and Adam Kennedy (ADAMK).
Copyright 2008-2010 Philippe Bruhat (BooK), all rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
|perl v5.20.3||TEST::DATABASE (3)||2014-05-24|