line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package DBIx::Class::Storage::DBI::SQLAnywhere; |
2
|
|
|
|
|
|
|
|
3
|
3
|
|
|
3
|
|
1519
|
use strict; |
|
3
|
|
|
|
|
8
|
|
|
3
|
|
|
|
|
88
|
|
4
|
3
|
|
|
3
|
|
14
|
use warnings; |
|
3
|
|
|
|
|
6
|
|
|
3
|
|
|
|
|
87
|
|
5
|
3
|
|
|
3
|
|
16
|
use base qw/DBIx::Class::Storage::DBI::UniqueIdentifier/; |
|
3
|
|
|
|
|
5
|
|
|
3
|
|
|
|
|
773
|
|
6
|
3
|
|
|
3
|
|
23
|
use mro 'c3'; |
|
3
|
|
|
|
|
6
|
|
|
3
|
|
|
|
|
16
|
|
7
|
3
|
|
|
3
|
|
89
|
use List::Util 'first'; |
|
3
|
|
|
|
|
6
|
|
|
3
|
|
|
|
|
185
|
|
8
|
3
|
|
|
3
|
|
20
|
use Try::Tiny; |
|
3
|
|
|
|
|
6
|
|
|
3
|
|
|
|
|
188
|
|
9
|
3
|
|
|
3
|
|
20
|
use namespace::clean; |
|
3
|
|
|
|
|
7
|
|
|
3
|
|
|
|
|
17
|
|
10
|
|
|
|
|
|
|
|
11
|
|
|
|
|
|
|
__PACKAGE__->mk_group_accessors(simple => qw/_identity/); |
12
|
|
|
|
|
|
|
__PACKAGE__->sql_limit_dialect ('RowNumberOver'); |
13
|
|
|
|
|
|
|
__PACKAGE__->sql_quote_char ('"'); |
14
|
|
|
|
|
|
|
|
15
|
|
|
|
|
|
|
__PACKAGE__->new_guid('UUIDTOSTR(NEWID())'); |
16
|
|
|
|
|
|
|
|
17
|
|
|
|
|
|
|
# default to the UUID decoding cursor, overridable by the user |
18
|
|
|
|
|
|
|
__PACKAGE__->cursor_class('DBIx::Class::Storage::DBI::SQLAnywhere::Cursor'); |
19
|
|
|
|
|
|
|
|
20
|
|
|
|
|
|
|
=head1 NAME |
21
|
|
|
|
|
|
|
|
22
|
|
|
|
|
|
|
DBIx::Class::Storage::DBI::SQLAnywhere - Driver for SQL Anywhere |
23
|
|
|
|
|
|
|
|
24
|
|
|
|
|
|
|
=head1 DESCRIPTION |
25
|
|
|
|
|
|
|
|
26
|
|
|
|
|
|
|
This class implements autoincrements for SQL Anywhere and provides |
27
|
|
|
|
|
|
|
L<DBIx::Class::InflateColumn::DateTime> support and support for the |
28
|
|
|
|
|
|
|
C<uniqueidentifier> type (via |
29
|
|
|
|
|
|
|
L<DBIx::Class::Storage::DBI::SQLAnywhere::Cursor>.) |
30
|
|
|
|
|
|
|
|
31
|
|
|
|
|
|
|
You need the C<DBD::SQLAnywhere> driver that comes with the SQL Anywhere |
32
|
|
|
|
|
|
|
distribution, B<NOT> the one on CPAN. It is usually under a path such as: |
33
|
|
|
|
|
|
|
|
34
|
|
|
|
|
|
|
/opt/sqlanywhere11/sdk/perl |
35
|
|
|
|
|
|
|
|
36
|
|
|
|
|
|
|
Recommended L<connect_info|DBIx::Class::Storage::DBI/connect_info> settings: |
37
|
|
|
|
|
|
|
|
38
|
|
|
|
|
|
|
on_connect_call => 'datetime_setup' |
39
|
|
|
|
|
|
|
|
40
|
|
|
|
|
|
|
=head1 METHODS |
41
|
|
|
|
|
|
|
|
42
|
|
|
|
|
|
|
=cut |
43
|
|
|
|
|
|
|
|
44
|
0
|
|
|
0
|
1
|
|
sub last_insert_id { shift->_identity } |
45
|
|
|
|
|
|
|
|
46
|
|
|
|
|
|
|
sub _prefetch_autovalues { |
47
|
0
|
|
|
0
|
|
|
my $self = shift; |
48
|
0
|
|
|
|
|
|
my ($source, $colinfo, $to_insert) = @_; |
49
|
|
|
|
|
|
|
|
50
|
0
|
|
|
|
|
|
my $values = $self->next::method(@_); |
51
|
|
|
|
|
|
|
|
52
|
|
|
|
|
|
|
my $identity_col = |
53
|
0
|
|
|
0
|
|
|
first { $colinfo->{$_}{is_auto_increment} } keys %$colinfo; |
|
0
|
|
|
|
|
|
|
54
|
|
|
|
|
|
|
|
55
|
|
|
|
|
|
|
# user might have an identity PK without is_auto_increment |
56
|
|
|
|
|
|
|
# |
57
|
|
|
|
|
|
|
# FIXME we probably should not have supported the above, see what |
58
|
|
|
|
|
|
|
# does it take to move away from it |
59
|
0
|
0
|
|
|
|
|
if (not $identity_col) { |
60
|
0
|
|
|
|
|
|
foreach my $pk_col ($source->primary_columns) { |
61
|
0
|
0
|
0
|
|
|
|
if ( |
|
|
|
0
|
|
|
|
|
62
|
|
|
|
|
|
|
! exists $to_insert->{$pk_col} |
63
|
|
|
|
|
|
|
and |
64
|
|
|
|
|
|
|
$colinfo->{$pk_col}{data_type} |
65
|
|
|
|
|
|
|
and |
66
|
|
|
|
|
|
|
$colinfo->{$pk_col}{data_type} !~ /^uniqueidentifier/i |
67
|
|
|
|
|
|
|
) { |
68
|
0
|
|
|
|
|
|
$identity_col = $pk_col; |
69
|
0
|
|
|
|
|
|
last; |
70
|
|
|
|
|
|
|
} |
71
|
|
|
|
|
|
|
} |
72
|
|
|
|
|
|
|
} |
73
|
|
|
|
|
|
|
|
74
|
0
|
0
|
0
|
|
|
|
if ($identity_col && (not exists $to_insert->{$identity_col})) { |
75
|
0
|
|
|
|
|
|
my $dbh = $self->_get_dbh; |
76
|
0
|
|
|
|
|
|
my $table_name = $source->from; |
77
|
0
|
0
|
|
|
|
|
$table_name = $$table_name if ref $table_name; |
78
|
|
|
|
|
|
|
|
79
|
|
|
|
|
|
|
my ($identity) = try { |
80
|
0
|
|
|
0
|
|
|
$dbh->selectrow_array("SELECT GET_IDENTITY('$table_name')") |
81
|
0
|
|
|
|
|
|
}; |
82
|
|
|
|
|
|
|
|
83
|
0
|
0
|
|
|
|
|
if (defined $identity) { |
84
|
0
|
|
|
|
|
|
$values->{$identity_col} = $identity; |
85
|
0
|
|
|
|
|
|
$self->_identity($identity); |
86
|
|
|
|
|
|
|
} |
87
|
|
|
|
|
|
|
} |
88
|
|
|
|
|
|
|
|
89
|
0
|
|
|
|
|
|
return $values; |
90
|
|
|
|
|
|
|
} |
91
|
|
|
|
|
|
|
|
92
|
|
|
|
|
|
|
sub _uuid_to_str { |
93
|
0
|
|
|
0
|
|
|
my ($self, $data) = @_; |
94
|
|
|
|
|
|
|
|
95
|
0
|
|
|
|
|
|
$data = unpack 'H*', $data; |
96
|
|
|
|
|
|
|
|
97
|
0
|
|
|
|
|
|
for my $pos (8, 13, 18, 23) { |
98
|
0
|
|
|
|
|
|
substr($data, $pos, 0) = '-'; |
99
|
|
|
|
|
|
|
} |
100
|
|
|
|
|
|
|
|
101
|
0
|
|
|
|
|
|
return $data; |
102
|
|
|
|
|
|
|
} |
103
|
|
|
|
|
|
|
|
104
|
|
|
|
|
|
|
# select_single does not invoke a cursor object at all, hence UUID decoding happens |
105
|
|
|
|
|
|
|
# here if the proper cursor class is set |
106
|
|
|
|
|
|
|
sub select_single { |
107
|
0
|
|
|
0
|
1
|
|
my $self = shift; |
108
|
|
|
|
|
|
|
|
109
|
0
|
|
|
|
|
|
my @row = $self->next::method(@_); |
110
|
|
|
|
|
|
|
|
111
|
|
|
|
|
|
|
return @row |
112
|
0
|
0
|
|
|
|
|
unless $self->cursor_class->isa('DBIx::Class::Storage::DBI::SQLAnywhere::Cursor'); |
113
|
|
|
|
|
|
|
|
114
|
0
|
|
|
|
|
|
my ($ident, $select) = @_; |
115
|
|
|
|
|
|
|
|
116
|
0
|
|
|
|
|
|
my $col_info = $self->_resolve_column_info($ident); |
117
|
|
|
|
|
|
|
|
118
|
0
|
|
|
|
|
|
for my $select_idx (0..$#$select) { |
119
|
0
|
|
|
|
|
|
my $selected = $select->[$select_idx]; |
120
|
|
|
|
|
|
|
|
121
|
0
|
0
|
|
|
|
|
next if ref $selected; |
122
|
|
|
|
|
|
|
|
123
|
|
|
|
|
|
|
my $data_type = $col_info->{$selected}{data_type} |
124
|
0
|
0
|
|
|
|
|
or next; |
125
|
|
|
|
|
|
|
|
126
|
0
|
0
|
|
|
|
|
if ($self->_is_guid_type($data_type)) { |
127
|
0
|
|
|
|
|
|
my $returned = $row[$select_idx]; |
128
|
|
|
|
|
|
|
|
129
|
0
|
0
|
|
|
|
|
if (length $returned == 16) { |
130
|
0
|
|
|
|
|
|
$row[$select_idx] = $self->_uuid_to_str($returned); |
131
|
|
|
|
|
|
|
} |
132
|
|
|
|
|
|
|
} |
133
|
|
|
|
|
|
|
} |
134
|
|
|
|
|
|
|
|
135
|
0
|
|
|
|
|
|
return @row; |
136
|
|
|
|
|
|
|
} |
137
|
|
|
|
|
|
|
|
138
|
|
|
|
|
|
|
# this sub stolen from MSSQL |
139
|
|
|
|
|
|
|
|
140
|
|
|
|
|
|
|
sub build_datetime_parser { |
141
|
0
|
|
|
0
|
1
|
|
my $self = shift; |
142
|
0
|
|
|
|
|
|
my $type = "DateTime::Format::Strptime"; |
143
|
|
|
|
|
|
|
try { |
144
|
0
|
|
|
0
|
|
|
eval "require ${type}" |
145
|
|
|
|
|
|
|
} |
146
|
|
|
|
|
|
|
catch { |
147
|
0
|
|
|
0
|
|
|
$self->throw_exception("Couldn't load ${type}: $_"); |
148
|
0
|
|
|
|
|
|
}; |
149
|
|
|
|
|
|
|
|
150
|
0
|
|
|
|
|
|
return $type->new( pattern => '%Y-%m-%d %H:%M:%S.%6N' ); |
151
|
|
|
|
|
|
|
} |
152
|
|
|
|
|
|
|
|
153
|
|
|
|
|
|
|
=head2 connect_call_datetime_setup |
154
|
|
|
|
|
|
|
|
155
|
|
|
|
|
|
|
Used as: |
156
|
|
|
|
|
|
|
|
157
|
|
|
|
|
|
|
on_connect_call => 'datetime_setup' |
158
|
|
|
|
|
|
|
|
159
|
|
|
|
|
|
|
In L<connect_info|DBIx::Class::Storage::DBI/connect_info> to set the date and |
160
|
|
|
|
|
|
|
timestamp formats (as temporary options for the session) for use with |
161
|
|
|
|
|
|
|
L<DBIx::Class::InflateColumn::DateTime>. |
162
|
|
|
|
|
|
|
|
163
|
|
|
|
|
|
|
The C<TIMESTAMP> data type supports up to 6 digits after the decimal point for |
164
|
|
|
|
|
|
|
second precision. The full precision is used. |
165
|
|
|
|
|
|
|
|
166
|
|
|
|
|
|
|
The C<DATE> data type supposedly stores hours and minutes too, according to the |
167
|
|
|
|
|
|
|
documentation, but I could not get that to work. It seems to only store the |
168
|
|
|
|
|
|
|
date. |
169
|
|
|
|
|
|
|
|
170
|
|
|
|
|
|
|
You will need the L<DateTime::Format::Strptime> module for inflation to work. |
171
|
|
|
|
|
|
|
|
172
|
|
|
|
|
|
|
=cut |
173
|
|
|
|
|
|
|
|
174
|
|
|
|
|
|
|
sub connect_call_datetime_setup { |
175
|
0
|
|
|
0
|
1
|
|
my $self = shift; |
176
|
|
|
|
|
|
|
|
177
|
0
|
|
|
|
|
|
$self->_do_query( |
178
|
|
|
|
|
|
|
"set temporary option timestamp_format = 'yyyy-mm-dd hh:mm:ss.ssssss'" |
179
|
|
|
|
|
|
|
); |
180
|
0
|
|
|
|
|
|
$self->_do_query( |
181
|
|
|
|
|
|
|
"set temporary option date_format = 'yyyy-mm-dd hh:mm:ss.ssssss'" |
182
|
|
|
|
|
|
|
); |
183
|
|
|
|
|
|
|
} |
184
|
|
|
|
|
|
|
|
185
|
|
|
|
|
|
|
sub _exec_svp_begin { |
186
|
0
|
|
|
0
|
|
|
my ($self, $name) = @_; |
187
|
|
|
|
|
|
|
|
188
|
0
|
|
|
|
|
|
$self->_dbh->do("SAVEPOINT $name"); |
189
|
|
|
|
|
|
|
} |
190
|
|
|
|
|
|
|
|
191
|
|
|
|
|
|
|
# can't release savepoints that have been rolled back |
192
|
0
|
|
|
0
|
|
|
sub _exec_svp_release { 1 } |
193
|
|
|
|
|
|
|
|
194
|
|
|
|
|
|
|
sub _exec_svp_rollback { |
195
|
0
|
|
|
0
|
|
|
my ($self, $name) = @_; |
196
|
|
|
|
|
|
|
|
197
|
0
|
|
|
|
|
|
$self->_dbh->do("ROLLBACK TO SAVEPOINT $name") |
198
|
|
|
|
|
|
|
} |
199
|
|
|
|
|
|
|
|
200
|
|
|
|
|
|
|
1; |
201
|
|
|
|
|
|
|
|
202
|
|
|
|
|
|
|
=head1 MAXIMUM CURSORS |
203
|
|
|
|
|
|
|
|
204
|
|
|
|
|
|
|
A L<DBIx::Class> application can use a lot of cursors, due to the usage of |
205
|
|
|
|
|
|
|
L<prepare_cached|DBI/prepare_cached>. |
206
|
|
|
|
|
|
|
|
207
|
|
|
|
|
|
|
The default cursor maximum is C<50>, which can be a bit too low. This limit can |
208
|
|
|
|
|
|
|
be turned off (or increased) by the DBA by executing: |
209
|
|
|
|
|
|
|
|
210
|
|
|
|
|
|
|
set option max_statement_count = 0 |
211
|
|
|
|
|
|
|
set option max_cursor_count = 0 |
212
|
|
|
|
|
|
|
|
213
|
|
|
|
|
|
|
Highly recommended. |
214
|
|
|
|
|
|
|
|
215
|
|
|
|
|
|
|
=head1 FURTHER QUESTIONS? |
216
|
|
|
|
|
|
|
|
217
|
|
|
|
|
|
|
Check the list of L<additional DBIC resources|DBIx::Class/GETTING HELP/SUPPORT>. |
218
|
|
|
|
|
|
|
|
219
|
|
|
|
|
|
|
=head1 COPYRIGHT AND LICENSE |
220
|
|
|
|
|
|
|
|
221
|
|
|
|
|
|
|
This module is free software L<copyright|DBIx::Class/COPYRIGHT AND LICENSE> |
222
|
|
|
|
|
|
|
by the L<DBIx::Class (DBIC) authors|DBIx::Class/AUTHORS>. You can |
223
|
|
|
|
|
|
|
redistribute it and/or modify it under the same terms as the |
224
|
|
|
|
|
|
|
L<DBIx::Class library|DBIx::Class/COPYRIGHT AND LICENSE>. |