The decision between test and production should be made when creating your database handle. I suggest that you create one central subroutine that creates the database connection, and you overwrite the database name in your test scripts:
package My::DB;
use strict;
use DBI;
use vars qw( $dbname );
$dbname = 'dbi:mysql:production_db';
{ my $dbh;
sub dbh {
$dbh ||= DBI->new($dbname);
$dbh;
};
sub disconnect {
$dbh->disconnect
if $dbh;
};
};
package main;
use My::DB;
my $dbh = My::DB::dbh;
# ... do stuff
and in your test program(s) :
use strict;
use My::DB;
{
no warnings 'redefine';
$My::DB::dbname = 'dbi:mysql:test_db';
};
my $dbh = My::DB::dbh;
...
That way, you can easily change out the database connection to use, and you also can easily simulate failure conditions like the database being unavailable etc.
I would also consider using DBD::SQLite as database for some of the tests, as restoring a DBD::SQLite database is simply a matter of copying one file. You might get similar results with mysqldump though.
perl -MHTTP::Daemon -MHTTP::Response -MLWP::Simple -e ' ; # The
$d = new HTTP::Daemon and fork and getprint $d->url and exit;#spider
($c = $d->accept())->get_request(); $c->send_response( new #in the
HTTP::Response(200,$_,$_,qq(Just another Perl hacker\n))); ' # web
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|