blob: 8db819ee9a3cd7576178822c47374f8a62bc0029 (
plain)
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
|
use strict;
use DBI;
use Test::More;
if (defined $ENV{DBI_DSN}) {
plan tests => 3;
} else {
plan skip_all => 'cannot test without DB info';
}
my $dbh = DBI->connect($ENV{DBI_DSN}, $ENV{DBI_USER}, $ENV{DBI_PASS},
{RaiseError => 1, AutoCommit => 0}
);
ok(defined $dbh,
'connect with transaction'
);
eval {
local $dbh->{PrintError} = 0;
$dbh->do(q{DROP TABLE tt});
$dbh->commit();
};
$dbh->rollback();
$dbh->do(q{CREATE TABLE tt (blah numeric(5,2), foo text)});
my $sth = $dbh->prepare(qq{
SELECT * FROM tt WHERE FALSE
});
$sth->execute();
my @types = @{$sth->{pg_type}};
ok($types[0] eq 'numeric',
'type numeric'
);
ok($types[1] eq 'text',
'type text'
);
$sth->finish();
$dbh->rollback();
$dbh->disconnect();
|