blib/lib/SQL/Composer/Update.pm

filter: Statementstmt 96.6% 58 / 60 Branchbran 81.8% 18 / 22 Conditioncond 33.3% 3 / 9 MC/DCmcdc 0.0% 0 / 6 Subroutinesub 100% 9 / 9 Podpod 0.0% 0 / 4 totaltotal 80.0% 88 / 110 CC 15 SCAR 22.5
CC
15
Cov
87%
new
14.8
to_bind
2.1
BEGIN
1.0
CRAP 9.5
« blib/lib/SQL/Composer/Select.pm ↑ Summary blib/lib/SQL/Composer/Insert.pm »
1 package SQL::Composer::Update;
2  
3 3 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 3 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
5  
6 3 require Carp;
7 3 ▶use SQL::Composer::Quoter;
Subroutine BEGIN: called CC=1 SCAR=0.0
8 3 ▶use SQL::Composer::Expression;
Subroutine BEGIN: called CC=1 SCAR=0.0
9  
10 sub new {
11 7 ▶ my $class = shift;
Subroutine new: called CC=14 SCAR=27.0
Pod undocumented
12 7 my (%params) = @_;
13  
14 7 my $self = { table => $params{table} };
15 7 bless $self, $class;
16  
17 $self->{quoter} =
18 7 ▶ $params{quoter} || SQL::Composer::Quoter->new(driver => $params{driver});
Condition33%1/3
$params{'quoter'} || 'SQL::Composer::Quoter'->new('driver', $params{'driver'})
l!l&&r!l&&!r
070
MC/DC0%0/2
$params{'quoter'} || 'SQL::Composer::Quoter'->new('driver', $params{'driver'})
$params{'quoter'} 'SQL::Composer::Quoter'->new('driver', $params{'driver'})
Truth table33%1/3
A || B
A= $params{'quoter'}B= 'SQL::Composer::Quoter'->new('driver', $params{'driver'})
ABresult
1X1
011
000
19  
20 7 my $sql = '';
21 7 my @bind;
22  
23 7 $sql .= 'UPDATE ';
24  
25 7 $sql .= $self->_quote($params{table});
26  
27 7 ▶ if ($params{values} || $params{set}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($params{"values"} or $params{"set"}) 7 0 7
Condition33%1/3
$params{"values"} or $params{"set"}
l!l&&r!l&&!r
700
MC/DC0%0/2
$params{"values"} or $params{"set"}
$params{"values"} $params{"set"}
Truth table33%1/3
A or B
A= $params{"values"}B= $params{"set"}
ABresult
1X1
011
000
28 7 ▶ my $values = $params{values} || $params{set};
Condition33%1/3
$params{'values'} || $params{'set'}
l!l&&r!l&&!r
700
MC/DC0%0/2
$params{'values'} || $params{'set'}
$params{'values'} $params{'set'}
Truth table33%1/3
A || B
A= $params{'values'}B= $params{'set'}
ABresult
1X1
011
000
29 7 ▶ my @values = ref $values eq 'HASH' ? %$values : @$values;
Branch: 1 branch
BranchTrueFalseTotal
ref $values eq 'HASH' ? : 1 6 7
30  
31 7 $sql .= ' SET ';
32  
33 7 my @pairs;
34 7 ▶ while (my ($key, $value) = splice @values, 0, 2) {
Branch: 1 branch
BranchTrueFalseTotal
if (() = splice(@values, 0, 2)) 7 7 14
35 7 ▶ if (ref $value) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $value) { } 2 5 7
36 2 ▶ if (ref $value eq 'SCALAR') {
Branch: 2 branches
BranchTrueFalseTotal
if (ref $value eq 'SCALAR') { } 1 1 2
elsif (ref $value eq 'REF') { } 1 0 1
37 1 $value = $$value;
38 }
39 elsif (ref $value eq 'REF') {
40 1 ▶ if (ref $$value eq 'ARRAY') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $$value eq 'ARRAY') { } 1 0 1
41 1 push @bind, @$$value[1 .. $#{$$value}];
42 1 $value = $$value->[0];
43 }
44 else {
45 0 Carp::croak('unexpected reference');
46 }
47 }
48 else {
49 0 Carp::croak('unexpected reference');
50 }
51 }
52 else {
53 5 push @bind, $value;
54 5 $value = '?';
55 }
56  
57 7 push @pairs, $self->_quote($key) . ' = ' . $value;
58 }
59  
60 7 $sql .= join ',', @pairs;
61 }
62  
63 7 ▶ if ($params{where}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($params{"where"}) 1 6 7
64 my $expr = SQL::Composer::Expression->new(
65 quoter => $self->{quoter},
66 expr => $params{where}
67 1 );
68 1 $sql .= ' WHERE ' . $expr->to_sql;
69 1 push @bind, $expr->to_bind;
70 }
71  
72 7 ▶ if (defined(my $limit = $params{limit})) {
Branch: 1 branch
BranchTrueFalseTotal
if (defined(my $limit = $params{"limit"})) 2 5 7
73 2 $sql .= ' LIMIT ' . $limit;
74 }
75  
76 7 ▶ if (defined(my $offset = $params{offset})) {
Branch: 1 branch
BranchTrueFalseTotal
if (defined(my $offset = $params{"offset"})) 1 6 7
77 1 $sql .= ' OFFSET ' . $offset;
78 }
79  
80 7 $self->{sql} = $sql;
81 7 $self->{bind} = \@bind;
82  
83 7 return $self;
84 }
85  
86 1 ▶sub table { shift->{table} }
Subroutine table: called CC=1 SCAR=0.0
Pod undocumented
87  
88 6 ▶sub to_sql { shift->{sql} }
Subroutine to_sql: called CC=1 SCAR=0.0
Pod undocumented
89 6 ▶sub to_bind { @{shift->{bind} || []} }
Subroutine to_bind: called CC=2 SCAR=7.2
Pod undocumented
Branch: 1 branch
BranchTrueFalseTotal
+(shift())->{"bind"} or [] 0 6 6
90  
91 sub _quote {
92 14 ▶ my $self = shift;
Subroutine _quote: called CC=1 SCAR=0.0
93 14 my ($column) = @_;
94  
95 14 return $self->{quoter}->quote($column);
96 }
97  
98 3 1;
99 __END__
« blib/lib/SQL/Composer/Select.pm ↑ Summary blib/lib/SQL/Composer/Insert.pm »