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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
|
#!/usr/local/bin/perl
#
#
# This is a test for date/time types handling with localtime() style.
#
# 2011-01-29 stefansbv
# New version based on t/testlib.pl and Firebird.dbtest
use strict;
use warnings;
use Test::More;
use DBI qw(:sql_types);
use lib 't','.';
use TestFirebird;
my $T = TestFirebird->new;
my ( $dbh, $error_str ) = $T->connect_to_database( { ChopBlanks => 1 } );
if ($error_str) {
BAIL_OUT("Unknown: $error_str!");
}
unless ( $dbh->isa('DBI::db') ) {
plan skip_all => 'Connection to database failed, cannot continue testing';
}
else {
plan tests => 14;
}
ok($dbh, 'Connected to the database');
# DBI->trace(4, "trace.txt");
# ------- TESTS ------------------------------------------------------------- #
#
# Find a possible new table name
#
my $table = find_new_table($dbh);
ok($table, "TABLE is '$table'");
my @times = localtime();
my @is_match = (
sub {
my $ref = shift->[0]->[0];
return ($$ref[0] == $times[0]) &&
($$ref[1] == $times[1]) &&
($$ref[2] == $times[2]) &&
($$ref[3] == $times[3]) &&
($$ref[4] == $times[4]) &&
($$ref[5] == $times[5]);
},
sub {
my $ref = shift->[0]->[1];
return ($$ref[3] == $times[3]) &&
($$ref[4] == $times[4]) &&
($$ref[5] == $times[5]);
},
sub {
my $ref = shift->[0]->[2];
return ($$ref[0] == $times[0]) &&
($$ref[1] == $times[1]) &&
($$ref[2] == $times[2]);
}
);
#
# Create a new table
#
my $def =<<"DEF";
CREATE TABLE $table (
A_TIMESTAMP TIMESTAMP,
A_DATE DATE,
A_TIME TIME
)
DEF
ok( $dbh->do($def), qq{CREATE TABLE '$table'} );
#
# Insert some values
#
my $stmt =<<"END_OF_QUERY";
INSERT INTO $table
(
A_TIMESTAMP,
A_DATE,
A_TIME
)
VALUES (?, ?, ?)
END_OF_QUERY
ok(my $insert = $dbh->prepare($stmt), 'PREPARE INSERT');
ok($insert->execute(\@times, \@times, \@times));
#
# Select the values
#
ok(
my $cursor = $dbh->prepare(
"SELECT * FROM $table",
{
ib_timestampformat => 'TM',
ib_dateformat => 'TM',
ib_timeformat => 'TM',
}
)
);
ok($cursor->execute);
ok((my $res = $cursor->fetchall_arrayref), 'FETCHALL');
my ($types, $names, $fields) = @{$cursor}{qw(TYPE NAME NUM_OF_FIELDS)};
for (my $i = 0; $i < $fields; $i++) {
ok(( $is_match[$i]->($res) ), "field: $names->[$i] ($types->[$i])");
}
#
# Drop the test table
#
$dbh->{AutoCommit} = 1;
ok( $dbh->do("DROP TABLE $table"), "DROP TABLE '$table'" );
# NUM_OF_FIELDS should be zero (Non-Select)
ok(($cursor->{'NUM_OF_FIELDS'}), "NUM_OF_FIELDS == 0");
#
# Finally disconnect.
#
ok($dbh->disconnect());
|
