blib/lib/SQL/Composer/Expression.pm

filter: Statementstmt 97.6% 82 / 84 Branchbran 90.6% 29 / 32 Conditioncond 81.8% 9 / 11 MC/DCmcdc 57.1% 4 / 7 Subroutinesub 100% 10 / 10 Podpod 0.0% 0 / 3 totaltotal 91.1% 134 / 147 CC 21 SCAR 17.9
CC
21
Cov
94%
_build_subexpr
10.0
_build_value
7.1
new
4.0
CRAP 6.0
« blib/lib/SQL/Composer/Insert.pm ↑ Summary blib/lib/SQL/Composer/Join.pm »
1 package SQL::Composer::Expression;
2  
3 7 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 7 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
5  
6 7 require Carp;
7 7 ▶use Storable ();
Subroutine BEGIN: called CC=1 SCAR=0.0
8 7 ▶use SQL::Composer::Quoter;
Subroutine BEGIN: called CC=1 SCAR=0.0
9  
10 sub new {
11 37 ▶ my $class = shift;
Subroutine new: called CC=4 SCAR=13.9
Pod undocumented
12 37 my (%params) = @_;
13  
14 37 ▶ my $expr = $params{expr} || [];
Condition50%1/2
$params{'expr'} || []
l!l
370
MC/DC0%0/1
$params{'expr'} || []
$params{'expr'}
Truth table50%1/2
A
A= $params{'expr'}
Aresult
11
00
15 37 ▶ $expr = [$expr] unless ref $expr eq 'ARRAY';
Branch: 1 branch
BranchTrueFalseTotal
unless ref $expr eq "ARRAY" 3 34 37
16  
17 37 my $self = {};
18 37 bless $self, $class;
19  
20 37 $self->{default_prefix} = $params{default_prefix};
21  
22 $self->{quoter} =
23 37 ▶ $params{quoter} || SQL::Composer::Quoter->new(driver => $params{driver});
Condition66%2/3
$params{'quoter'} || 'SQL::Composer::Quoter'->new('driver', $params{'driver'})
l!l&&r!l&&!r
18190
MC/DC0%0/2
$params{'quoter'} || 'SQL::Composer::Quoter'->new('driver', $params{'driver'})
$params{'quoter'} 'SQL::Composer::Quoter'->new('driver', $params{'driver'})
Truth table66%2/3
A || B
A= $params{'quoter'}B= 'SQL::Composer::Quoter'->new('driver', $params{'driver'})
ABresult
1X1
011
000
24  
25 37 my ($sql, $bind) = $self->_build_subexpr('-and', $expr);
26  
27 37 $self->{sql} = $sql;
28 37 $self->{bind} = $bind;
29  
30 37 return $self;
31 }
32  
33 sub _build_subexpr {
34 40 ▶ my $self = shift;
Subroutine _build_subexpr: called CC=10 SCAR=23.0
35 40 my ($op, $params) = @_;
36  
37 40 $params = Storable::dclone($params);
38  
39 40 $op = uc $op;
40 40 $op =~ s{-}{};
41  
42 40 my @parts;
43 my @bind;
44 40 ▶ while (my ($key, $value) = splice(@$params, 0, 2)) {
Branch: 1 branch
BranchTrueFalseTotal
if (() = splice(@$params, 0, 2)) 44 40 84
45 44 my $quote = 1;
46 44 ▶ if (ref $key) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $key) 5 39 44
47 5 $quote = 0;
48  
49 5 my ($_key, $_bind) = $self->_build_value($key);
50  
51 5 $key = $_key;
52 5 push @bind, @$_bind;
53 }
54  
55 44 ▶ if ($key eq '-or' || $key eq '-and') {
Branch: 3 branches
BranchTrueFalseTotal
if ($key eq '-or' or $key eq '-and') { } 3 41 44
elsif (ref $value eq 'HASH') { } 7 34 41
elsif (defined $value) { } 31 3 34
Condition100%3/3
$key eq "-or" or $key eq "-and"
l!l&&r!l&&!r
2141
MC/DC100%2/2
$key eq "-or" or $key eq "-and"
$key eq "-or" $key eq "-and"
Truth table100%3/3
A or B
A= $key eq "-or"B= $key eq "-and"
ABresult
1X1
011
000
56 3 my ($sql, $bind) = $self->_build_subexpr($key, $value);
57 3 push @parts, '(' . $sql . ')';
58 3 push @bind, @$bind;
59 }
60 elsif (ref $value eq 'HASH') {
61 7 my ($op) = keys %$value;
62 7 my ($subvalue) = values %$value;
63  
64 7 ▶ if ($op eq '-col') {
Branch: 1 branch
BranchTrueFalseTotal
if ($op eq '-col') { } 2 5 7
65 2 push @parts,
66 $self->_quote($quote, $key) . ' = ' . $self->_quote(1, $subvalue);
67 }
68 else {
69 5 my ($_value, $_bind) = $self->_build_value($subvalue);
70  
71 5 push @parts, $self->_quote($quote, $key) . " $op $_value";
72 5 push @bind, @$_bind;
73 }
74 }
75 elsif (defined $value) {
76 31 my ($_value, $_bind) = $self->_build_value($value);
77  
78 31 ▶ my $op = ref($value) && ref($value) eq 'ARRAY' ? '' : '= ';
Branch: 1 branch
BranchTrueFalseTotal
ref $value && ref $value eq 'ARRAY' ? : 1 30 31
Condition100%3/3
ref $value and ref $value eq "ARRAY"
!ll&&!rl&&r
2911
MC/DC100%2/2
ref $value and ref $value eq "ARRAY"
ref $value ref $value eq "ARRAY"
Truth table100%3/3
A and B
A= ref $valueB= ref $value eq "ARRAY"
ABresult
0X0
100
111
79 31 push @parts, $self->_quote($quote, $key) . " $op$_value";
80 31 push @bind, @$_bind;
81 }
82 else {
83 3 push @parts, $key;
84 }
85 }
86  
87 40 my $sql = join " $op ", @parts;
88  
89 40 return ($sql, \@bind);
90 }
91  
92 sub _build_value {
93 41 ▶ my $self = shift;
Subroutine _build_value: called CC=7 SCAR=19.6
94 41 my ($value) = @_;
95  
96 41 my $sql;
97 my @bind;
98 41 ▶ if (ref $value eq 'SCALAR') {
Branch: 4 branches
BranchTrueFalseTotal
if (ref $value eq 'SCALAR') { } 5 36 41
elsif (ref $value eq 'ARRAY') { } 2 34 36
elsif (ref $value eq 'REF') { } 3 31 34
elsif (ref $value eq 'HASH') { } 1 30 31
99 5 $sql = $$value;
100 }
101 elsif (ref $value eq 'ARRAY') {
102 2 $sql = 'IN (' . (join ',', split('', '?' x @$value)) . ')';
103 2 push @bind, @$value;
104 }
105 elsif (ref $value eq 'REF') {
106 3 ▶ if (ref $$value eq 'ARRAY') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $$value eq 'ARRAY') { } 3 0 3
107 3 $sql = $$value->[0];
108 3 push @bind, @$$value[1 .. $#{$$value}];
109 }
110 else {
111 0 Carp::croak('unexpected reference');
112 }
113 }
114 elsif (ref($value) eq 'HASH') {
115 1 my ($key) = keys %$value;
116 1 my ($subvalue) = values %$value;
117  
118 1 ▶ if ($key eq '-col') {
Branch: 1 branch
BranchTrueFalseTotal
if ($key eq '-col') { } 1 0 1
119 1 $sql = $self->_quote(1, $subvalue);
120 }
121 else {
122 0 Carp::croak('unexpected reference');
123 }
124 }
125 else {
126 30 $sql = '?';
127 30 @bind = ($value);
128 }
129  
130 41 ($sql, \@bind);
131 }
132  
133 37 ▶sub to_sql { shift->{sql} }
Subroutine to_sql: called CC=1 SCAR=0.0
Pod undocumented
134 36 ▶sub to_bind { @{shift->{bind} || []} }
Subroutine to_bind: called CC=2 SCAR=7.2
Pod undocumented
Branch: 1 branch
BranchTrueFalseTotal
+(shift())->{"bind"} or [] 0 36 36
135  
136 sub _quote {
137 41 ▶ my $self = shift;
Subroutine _quote: called CC=2 SCAR=6.9
138 41 my ($yes, $column) = @_;
139  
140 41 ▶ return $column unless $yes;
Branch: 1 branch
BranchTrueFalseTotal
unless $yes 3 38 41
141  
142 38 return $self->{quoter}->quote($column, $self->{default_prefix});
143 }
144  
145 7 1;
146 __END__
« blib/lib/SQL/Composer/Insert.pm ↑ Summary blib/lib/SQL/Composer/Join.pm »