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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
use strict; use warnings;
use Test::More tests => 39;
use lib 't/lib';
use Hook::Guard;
use DBIx::Connector;
my $CLASS = 'DBIx::Connector';
ok my $conn = $CLASS->new( 'dbi:ExampleP:dummy', '', '' ),
'Get a connection';
# Test with no existing dbh.
my $connect_meth = Hook::Guard->new( \*DBIx::Connector::_connect )->prepend(sub {
pass '_connect should be called';
});
ok $conn->run( ping => sub {
ok shift->{AutoCommit}, 'Inside, we should not be in a transaction';
ok !$conn->in_txn, 'in_txn() should know it, too';
ok $conn->{_in_run}, '_in_run should be true';
}), 'Do something with no existing handle';
# Test with instantiated dbh.
$connect_meth->restore;
ok my $dbh = $conn->dbh, 'Fetch the dbh';
# Set up a DBI mocker.
my $ping = 0;
my $dbh_ping_meth = Hook::Guard->new( \*DBI::db::ping )->replace( sub { ++$ping } );
is $conn->{_dbh}, $dbh, 'The dbh should be stored';
is $ping, 0, 'No pings yet';
ok $conn->connected, 'We should be connected';
is $ping, 1, 'Ping should have been called';
ok $conn->run( ping => sub {
is $ping, 2, 'Ping should have been called before the run';
is shift, $dbh, 'The database handle should have been passed';
is $_, $dbh, 'Should have dbh in $_';
is $conn->dbh, $dbh, 'Should get same dbh from dbh()';
is $ping, 2, 'ping should not have been called again';
$dbh->{Active} = 0;
isnt $conn->dbh, $dbh, 'Should get different dbh if after disconnect';
}), 'Do something with stored handle';
# Test the return value.
$dbh = $conn->dbh;
ok my $foo = $conn->run( ping => sub {
return (2, 3, 5);
}), 'Do in scalar context';
is $foo, 5, 'The return value should be the last value';
ok my @foo = $conn->run( ping => sub {
return (2, 3, 5);
}), 'Do in array context';
is_deeply \@foo, [2, 3, 5], 'The return value should be the list';
# Test an exception.
eval { $conn->run( ping => sub { die 'WTF?' }) };
like $@, qr/WTF/, 'We should have died';
# Make sure nesting works okay.
ok !$conn->{_in_run}, '_in_run should be false';
$conn->run( ping => sub {
my $dbh = shift;
ok $conn->{_in_run}, '_in_run should be set inside run()';
local $dbh->{Active} = 0;
$conn->run( ping => sub {
my $dbha = shift;
isnt $dbha, $dbh, 'Nested should get the same when inactive';
is $_, $dbha, 'Should have dbh in $_';
is $conn->dbh, $dbha, 'Should get same dbh from dbh()';
ok $conn->{_in_run}, '_in_run should be set inside nested run()';
});
});
ok !$conn->{_in_run}, '_in_run should be false again';
# Make sure a nested txn call works, too.
ok ++$conn->{_depth}, 'Increase the transacation depth';
ok !($conn->{_dbh}{Active} = 0), 'Disconnect the handle';
$conn->run( ping => sub {
is shift, $conn->{_dbh},
'The txn nested call to run() should get the deactivated handle';
is $_, $conn->{_dbh}, 'Its should also be in $_';
});
# Make sure nesting works when ping returns false.
$conn->run( ping => sub {
my $dbh = shift;
ok $conn->{_in_run}, '_in_run should be set inside run()';
$dbh_ping_meth->replace( sub { 0 } );
$conn->run( ping => sub {
is shift, $dbh, 'Nested get the same dbh even if ping is false';
is $_, $dbh, 'Should have dbh in $_';
is $conn->dbh, $dbh, 'Should get same dbh from dbh()';
ok $conn->{_in_run}, '_in_run should be set inside nested run()';
});
});
|
