blib/lib/DBIO/Storage/DBI/DataTypeClassifier.pm

filter: Statementstmt 45.9% 17 / 37 Branchbran 0.0% 0 / 20 Conditioncond 0.0% 0 / 33 MC/DCmcdc 0.0% 0 / 17 Subroutinesub 45.4% 5 / 11 Podpod n/a totaltotal 18.6% 22 / 118 CC 18 SCAR 38.0
CC
18
Cov
19%
_max_column_bytesize
110.0
_is_lob_type
12.0
_is_binary_lob_type
12.0
CRAP 44.7
« blib/lib/DBIO/EncodedColumn.pm ↑ Summary blib/lib/DBIO/Storage/QueryRewrite.pm »
1 package DBIO::Storage::DBI::DataTypeClassifier;
2 # ABSTRACT: Native data type and LOB classification helpers for DBI storage
3  
4 344 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 344 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 344 our $VERSION = '0.900007';
8  
9 344 ▶use base 'DBIO::Storage';
Subroutine BEGIN: called CC=1 SCAR=0.0
10 344 ▶use mro 'c3';
Subroutine BEGIN: called CC=1 SCAR=0.0
11 344 ▶use namespace::clean;
Subroutine BEGIN: called CC=1 SCAR=0.0
12  
13  
14  
15 0 ▶sub _native_data_type {
Subroutine _native_data_type: not called CC=1 SCAR=6.9
16 #my ($self, $data_type) = @_;
17 return undef
18 0 }
19  
20 # The size in bytes to use for DBI's ->bind_param_inout, this is the generic
21 # version and it may be necessary to amend or override it for a specific storage
22 # if such binds are necessary.
23 0 ▶sub _max_column_bytesize {
Subroutine _max_column_bytesize: not called CC=10 SCAR=47.0
24 0 my ($self, $attr) = @_;
25  
26 0 my $max_size;
27  
28 0 ▶ if ($attr->{sqlt_datatype}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($attr->{"sqlt_datatype"}) 0 0 0
29 0 my $data_type = lc($attr->{sqlt_datatype});
30  
31 0 ▶ if ($attr->{sqlt_size}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($attr->{"sqlt_size"}) 0 0 0
32  
33 # String/sized-binary types
34 0 ▶ if ($data_type =~ /^(?:
Branch: 2 branches
BranchTrueFalseTotal
if ($data_type =~ /^(?: l? (?:var)? char(?:acter)? (?:\s*varying)? | (?:var)? binary (?:\s*varying)? | raw )\b/x) { } 0 0 0
elsif ($data_type =~ /^(?: national \s* character (?:\s*varying)? | nchar | univarchar | nvarchar )\b/x) { } 0 0 0
35 l? (?:var)? char(?:acter)? (?:\s*varying)?
36 |
37 (?:var)? binary (?:\s*varying)?
38 |
39 raw
40 )\b/x
41 ) {
42 0 $max_size = $attr->{sqlt_size};
43 }
44 # Other charset/unicode types, assume scale of 4
45 elsif ($data_type =~ /^(?:
46 national \s* character (?:\s*varying)?
47 |
48 nchar
49 |
50 univarchar
51 |
52 nvarchar
53 )\b/x
54 ) {
55 0 $max_size = $attr->{sqlt_size} * 4;
56 }
57 }
58  
59 0 ▶ if (!$max_size and !$self->_is_lob_type($data_type)) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($max_size or $self->_is_lob_type($data_type)) 0 0 0
Condition0%0/3
$max_size or $self->_is_lob_type($data_type)
l!l&&r!l&&!r
000
MC/DC0%0/2
$max_size or $self->_is_lob_type($data_type)
$max_size $self->_is_lob_type($data_type)
Truth table0%0/3
A or B
A= $max_sizeB= $self->_is_lob_type($data_type)
ABresult
1X1
011
000
60 0 $max_size = 100 # for all other (numeric?) datatypes
61 }
62 }
63  
64 0 ▶ $max_size || $self->_dbio_connect_attributes->{LongReadLen} || $self->_get_dbh->{LongReadLen} || 8000;
Branch: 1 branch
BranchTrueFalseTotal
$max_size or $self->_dbio_connect_attributes->{"LongReadLen"} or $self->_get_dbh->{"LongReadLen"} or 8000 0 0 0
Condition0%0/6
$max_size or $self->_dbio_connect_attributes->{"LongReadLen"} or $self->_get_dbh->{"LongReadLen"}
l!l&&r!l&&!r
000
$max_size or $self->_dbio_connect_attributes->{"LongReadLen"}
l!l&&r!l&&!r
000
MC/DC0%0/3
$max_size or $self->_dbio_connect_attributes->{"LongReadLen"} or $self->_get_dbh->{"LongReadLen"}
$max_size $self->_dbio_connect_attributes->{"LongReadLen"} $self->_get_dbh->{"LongReadLen"}
Truth table0%0/4
A or B or C
A= $max_sizeB= $self->_dbio_connect_attributes->{"LongReadLen"}C= $self->_get_dbh->{"LongReadLen"}
ABCresult
1XX1
01X1
0011
0000
65 }
66  
67 # Determine if a data_type is some type of BLOB
68 0 ▶sub _is_lob_type {
Subroutine _is_lob_type: not called CC=3 SCAR=24.8
69 0 my ($self, $data_type) = @_;
70 0 ▶ $data_type && ($data_type =~ /lob|bfile|text|image|bytea|memo/i
Branch: 1 branch
BranchTrueFalseTotal
$data_type and $data_type =~ /lob|bfile|text|image|bytea|memo/i || $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary |varchar|character\s*varying|nvarchar |national\s*character\s*varying))?\z/xi 0 0 0
Condition0%0/6
$data_type && ($data_type =~ /lob|bfile|text|image|bytea|memo/i || $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary |varchar|character\s*varying|nvarchar |national\s*character\s*varying))?\z/xi)
!ll&&!rl&&r
000
$data_type =~ /lob|bfile|text|image|bytea|memo/i or $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary |varchar|character\s*varying|nvarchar |national\s*character\s*varying))?\z/xi
l!l&&r!l&&!r
000
MC/DC0%0/3
$data_type && ($data_type =~ /lob|bfile|text|image|bytea|memo/i || $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary |varchar|character\s*varying|nvarchar |national\s*character\s*varying))?\z/xi)
$data_type $data_type =~ /lob|bfile|text|image|bytea|memo/i $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary |varchar|character\s*varying|nvarchar |national\s*character\s*varying))?\z/xi
Truth table0%0/4
A && B or C
A= $data_typeB= $data_type =~ /lob|bfile|text|image|bytea|memo/iC= $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary |varchar|character\s*varying|nvarchar |national\s*character\s*varying))?\z/xi
ABCresult
0XX0
1000
11X1
1011
71 || $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary
72 |varchar|character\s*varying|nvarchar
73 |national\s*character\s*varying))?\z/xi);
74 }
75  
76 0 ▶sub _is_binary_lob_type {
Subroutine _is_binary_lob_type: not called CC=3 SCAR=24.8
77 0 my ($self, $data_type) = @_;
78 0 ▶ $data_type && ($data_type =~ /blob|bfile|image|bytea/i
Branch: 1 branch
BranchTrueFalseTotal
$data_type and $data_type =~ /blob|bfile|image|bytea/i || $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary))?\z/xi 0 0 0
Condition0%0/6
$data_type && ($data_type =~ /blob|bfile|image|bytea/i || $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary))?\z/xi)
!ll&&!rl&&r
000
$data_type =~ /blob|bfile|image|bytea/i or $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary))?\z/xi
l!l&&r!l&&!r
000
MC/DC0%0/3
$data_type && ($data_type =~ /blob|bfile|image|bytea/i || $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary))?\z/xi)
$data_type $data_type =~ /blob|bfile|image|bytea/i $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary))?\z/xi
Truth table0%0/4
A && B or C
A= $data_typeB= $data_type =~ /blob|bfile|image|bytea/iC= $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary))?\z/xi
ABCresult
0XX0
1000
11X1
1011
79 || $data_type =~ /^long(?:\s+(?:raw|bit\s*varying|varbit|binary))?\z/xi);
80 }
81  
82 0 ▶sub _is_text_lob_type {
Subroutine _is_text_lob_type: not called CC=3 SCAR=24.8
83 0 my ($self, $data_type) = @_;
84 0 ▶ $data_type && ($data_type =~ /^(?:clob|memo)\z/i
Branch: 1 branch
BranchTrueFalseTotal
$data_type and $data_type =~ /^(?:clob|memo)\z/i || $data_type =~ /^long(?:\s+(?:varchar|character\s*varying|nvarchar |national\s*character\s*varying))\z/xi 0 0 0
Condition0%0/6
$data_type && ($data_type =~ /^(?:clob|memo)\z/i || $data_type =~ /^long(?:\s+(?:varchar|character\s*varying|nvarchar |national\s*character\s*varying))\z/xi)
!ll&&!rl&&r
000
$data_type =~ /^(?:clob|memo)\z/i or $data_type =~ /^long(?:\s+(?:varchar|character\s*varying|nvarchar |national\s*character\s*varying))\z/xi
l!l&&r!l&&!r
000
MC/DC0%0/3
$data_type && ($data_type =~ /^(?:clob|memo)\z/i || $data_type =~ /^long(?:\s+(?:varchar|character\s*varying|nvarchar |national\s*character\s*varying))\z/xi)
$data_type $data_type =~ /^(?:clob|memo)\z/i $data_type =~ /^long(?:\s+(?:varchar|character\s*varying|nvarchar |national\s*character\s*varying))\z/xi
Truth table0%0/4
A && B or C
A= $data_typeB= $data_type =~ /^(?:clob|memo)\z/iC= $data_type =~ /^long(?:\s+(?:varchar|character\s*varying|nvarchar |national\s*character\s*varying))\z/xi
ABCresult
0XX0
1000
11X1
1011
85 || $data_type =~ /^long(?:\s+(?:varchar|character\s*varying|nvarchar
86 |national\s*character\s*varying))\z/xi);
87 }
88  
89 # Determine if a data_type is some type of a binary type
90 0 ▶sub _is_binary_type {
Subroutine _is_binary_type: not called CC=3 SCAR=24.8
91 0 my ($self, $data_type) = @_;
92 0 ▶ $data_type && ($self->_is_binary_lob_type($data_type)
Branch: 1 branch
BranchTrueFalseTotal
$data_type and $self->_is_binary_lob_type($data_type) || $data_type =~ /(?:var)?(?:binary|bit|graphic)(?:\s*varying)?/i 0 0 0
Condition0%0/6
$data_type && ($self->_is_binary_lob_type($data_type) || $data_type =~ /(?:var)?(?:binary|bit|graphic)(?:\s*varying)?/i)
!ll&&!rl&&r
000
$self->_is_binary_lob_type($data_type) or $data_type =~ /(?:var)?(?:binary|bit|graphic)(?:\s*varying)?/i
l!l&&r!l&&!r
000
MC/DC0%0/3
$data_type && ($self->_is_binary_lob_type($data_type) || $data_type =~ /(?:var)?(?:binary|bit|graphic)(?:\s*varying)?/i)
$data_type $self->_is_binary_lob_type($data_type) $data_type =~ /(?:var)?(?:binary|bit|graphic)(?:\s*varying)?/i
Truth table0%0/4
A && B or C
A= $data_typeB= $self->_is_binary_lob_type($data_type)C= $data_type =~ /(?:var)?(?:binary|bit|graphic)(?:\s*varying)?/i
ABCresult
0XX0
1000
11X1
1011
93 || $data_type =~ /(?:var)?(?:binary|bit|graphic)(?:\s*varying)?/i);
94 }
95  
96 344 1;
97  
98 __END__
« blib/lib/DBIO/EncodedColumn.pm ↑ Summary blib/lib/DBIO/Storage/QueryRewrite.pm »