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
|
#!/usr/bin/perl -w
# test for ib_tx_info()
use strict;
use warnings;
use Data::Dumper;
use Test::More;
use lib 't','.';
use TestFirebird;
my $T = TestFirebird->new;
my ($dbh1, $error_str) = $T->connect_to_database({AutoCommit => 0});
if ($error_str) {
BAIL_OUT("Unknown: $error_str!");
}
unless ( $dbh1->isa('DBI::db') ) {
plan skip_all => 'Connection to database failed, cannot continue testing';
}
else {
plan tests => 9;
}
ok($dbh1, 'Connected to the database');
ok($dbh1->selectall_arrayref(q{SELECT COUNT(1) FROM RDB$DATABASE}));
my $info = $dbh1->func('ib_tx_info');
ok($info);
print Dumper($info);
ok($dbh1->commit);
ok($dbh1->func(
-isolation_level => 'read_committed',
'ib_set_tx_param'
),
"change isolation level"
);
ok($dbh1->selectall_arrayref(q{SELECT COUNT(1) FROM RDB$DATABASE}));
$info = $dbh1->func('ib_tx_info');
ok($info);
print Dumper($info);
ok($dbh1->commit);
ok($dbh1->disconnect);
|
