| 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__ | ||