Avatica/Adapter/Default.pm

filter: Statementstmt 91.6% 22 / 24 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 100% 8 / 8 Podpod n/a totaltotal 93.7% 30 / 32 CC 1 SCAR 0.4
CC
1
Cov
92%
BEGIN
1.3
BEGIN
1.0
BEGIN
1.0
CRAP 1.0
« Avatica/Adapter/Phoenix.pm ↑ Summary
1 package DBD::Avatica::Adapter::Default;
2  
3 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 1 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
5  
6 1 ▶use Scalar::Util 'weaken';
Subroutine BEGIN: called CC=1 SCAR=0.0
7 1 ▶use Carp 'croak';
Subroutine BEGIN: called CC=1 SCAR=0.0
8 1 ▶use Time::Piece;
Subroutine BEGIN: called CC=1 SCAR=0.0
9 1 ▶use Scalar::Util qw/looks_like_number/;
Subroutine BEGIN: called CC=1 SCAR=0.0
10 1 ▶use DBI ':sql_types';
Subroutine BEGIN: called CC=1 SCAR=0.0
11  
12 0 ▶use Avatica::Client;
Subroutine BEGIN: called CC=1 SCAR=2.6
13  
14 #
15 # JAVA Types https://github.com/JetBrains/jdk8u_jdk/blob/master/src/share/classes/java/sql/Types.java
16 #
17  
18 use constant JAVA_TO_REP => {
19 -6 => Avatica::Client::Protocol::Rep::BYTE(), # TINYINT
20 5 => Avatica::Client::Protocol::Rep::SHORT(), # SMALLINT
21 4 => Avatica::Client::Protocol::Rep::INTEGER(), # INTEGER
22 -5 => Avatica::Client::Protocol::Rep::LONG(), # BIGINT
23 6 => Avatica::Client::Protocol::Rep::DOUBLE(), # FLOAT
24 8 => Avatica::Client::Protocol::Rep::DOUBLE(), # DOUBLE
25 2 => Avatica::Client::Protocol::Rep::BIG_DECIMAL(), # NUMERIC
26 1 => Avatica::Client::Protocol::Rep::STRING(), # CHAR
27 91 => Avatica::Client::Protocol::Rep::JAVA_SQL_DATE(), # DATE
28 92 => Avatica::Client::Protocol::Rep::JAVA_SQL_TIME(), # TIME
29 93 => Avatica::Client::Protocol::Rep::JAVA_SQL_TIMESTAMP(), # TIMESTAMP
30 -2 => Avatica::Client::Protocol::Rep::BYTE_STRING(), # BINARY
31 -3 => Avatica::Client::Protocol::Rep::BYTE_STRING(), # VARBINARY
32 16 => Avatica::Client::Protocol::Rep::BOOLEAN(), # BOOLEAN
33  
34 -7 => Avatica::Client::Protocol::Rep::BOOLEAN(), # BIT
35 7 => Avatica::Client::Protocol::Rep::DOUBLE(), # REAL
36 3 => Avatica::Client::Protocol::Rep::BIG_DECIMAL(), # DECIMAL
37 12 => Avatica::Client::Protocol::Rep::STRING(), # VARCHAR
38 -1 => Avatica::Client::Protocol::Rep::STRING(), # LONGVARCHAR
39 -4 => Avatica::Client::Protocol::Rep::BYTE_STRING(), # LONGVARBINARY
40 2004 => Avatica::Client::Protocol::Rep::BYTE_STRING(), # BLOB
41 2005 => Avatica::Client::Protocol::Rep::STRING(), # CLOB
42 -15 => Avatica::Client::Protocol::Rep::STRING(), # NCHAR
43 -9 => Avatica::Client::Protocol::Rep::STRING(), # NVARCHAR
44 -16 => Avatica::Client::Protocol::Rep::STRING(), # LONGNVARCHAR
45 2011 => Avatica::Client::Protocol::Rep::STRING(), # NCLOB
46 2009 => Avatica::Client::Protocol::Rep::STRING(), # SQLXML
47 2013 => Avatica::Client::Protocol::Rep::JAVA_SQL_TIME(), # TIME_WITH_TIMEZONE
48 2014 => Avatica::Client::Protocol::Rep::JAVA_SQL_TIMESTAMP(), # TIMESTAMP_WITH_TIMEZONE
49  
50 # Returned by Avatica for Arrays in EMPTY resultsets
51 2000 => Avatica::Client::Protocol::Rep::BYTE_STRING(), # JAVA_OBJECT
52 };
53  
54 use constant REP_TO_TYPE_VALUE => {
55 Avatica::Client::Protocol::Rep::INTEGER() => 'number_value',
56 Avatica::Client::Protocol::Rep::PRIMITIVE_INT() => 'number_value',
57 Avatica::Client::Protocol::Rep::SHORT() => 'number_value',
58 Avatica::Client::Protocol::Rep::PRIMITIVE_SHORT() => 'number_value',
59 Avatica::Client::Protocol::Rep::LONG() => 'number_value',
60 Avatica::Client::Protocol::Rep::PRIMITIVE_LONG() => 'number_value',
61 Avatica::Client::Protocol::Rep::BYTE() => 'number_value',
62 Avatica::Client::Protocol::Rep::JAVA_SQL_TIME() => 'number_value',
63 Avatica::Client::Protocol::Rep::JAVA_SQL_DATE() => 'number_value',
64 Avatica::Client::Protocol::Rep::JAVA_SQL_TIMESTAMP() => 'number_value',
65  
66 Avatica::Client::Protocol::Rep::BYTE_STRING() => 'bytes_value',
67  
68 Avatica::Client::Protocol::Rep::DOUBLE() => 'double_value',
69 Avatica::Client::Protocol::Rep::PRIMITIVE_DOUBLE() => 'double_value',
70  
71 Avatica::Client::Protocol::Rep::PRIMITIVE_CHAR() => 'string_value',
72 Avatica::Client::Protocol::Rep::CHARACTER() => 'string_value',
73 Avatica::Client::Protocol::Rep::BIG_DECIMAL() => 'string_value',
74 Avatica::Client::Protocol::Rep::STRING() => 'string_value',
75  
76 Avatica::Client::Protocol::Rep::BOOLEAN() => 'bool_value',
77 Avatica::Client::Protocol::Rep::PRIMITIVE_BOOLEAN() => 'bool_value',
78 };
79  
80 use constant JAVA_TO_DBI => {
81 -6 => SQL_TINYINT, # TINYINT
82 5 => SQL_SMALLINT, # SMALLINT
83 4 => SQL_INTEGER, # INTEGER
84 -5 => SQL_BIGINT, # BIGINT
85 6 => SQL_FLOAT, # FLOAT
86 8 => SQL_DOUBLE, # DOUBLE
87 2 => SQL_NUMERIC, # NUMERIC
88 1 => SQL_CHAR, # CHAR
89 91 => SQL_TYPE_DATE, # DATE
90 92 => SQL_TYPE_TIME, # TIME
91 93 => SQL_TYPE_TIMESTAMP, # TIMESTAMP
92 -2 => SQL_BINARY, # BINARY
93 -3 => SQL_VARBINARY, # VARBINARY
94 16 => SQL_BOOLEAN, # BOOLEAN
95  
96 -7 => SQL_BIT, # BIT
97 7 => SQL_REAL, # REAL
98 3 => SQL_DECIMAL, # DECIMAL
99 12 => SQL_VARCHAR, # VARCHAR
100 -1 => SQL_LONGVARCHAR, # LONGVARCHAR
101 -4 => SQL_LONGVARBINARY, # LONGVARBINARY
102 2004 => SQL_BLOB, # BLOB
103 2005 => SQL_CLOB, # CLOB
104 -15 => SQL_CHAR, # NCHAR
105 -9 => SQL_VARCHAR, # NVARCHAR
106 -16 => SQL_LONGVARCHAR, # LONGNVARCHAR
107 2011 => SQL_CLOB, # NCLOB
108 2009 => SQL_LONGVARCHAR, # SQLXML
109 2013 => SQL_TYPE_TIME_WITH_TIMEZONE, # TIME_WITH_TIMEZONE
110 2014 => SQL_TYPE_TIMESTAMP_WITH_TIMEZONE, # TIMESTAMP_WITH_TIMEZONE
111  
112 # Returned by Avatica for Arrays in EMPTY resultsets
113 2000 => SQL_ARRAY, # JAVA_OBJECT
114 2003 => SQL_ARRAY, # ARRAY
115 };
116  
117 sub new {
118 my ($class, %params) = @_;
119  
120 my $self = {dbh => $params{dbh}};
121 weaken $self->{dbh};
122  
123 return bless $self, $class;
124 }
125  
126 # params:
127 # self
128 # [Avatica::Client::Protocol::ColumnValue, ...]
129 # [Avatica::Client::Protocol::ColumnMetaData, ...]
130 sub row_from_jdbc {
131 my ($self, $columns_values, $columns_meta) = @_;
132 croak 'The number of arguments is not the same as the expected number' if $#{$columns_values} != $#{$columns_meta};
133 return [
134 map {
135 $self->from_jdbc($columns_values->[$_], $columns_meta->[$_])
136 }
137 0 .. $#{$columns_meta}
138 ];
139 }
140  
141 # params:
142 # self
143 # Avatica::Client::Protocol::ColumnValue
144 # Avatica::Client::Protocol::ColumnMetaData
145 sub from_jdbc {
146 my ($self, $column_value, $column_meta) = @_;
147  
148 my $scalar_value = $column_value->get_scalar_value;
149  
150 return (undef,) if $scalar_value && $scalar_value->get_null;
151  
152 if ($column_value->get_has_array_value) {
153 my $jdbc_type_id = $column_meta->get_type->get_component->get_id;
154 my $rep = $self->convert_jdbc_to_rep_type($jdbc_type_id);
155  
156 my $type = $self->REP_TO_TYPE_VALUE()->{$rep};
157 my $method = "get_$type";
158  
159 my $values = [];
160 for my $v (@{$column_value->get_array_value_list}) {
161 my $res = $v->$method();
162 push @$values, $self->convert_from_jdbc($res, $rep);
163 }
164  
165 return $values;
166 }
167  
168 my $jdbc_type_id = $column_meta->get_type->get_id;
169 my $rep = $self->convert_jdbc_to_rep_type($jdbc_type_id);
170  
171 my $type = $self->REP_TO_TYPE_VALUE()->{$rep};
172 my $method = "get_$type";
173  
174 my $res = $scalar_value->$method();
175  
176 return $self->convert_from_jdbc($res, $rep);
177 }
178  
179 # params:
180 # self
181 # values
182 # [Avatica::Client::Protocol::AvaticaParameter, ...]
183 sub row_to_jdbc {
184 my ($self, $values, $avatica_params) = @_;
185 croak 'The number of arguments is not the same as the expected number' if $#{$values} != $#{$avatica_params};
186 return [
187 map {
188 $self->to_jdbc($values->[$_], $avatica_params->[$_])
189 }
190 0 .. $#{$avatica_params}
191 ];
192 }
193  
194 # params:
195 # self
196 # value
197 # Avatica::Client::Protocol::AvaticaParameter
198 sub to_jdbc {
199 my ($self, $value, $avatica_param) = @_;
200  
201 my $jdbc_type_id = $avatica_param->get_parameter_type;
202  
203 my $typed_value = Avatica::Client::Protocol::TypedValue->new;
204  
205 unless (defined $value) {
206 $typed_value->set_null(1);
207 $typed_value->set_type(Avatica::Client::Protocol::Rep::NULL());
208 return $typed_value;
209 }
210  
211 $typed_value->set_null(0);
212  
213 my $rep = $self->convert_jdbc_to_rep_type($jdbc_type_id);
214 croak "Unknown jdbc type: $jdbc_type_id" unless $rep;
215 my $type = $self->REP_TO_TYPE_VALUE->{$rep};
216 croak "Unknown rep type: $rep" unless $type;
217  
218 my $method = "set_$type";
219  
220 $typed_value->set_type($rep);
221 $typed_value->$method($self->convert_to_jdbc($value, $rep));
222  
223 return $typed_value;
224 }
225  
226 sub convert_from_jdbc {
227 my ($self, $value, $rep) = @_;
228  
229 if ($rep == Avatica::Client::Protocol::Rep::JAVA_SQL_TIME()) {
230 my $sec = int($value / 1000);
231 my $milli = $value % 1000;
232 my $time = Time::Piece->strptime($sec, '%s')->time;
233 $time .= '.' . $milli if $milli;
234 return $time;
235 }
236  
237 if ($rep == Avatica::Client::Protocol::Rep::JAVA_SQL_DATE()) {
238 return Time::Piece->strptime($value * 86400, '%s')->ymd;
239 }
240  
241 if ($rep == Avatica::Client::Protocol::Rep::JAVA_SQL_TIMESTAMP()) {
242 my $sec = int($value / 1000);
243 my $milli = $value % 1000;
244 my $datetime = Time::Piece->strptime($sec, '%s')->strftime('%Y-%m-%d %H:%M:%S');
245 $datetime .= '.' . $milli if $milli;
246 return $datetime;
247 }
248  
249 return $value;
250 }
251  
252 sub convert_to_jdbc {
253 my ($self, $value, $rep) = @_;
254  
255 if ($rep == Avatica::Client::Protocol::Rep::JAVA_SQL_TIME()) {
256 return $value if looks_like_number($value);
257  
258 my ($datetime, $milli) = split /\./, $value;
259 my ($date, $time) = split /[tT ]/, $datetime;
260 $time = $date unless $time;
261  
262 my ($h, $m, $s) = split /:/, $time;
263 return ((($h // 0) * 60 + ($m // 0)) * 60 + ($s // 0)) * 1000 + ($milli ? substr($milli . '00', 0, 3) : 0);
264 }
265  
266 if ($rep == Avatica::Client::Protocol::Rep::JAVA_SQL_DATE()) {
267 return $value if looks_like_number($value);
268 my ($datetime, $milli) = split /\./, $value;
269 my ($date, $time) = split /[tT ]/, $datetime;
270 return Time::Piece->strptime($date, '%Y-%m-%d')->epoch / 86400;
271 }
272  
273 if ($rep == Avatica::Client::Protocol::Rep::JAVA_SQL_TIMESTAMP()) {
274 return $value if looks_like_number($value);
275 my ($datetime, $milli) = split /\./, $value;
276 $datetime =~ s/[Tt]/ /;
277 my $sec = Time::Piece->strptime($datetime, '%Y-%m-%d %H:%M:%S')->epoch;
278 return $sec * 1000 + ($milli ? substr($milli . '00', 0, 3) : 0);
279 }
280  
281 return $value;
282 }
283  
284 sub convert_jdbc_to_rep_type {
285 my ($self, $jdbc_type) = @_;
286 if ($jdbc_type > 0x7FFFFFFF) {
287 $jdbc_type = -(($jdbc_type ^ 0xFFFFFFFF) + 1);
288 }
289 return $self->JAVA_TO_REP()->{$jdbc_type};
290 }
291  
292 # params:
293 # self
294 # Avatica::Client::Protocol::AvaticaType
295 sub to_dbi {
296 my ($self, $avatica_type) = @_;
297 my $java_type_id = $avatica_type->get_id;
298  
299 if ($java_type_id > 0x7FFFFFFF) {
300 $java_type_id = -(($java_type_id ^ 0xFFFFFFFF) + 1);
301 }
302  
303 my $dbi_type_id = $self->JAVA_TO_DBI()->{$java_type_id};
304 return $java_type_id unless $dbi_type_id;
305 return $dbi_type_id;
306 }
307  
308 # may be phoenix specific code
309 sub map_database_properties {
310 my ($self, $properties) = @_;
311  
312 my $res = {
313 AVATICA_DRIVER_NAME => '',
314 AVATICA_DRIVER_VERSION => '',
315 DBMS_NAME => '',
316 DBMS_VERSION => '',
317 SQL_KEYWORDS => ''
318 };
319  
320 for my $p (@$properties) {
321 my $name = $p->get_key->get_name // '';
322 if ($name eq 'GET_DRIVER_NAME') {
323 $res->{AVATICA_DRIVER_NAME} = $p->get_value->get_string_value;
324 } elsif ($name eq 'GET_DRIVER_VERSION') {
325 $res->{AVATICA_DRIVER_VERSION} = $p->get_value->get_string_value;
326 } elsif ($name eq 'GET_DATABASE_PRODUCT_VERSION') {
327 $res->{DBMS_VERSION} = $p->get_value->get_string_value;
328 } elsif ($name eq 'GET_DATABASE_PRODUCT_NAME') {
329 $res->{DBMS_NAME} = $p->get_value->get_string_value;
330 } elsif ($name eq 'GET_S_Q_L_KEYWORDS') {
331 $res->{SQL_KEYWORDS} = $p->get_value->get_string_value;
332 }
333 }
334  
335 return $res;
336 }
337  
338 # params:
339 # self
340 # Avatica::Client::Protocol::Signature
341 sub extend_primary_key_info_signature {
342 my ($self, $signature) = @_;
343 return $signature;
344 }
345  
346 1;
347  
348 __END__
« Avatica/Adapter/Phoenix.pm ↑ Summary