Oracle/Storage/LOBSupport.pm

filter: Statementstmt 86.6% 91 / 105 Branchbran 80.0% 40 / 50 Conditioncond 48.8% 21 / 43 MC/DCmcdc 27.2% 6 / 22 Subroutinesub 90.9% 10 / 11 Podpod 50.0% 1 / 2 totaltotal 72.5% 169 / 233 CC 46 SCAR 29.7
CC
46
Cov
77%
_prep_for_execute
28.8
_dbi_attrs_for_bind
20.7
update
20.0
CRAP 19.6
« Oracle/Deploy.pm ↑ Summary Oracle/Introspect/Indexes.pm »
1 package DBIO::Oracle::Storage::LOBSupport;
2 # ABSTRACT: LOB binding and chunking for Oracle
3  
4 23 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 23 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 23 our $VERSION = '0.900007';
8  
9 23 ▶use Carp qw(carp);
Subroutine BEGIN: called CC=1 SCAR=0.0
10 23 ▶use DBIO::Oracle::Type ();
Subroutine BEGIN: called CC=1 SCAR=0.0
11  
12  
13  
14  
15 # the parts of a text value: [ offset (1-based, in characters), text ]
16 5 ▶sub _lob_text_parts {
Subroutine _lob_text_parts: called CC=1 SCAR=0.0
17 5 my ($data) = @_;
18 5 my $offset = 1;
19 5 return map { my $p = [ $offset, $_ ]; $offset += length $_; $p } unpack '(a1000)*', $data;
20 }
21  
22 # the parts of a binary value: [ offset (1-based, in bytes), bytes ]
23 5 ▶sub _lob_binary_parts {
Subroutine _lob_binary_parts: called CC=1 SCAR=0.0
24 5 my ($data) = @_;
25 5 my $offset = 1;
26 5 return map { my $p = [ $offset, $_ ]; $offset += length $_; $p } unpack '(a2000)*', $data;
27 }
28  
29 1 ▶sub _dbi_attrs_for_bind {
Subroutine _dbi_attrs_for_bind: called CC=5 SCAR=30.3
30 1 my ($self, $ident, $bind) = @_;
31  
32 1 my $attrs = $self->next::method($ident, $bind);
33  
34 $attrs->[$_]
35 0 and keys %{ $attrs->[$_] }
36 and $bind->[$_][0]{dbic_colname}
37 0 and $attrs->[$_] = { %{$attrs->[$_]}, ora_field => $bind->[$_][0]{dbic_colname} }
38 0 ▶ for 0 .. $#$attrs;
Branch: 1 branch
BranchTrueFalseTotal
$attrs->[$_] and keys %{$$attrs[$_];} and $bind->[$_][0]{"dbic_colname"} and $attrs->[$_] = {%{$attrs->[$_];}, "ora_field", $bind->[$_][0]{"dbic_colname"}} 0 0 0
Condition0%0/6
$attrs->[$_] and keys %{$$attrs[$_];} and $bind->[$_][0]{"dbic_colname"}
!ll&&!rl&&r
000
$attrs->[$_] and keys %{$$attrs[$_];}
!ll&&!rl&&r
000
MC/DC0%0/3
$attrs->[$_] and keys %{$$attrs[$_];} and $bind->[$_][0]{"dbic_colname"}
$attrs->[$_] keys %{$$attrs[$_];} $bind->[$_][0]{"dbic_colname"}
Truth table0%0/4
A and B and C
A= $attrs->[$_]B= keys %{$$attrs[$_];}C= $bind->[$_][0]{"dbic_colname"}
ABCresult
0XX0
10X0
1100
1111
39  
40 0 $attrs;
41 }
42  
43 8 ▶sub bind_attribute_by_data_type {
Subroutine bind_attribute_by_data_type: called CC=4 SCAR=13.9
Pod undocumented
44 8 my ($self, $dt) = @_;
45  
46 8 ▶ if ($self->_is_lob_type($dt)) {
Branch: 1 branch
BranchTrueFalseTotal
if ($self->_is_lob_type($dt)) 6 2 8
47 # ADR 0008: the driver is loaded here, where a LOB is really bound
48 6 require DBD::Oracle;
49 4 ▶ unless ($DBD::Oracle::__DBIO_DBD_VERSION_CHECK_OK__) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($DBD::Oracle::__DBIO_DBD_VERSION_CHECK_OK__) 2 2 4
50 2 ▶ if ($DBD::Oracle::VERSION eq '1.23') {
Branch: 1 branch
BranchTrueFalseTotal
if ($DBD::Oracle::VERSION eq "1.23") 1 1 2
51 1 $self->throw_exception(
52 "BLOB/CLOB support in DBD::Oracle == 1.23 is broken, use an earlier or later version "
53 . "(https://rt.cpan.org/Public/Bug/Display.html?id=46016)"
54 );
55 }
56 1 $DBD::Oracle::__DBIO_DBD_VERSION_CHECK_OK__ = 1;
57 }
58  
59 3 return DBIO::Oracle::Type::oracle_lob_bind_attrs($self->_is_text_lob_type($dt));
60 }
61 2 return undef;
62 }
63  
64 23 ▶sub _prep_for_execute {
Subroutine _prep_for_execute: called CC=27 SCAR=33.6
65 23 my $self = shift;
66 23 my ($op) = @_;
67  
68 23 ▶ if ($op eq 'insert') {
Branch: 1 branch
BranchTrueFalseTotal
if ($op eq "insert") 4 19 23
69 4 my ($sql, $bind) = $self->next::method(@_);
70 4 return $self->_wrap_lob_dml($sql, $bind);
71 }
72  
73 19 my ($sql, $bind) = $self->next::method(@_);
74  
75 my $lob_bind_indices = {
76 map {
77 19 (
78 $bind->[$_][0]{sqlt_datatype}
79 and
80 $self->_is_lob_type($bind->[$_][0]{sqlt_datatype})
81 30 ▶ ) ? ( $_ => 1 ) : ()
Branch: 1 branch
BranchTrueFalseTotal
$bind->[$_][0]{'sqlt_datatype'} && $self->_is_lob_type($bind->[$_][0]{'sqlt_datatype'}) ? : 13 17 30
Condition100%3/3
$bind->[$_][0]{"sqlt_datatype"} and $self->_is_lob_type($bind->[$_][0]{"sqlt_datatype"})
!ll&&!rl&&r
61113
MC/DC100%2/2
$bind->[$_][0]{"sqlt_datatype"} and $self->_is_lob_type($bind->[$_][0]{"sqlt_datatype"})
$bind->[$_][0]{"sqlt_datatype"} $self->_is_lob_type($bind->[$_][0]{"sqlt_datatype"})
Truth table100%3/3
A and B
A= $bind->[$_][0]{"sqlt_datatype"}B= $self->_is_lob_type($bind->[$_][0]{"sqlt_datatype"})
ABresult
0X0
100
111
82 } ( 0 .. $#$bind )
83 };
84  
85 19 ▶ return ($op eq 'update' ? $self->_wrap_lob_dml($sql, $bind, 'update') : ($sql, $bind))
Branch: 2 branches
BranchTrueFalseTotal
unless %$lob_bind_indices 7 12 19
$op eq 'update' ? : 1 6 7
86 unless %$lob_bind_indices;
87  
88 12 my ($final_sql, @final_binds);
89 12 ▶ if ($op eq 'update') {
Branch: 2 branches
BranchTrueFalseTotal
if ($op eq 'update') { } 3 9 12
elsif ($op ne 'select' and $op ne 'delete') { } 0 17 17
90 3 ▶ $self->throw_exception('Update with complex WHERE clauses involving BLOB columns currently not supported')
Branch: 1 branch
BranchTrueFalseTotal
if $sql =~ /\bWHERE\b .+ \bWHERE\b/sx 0 3 3
91 if $sql =~ /\bWHERE\b .+ \bWHERE\b/xs;
92  
93 3 my $where_sql;
94 3 ($final_sql, $where_sql) = $sql =~ /^ (.+?) ( \bWHERE\b .+) /xs;
95  
96 3 ▶ if (my $set_bind_count = $final_sql =~ y/?//) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $set_bind_count = $final_sql =~ tr/?//) 3 0 3
97 3 delete $lob_bind_indices->{$_} for (0 .. ($set_bind_count - 1));
98 3 ▶ return $self->_wrap_lob_dml($sql, $bind, 'update') unless %$lob_bind_indices;
Branch: 1 branch
BranchTrueFalseTotal
unless %$lob_bind_indices 2 1 3
99  
100 1 @final_binds = splice @$bind, 0, $set_bind_count;
101 $lob_bind_indices = {
102 1 map { $_ - $set_bind_count => $lob_bind_indices->{$_} }
103 keys %$lob_bind_indices
104 };
105 }
106 1 $sql = $where_sql;
107 }
108 ▶ elsif ($op ne 'select' and $op ne 'delete') {
Condition66%2/3
$op ne "select" and $op ne "delete"
!ll&&!rl&&r
810
MC/DC0%0/2
$op ne "select" and $op ne "delete"
$op ne "select" $op ne "delete"
Truth table66%2/3
A and B
A= $op ne "select"B= $op ne "delete"
ABresult
0X0
100
111
109 0 $self->throw_exception("Unsupported \$op: $op");
110 }
111  
112 10 my @sql_parts = split /\?/, $sql;
113 10 my $col_equality_re = qr/ (?<=\s) ([\w."]+) (\s*=\s*) $/x;
114  
115 10 for my $b_idx (0 .. $#$bind) {
116 13 my $bound = $bind->[$b_idx];
117  
118 13 ▶ if ($lob_bind_indices->{$b_idx} and my ($col, $eq) = $sql_parts[0] =~ $col_equality_re) {
Branch: 1 branch
BranchTrueFalseTotal
if ($lob_bind_indices->{$b_idx} and () = $sql_parts[0] =~ /$col_equality_re/) { } 10 3 13
Condition66%2/3
$lob_bind_indices->{$b_idx} and () = $sql_parts[0] =~ /$col_equality_re/
!ll&&!rl&&r
3010
MC/DC50%1/2
$lob_bind_indices->{$b_idx} and () = $sql_parts[0] =~ /$col_equality_re/
$lob_bind_indices->{$b_idx} () = $sql_parts[0] =~ /$col_equality_re/
Truth table66%2/3
A and B
A= $lob_bind_indices->{$b_idx}B= () = $sql_parts[0] =~ /$col_equality_re/
ABresult
0X0
100
111
119 10 my $data = $bound->[1];
120 10 ▶ $data = "$data" if ref $data;
Branch: 1 branch
BranchTrueFalseTotal
if ref $data 0 10 10
121  
122 # What the LOB holds is compared in parts a SQL string can carry, with a
123 # condition written for each part (see "Comparing a LOB by value").
124 10 ▶ my $binary = ($bound->[0]{sqlt_datatype} // '') =~ /blob|bytea|image|raw|bfile/i;
Condition50%1/2
$bound->[0]{"sqlt_datatype"} // ""
l!l
100
MC/DC0%0/1
$bound->[0]{"sqlt_datatype"} // ""
$bound->[0]{"sqlt_datatype"}
Truth table50%1/2
A
A= $bound->[0]{"sqlt_datatype"}
Aresult
11
00
125 10 ▶ my @parts = $binary ? _lob_binary_parts($data) : _lob_text_parts($data);
Branch: 1 branch
BranchTrueFalseTotal
$binary ? : 5 5 10
126 10 my @sql_frag;
127  
128 10 ▶ if (!@parts) {
Branch: 1 branch
BranchTrueFalseTotal
if (not @parts) { } 2 8 10
129 # the empty string: an empty LOB, which has no part to compare
130 2 push @sql_frag, sprintf 'DBMS_LOB.GETLENGTH(%s) = 0', $col;
131 }
132 else {
133 8 for my $idx (0..$#parts) {
134 17 ▶ push @sql_frag, $binary
Branch: 1 branch
BranchTrueFalseTotal
$binary ? : 6 11 17
135 ? sprintf('DBMS_LOB.SUBSTR(%s, 2000, %d) = HEXTORAW(?)',
136 $col, $parts[$idx][0])
137 : sprintf('DBMS_LOB.SUBSTR(%s, 1000, %d) = ?',
138 $col, $parts[$idx][0]);
139 }
140 }
141  
142 10 my $sql_frag = '( ' . (join ' AND ', @sql_frag) . ' )';
143 10 $sql_parts[0] =~ s/$col_equality_re/$sql_frag/;
144  
145 10 $final_sql .= shift @sql_parts;
146  
147 10 for my $idx (0..$#parts) {
148 push @final_binds, [
149 17 ▶ { %{ $bound->[0] }, _ora_lob_autosplit_part => $idx, dbd_attrs => undef },
Branch: 1 branch
BranchTrueFalseTotal
$binary ? : 6 11 17
150 $binary ? uc unpack('H*', $parts[$idx][1]) : $parts[$idx][1],
151 ];
152 }
153 }
154 else {
155 3 $final_sql .= shift(@sql_parts) . '?';
156 push @final_binds, $lob_bind_indices->{$b_idx}
157 0 ▶ ? [{ %{ $bound->[0] }, dbd_attrs => undef }, $bound->[1]]
Branch: 1 branch
BranchTrueFalseTotal
$lob_bind_indices->{$b_idx} ? : 0 3 3
158 : $bound;
159 }
160 }
161  
162 10 ▶ if (@sql_parts > 1) {
Branch: 1 branch
BranchTrueFalseTotal
if (@sql_parts > 1) 0 10 10
163 0 carp "There are more placeholders than binds, this should not happen!";
164 0 @sql_parts = join('?', @sql_parts);
165 }
166  
167 10 $final_sql .= $sql_parts[0];
168 10 ▶ return $op eq 'update'
Branch: 1 branch
BranchTrueFalseTotal
$op eq 'update' ? : 1 9 10
169 ? $self->_wrap_lob_dml($final_sql, \@final_binds, 'update')
170 : ($final_sql, \@final_binds);
171 }
172  
173 # see "INSERT and UPDATE with LOB values" above
174 8 ▶sub _wrap_lob_dml {
Subroutine _wrap_lob_dml: called CC=10 SCAR=24.4
175 8 my ($self, $sql, $bind, $op) = @_;
176  
177 return ($sql, $bind) unless grep {
178 8 ▶ my $b = $_->[0];
Branch: 1 branch
BranchTrueFalseTotal
unless grep {my $b = $_->[0]; ref $b eq "HASH" and $b->{"dbd_attrs"} && ref $b->{"dbd_attrs"} eq "HASH" && exists $b->{"dbd_attrs"}{"ora_type"} || !exists $b->{"dbd_attrs"} && $b->{"sqlt_datatype"} && $self->_is_lob_type($b->{"sqlt_datatype"});} @$bind 3 5 8
179 ref $b eq 'HASH'
180 and (
181 ( $b->{dbd_attrs} and ref $b->{dbd_attrs} eq 'HASH' and exists $b->{dbd_attrs}{ora_type} )
182 or
183 14 ▶ ( !exists $b->{dbd_attrs} and $b->{sqlt_datatype} and $self->_is_lob_type($b->{sqlt_datatype}) )
Condition61%11/18
ref $b eq 'HASH' && ($b->{'dbd_attrs'} && ref $b->{'dbd_attrs'} eq 'HASH' && exists $b->{'dbd_attrs'}{'ora_type'} || !exists $b->{'dbd_attrs'} && $b->{'sqlt_datatype'} && $self->_is_lob_type($b->{'sqlt_datatype'}))
!ll&&!rl&&r
095
$b->{"dbd_attrs"} and ref $b->{"dbd_attrs"} eq "HASH" and exists $b->{"dbd_attrs"}{"ora_type"} or not exists $b->{"dbd_attrs"} and $b->{"sqlt_datatype"} and $self->_is_lob_type($b->{"sqlt_datatype"})
l!l&&r!l&&!r
059
$b->{"dbd_attrs"} and ref $b->{"dbd_attrs"} eq "HASH" and exists $b->{"dbd_attrs"}{"ora_type"}
!ll&&!rl&&r
1400
$b->{"dbd_attrs"} and ref $b->{"dbd_attrs"} eq "HASH"
!ll&&!rl&&r
1400
not exists $b->{"dbd_attrs"} and $b->{"sqlt_datatype"} and $self->_is_lob_type($b->{"sqlt_datatype"})
!ll&&!rl&&r
185
not exists $b->{"dbd_attrs"} and $b->{"sqlt_datatype"}
!ll&&!rl&&r
1013
MC/DC28%2/7
ref $b eq 'HASH' && ($b->{'dbd_attrs'} && ref $b->{'dbd_attrs'} eq 'HASH' && exists $b->{'dbd_attrs'}{'ora_type'} || !exists $b->{'dbd_attrs'} && $b->{'sqlt_datatype'} && $self->_is_lob_type($b->{'sqlt_datatype'}))
ref $b eq 'HASH' $b->{"dbd_attrs"} ref $b->{"dbd_attrs"} eq "HASH" exists $b->{"dbd_attrs"}{"ora_type"} not exists $b->{"dbd_attrs"} $b->{"sqlt_datatype"} $self->_is_lob_type($b->{"sqlt_datatype"})
Truth table21%3/14
A && B and C and D or not(E) and F and G
A= ref $b eq 'HASH'B= $b->{"dbd_attrs"}C= ref $b->{"dbd_attrs"} eq "HASH"D= exists $b->{"dbd_attrs"}{"ora_type"}E= not exists $b->{"dbd_attrs"}F= $b->{"sqlt_datatype"}G= $self->_is_lob_type($b->{"sqlt_datatype"})
ABCDEFGresult
0XXXXXX0
10XX0XX0
10XX10X0
10XX1100
110X0XX0
110X10X0
110X1100
11100XX0
111010X0
11101100
1111XXX1
10XX1111
110X1111
11101111
184 )
185 } @$bind;
186  
187 5 ▶ return ("BEGIN $sql; END;", $bind) unless $op and $op eq 'update';
Branch: 1 branch
BranchTrueFalseTotal
unless $op and $op eq "update" 2 3 5
Condition66%2/3
$op and $op eq "update"
!ll&&!rl&&r
203
MC/DC50%1/2
$op and $op eq "update"
$op $op eq "update"
Truth table66%2/3
A and B
A= $opB= $op eq "update"
ABresult
0X0
100
111
188  
189 # DBD::Oracle reports the row count of the block (always 1), not of the
190 # UPDATE inside it. The block hands the real one back in an out bind.
191 3 my $rc;
192 3 $self->{_ora_lob_update_rowcount} = \$rc;
193 return (
194 3 "BEGIN $sql; ? := SQL%ROWCOUNT; END;",
195 [ @$bind, [ { dbd_attrs => undef, dbd_size => 40 }, \$rc ] ],
196 );
197 }
198  
199  
200 0 ▶sub update {
Subroutine update: not called CC=4 SCAR=30.0
Pod documented
201 0 my $self = shift;
202  
203 0 local $self->{_ora_lob_update_rowcount};
204 0 my $rv = $self->next::method(@_);
205  
206 0 my $rc = $self->{_ora_lob_update_rowcount};
207 0 ▶ return $rv unless $rc and defined $$rc;
Branch: 1 branch
BranchTrueFalseTotal
unless $rc and defined $$rc 0 0 0
Condition0%0/3
$rc and defined $$rc
!ll&&!rl&&r
000
MC/DC0%0/2
$rc and defined $$rc
$rc defined $$rc
Truth table0%0/3
A and B
A= $rcB= defined $$rc
ABresult
0X0
100
111
208 0 ▶ return $$rc || '0E0';
Condition0%0/2
$$rc || '0E0'
l!l
00
MC/DC0%0/1
$$rc || '0E0'
$$rc
Truth table0%0/2
A
A= $$rc
Aresult
11
00
209 }
210  
211 23 1;
212  
213 __END__
« Oracle/Deploy.pm ↑ Summary Oracle/Introspect/Indexes.pm »