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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
use strict;
use DBI;
use Test::More;
if (defined $ENV{DBI_DSN}) {
plan tests => 12;
} else {
plan skip_all => 'cannot test without DB info';
}
my $dbh1 = DBI->connect($ENV{DBI_DSN}, $ENV{DBI_USER}, $ENV{DBI_PASS},
{RaiseError => 1, AutoCommit => 1}
);
ok(defined $dbh1,
'connect first dbh'
);
my $dbh2 = DBI->connect($ENV{DBI_DSN}, $ENV{DBI_USER}, $ENV{DBI_PASS},
{RaiseError => 1, AutoCommit => 1}
);
ok(defined $dbh2,
'connect second dbh'
);
ok($dbh1->do(q{DELETE FROM test}),
'delete'
);
my $rows = ($dbh1->selectrow_array(q{SELECT COUNT(*) FROM test}))[0];
ok($rows == 0,
'fetch on empty table from dbh1'
);
$rows = ($dbh2->selectrow_array(q{SELECT COUNT(*) FROM test}))[0];
ok($rows == 0,
'fetch on empty table from dbh2'
);
ok($dbh1->do(q{INSERT INTO test (id, name, val) VALUES (1, 'foo', 'horse')}),
'insert'
);
$rows = ($dbh1->selectrow_array(q{SELECT COUNT(*) FROM test}))[0];
ok($rows == 1,
'fetch one row from dbh1'
);
$rows = ($dbh2->selectrow_array(q{SELECT COUNT(*) FROM test}))[0];
ok($rows == 1,
'fetch one row from dbh1'
);
local $SIG{__WARN__} = sub {};
ok(!$dbh1->commit(),
'commit'
);
ok(!$dbh1->rollback(),
'rollback'
);
ok($dbh1->disconnect(),
'disconnect on dbh1'
);
ok($dbh2->disconnect(),
'disconnect on dbh2'
);
|