Avatica/Adapter/Phoenix.pm

filter: Statementstmt 83.3% 10 / 12 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 100% 4 / 4 Podpod n/a totaltotal 87.5% 14 / 16 CC 1 SCAR 0.7
CC
1
Cov
83%
BEGIN
1.3
BEGIN
1.0
BEGIN
1.0
CRAP 1.1
« Avatica.pm ↑ Summary Avatica/Adapter/Default.pm »
1 package DBD::Avatica::Adapter::Phoenix;
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 DBI ':sql_types';
Subroutine BEGIN: called CC=1 SCAR=0.0
7  
8 0 ▶use Avatica::Client;
Subroutine BEGIN: called CC=1 SCAR=2.6
9  
10 use parent 'DBD::Avatica::Adapter::Default';
11  
12 use constant JAVA_TO_REP => {
13 %{DBD::Avatica::Adapter::Default->JAVA_TO_REP()},
14  
15 # These are the non-standard types defined by Phoenix
16 18 => Avatica::Client::Protocol::Rep::JAVA_SQL_TIME(), # UNSIGNED_TIME
17 19 => Avatica::Client::Protocol::Rep::JAVA_SQL_DATE(), # UNSIGNED_DATE
18 15 => Avatica::Client::Protocol::Rep::DOUBLE(), # UNSIGNED_DOUBLE
19 14 => Avatica::Client::Protocol::Rep::DOUBLE(), # UNSIGNED_FLOAT
20 9 => Avatica::Client::Protocol::Rep::INTEGER(), # UNSIGNED_INT
21 10 => Avatica::Client::Protocol::Rep::LONG(), # UNSIGNED_LONG
22 13 => Avatica::Client::Protocol::Rep::SHORT(), # UNSIGNED_SMALLINT
23 20 => Avatica::Client::Protocol::Rep::JAVA_SQL_TIMESTAMP(), # UNSIGNED_TIMESTAMP
24 11 => Avatica::Client::Protocol::Rep::BYTE(), # UNSIGNED_TINYINT
25 };
26  
27 # params:
28 # self
29 # value
30 # Avatica::Client::Protocol::AvaticaParameter
31 sub to_jdbc {
32 my ($self, $value, $avatica_param) = @_;
33  
34 my $jdbc_type_id = $avatica_param->get_parameter_type;
35  
36 # Phoenix add base 3000 for array types
37 # https://github.com/apache/phoenix/blob/2a2d9964d29c2e47667114dbc3ca43c0e264a221/phoenix-core/src/main/java/org/apache/phoenix/schema/types/PDataType.java#L518
38 my $is_array = $jdbc_type_id > 2900 && $jdbc_type_id < 3100;
39 return $self->SUPER::to_jdbc($value, $avatica_param) unless $is_array && defined $value;
40  
41 # Phoenix added arrays with base 3000
42  
43 my $element_rep = $self->convert_jdbc_to_rep_type($jdbc_type_id - 3000);
44  
45 my $elem_avatica_param = Avatica::Client::Protocol::AvaticaParameter->new;
46 $elem_avatica_param->set_parameter_type($jdbc_type_id - 3000);
47  
48 my $typed_value = Avatica::Client::Protocol::TypedValue->new;
49 $typed_value->set_null(0);
50 $typed_value->set_type(Avatica::Client::Protocol::Rep::ARRAY());
51 $typed_value->set_component_type($element_rep);
52  
53 for my $v (@$value) {
54 my $tv = $self->SUPER::to_jdbc($v, $elem_avatica_param);
55 $typed_value->add_array_value($tv);
56 }
57  
58 return $typed_value;
59 }
60  
61 # params:
62 # self
63 # Avatica::Client::Protocol::AvaticaType
64 sub to_dbi {
65 my ($self, $avatica_type) = @_;
66 my $java_type_id = $avatica_type->get_id;
67  
68 if ($java_type_id > 0x7FFFFFFF) {
69 $java_type_id = -(($java_type_id ^ 0xFFFFFFFF) + 1);
70 }
71  
72 # ARRAY (may be for bind params only)
73 return SQL_ARRAY if $java_type_id > 2900 && $java_type_id < 3100;
74  
75 return $self->SUPER::to_dbi($avatica_type);
76 }
77  
78 # params:
79 # self
80 # Avatica::Client::Protocol::Signature
81 sub extend_primary_key_info_signature {
82 my ($self, $signature) = @_;
83 # This returns '\x00\x00\x00A' or '\x00\x00\x00D' , but that's consistent with Java
84 $signature->add_columns(Avatica::Client->_build_column_metadata(7, 'ASC_OR_DESC', 12));
85 $signature->add_columns(Avatica::Client->_build_column_metadata(8, 'DATA_TYPE', 5));
86 $signature->add_columns(Avatica::Client->_build_column_metadata(9, 'TYPE_NAME', 12));
87 $signature->add_columns(Avatica::Client->_build_column_metadata(10, 'COLUMN_SIZE', 5));
88 $signature->add_columns(Avatica::Client->_build_column_metadata(11, 'TYPE_ID', 5));
89 $signature->add_columns(Avatica::Client->_build_column_metadata(12, 'VIEW_CONSTANT', 12));
90 return $signature;
91 }
92  
93 sub last_insert_id {
94 my ($self, $dbh, undef, $schema, $table, $column, $attr) = @_;
95  
96 return $dbh->set_err(1, qq{Param "table" must be specified}) unless $table;
97  
98 my $seq = $attr->{sequence};
99 my $quote = $dbh->get_info('SQL_IDENTIFIER_QUOTE_CHAR');
100  
101 # try to determine sequence
102 unless ($seq) {
103 my $system_table = "${quote}SYSTEM${quote}.${quote}SEQUENCE${quote}";
104 my $where = $schema ? "SEQUENCE_SCHEMA = '$schema' AND " : '';
105 $where .= "SEQUENCE_NAME LIKE '$table" . ($column ? "_${column}%" : '%') . "'";
106  
107 my $res = $dbh->selectrow_hashref(qq{SELECT * FROM $system_table WHERE $where LIMIT 1});
108 unless ($res) {
109 return if $dbh->errstr;
110 return $dbh->set_err(1, qq{Could not determine the sequence of table $table});
111 }
112  
113 $seq = $res->{SEQUENCE_NAME};
114 }
115  
116 my $full_table_name = $schema ? "${quote}${schema}${quote}." : '';
117 $full_table_name .= "${quote}$table${quote}";
118  
119 # add schema to sequence
120 if ($schema && index($seq, $schema) == -1) {
121 $seq = "${quote}${schema}${quote}." . "${quote}${seq}${quote}"
122 }
123  
124 my $res = $dbh->selectrow_hashref(qq{SELECT CURRENT VALUE FOR $seq AS SEQ FROM $full_table_name LIMIT 1});
125 unless ($res) {
126 return if $dbh->errstr;
127 return $dbh->set_err(1, qq{last_insert_id must be called after NEXT VALUE FOR is called});
128 }
129  
130 return $res->{SEQ};
131 }
132  
133 1;
134  
135 __END__
« Avatica.pm ↑ Summary Avatica/Adapter/Default.pm »