1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
use strict;
use warnings;
use DBI;
use Test::More;
use vars qw($mdriver);
$|= 1;
use vars qw($test_dsn $test_user $test_password);
use lib 't', '.';
require 'lib.pl';
my $dbh;
# yes, we will reconnect, but I want to keep the "fail if not connect"
# separate from the actual test where we reconnect
eval {$dbh= DBI->connect($test_dsn, $test_user, $test_password,
{ RaiseError => 1, PrintError => 1, AutoCommit => 1 });};
if ($@) {
plan skip_all => "no database connection";
}
plan tests => 6;
for my $ur (0,1) {
$test_dsn .= ";mysql_use_result=1" if $ur;
# reconnect
ok ($dbh->disconnect());
ok ($dbh= DBI->connect($test_dsn, $test_user, $test_password,
{ RaiseError => 1, PrintError => 1, AutoCommit => 0 }));
is $dbh->{mysql_use_result}, $ur, "mysql_use_result set to $ur";
}
|
