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
|
use strict;
use warnings;
# database specific definitions for a 'mysql' database
my $have_transactions;
#
# This function generates a list of tables associated to a
# given DSN.
#
sub ListTables(@) {
my($dbh) = shift;
my(@tables);
@tables = $dbh->func('_ListTables');
if ($dbh->errstr) {
die "Cannot create table list: " . $dbh->errstr;
}
@tables;
}
#
# This function is called by DBD::pNET; given a hostname and a
# dsn without hostname, return a dsn for connecting to dsn at
# host.
sub HostDsn ($$) {
my($hostname, $dsn) = @_;
"$dsn:$hostname";
}
#
# Return TRUE, if database supports transactions
#
sub have_transactions () {
my ($dbh) = @_;
return 1 unless $dbh;
if (!defined($have_transactions)) {
$have_transactions = "";
my $sth = $dbh->prepare("SHOW VARIABLES");
$sth->execute();
while (my $row = $sth->fetchrow_hashref()) {
if ($row->{'Variable_name'} eq 'have_bdb' &&
$row->{'Value'} eq 'YES') {
$have_transactions = "bdb";
last;
}
if ($row->{'Variable_name'} eq 'have_innodb' &&
$row->{'Value'} eq 'YES') {
$have_transactions = "innodb";
last;
}
if ($row->{'Variable_name'} eq 'have_gemini' &&
$row->{'Value'} eq 'YES') {
$have_transactions = "gemini";
last;
}
}
}
return $have_transactions;
}
1;
|
