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