blib/lib/SQL/Composer/Join.pm

filter: Statementstmt 100% 40 / 40 Branchbran 80.0% 8 / 10 Conditioncond 66.6% 6 / 9 MC/DCmcdc 0.0% 0 / 6 Subroutinesub 100% 8 / 8 Podpod 0.0% 0 / 3 totaltotal 81.5% 62 / 76 CC 9 SCAR 15.4
CC
9
Cov
92%
new
8.1
to_bind
2.1
BEGIN
1.0
CRAP 4.7
« blib/lib/SQL/Composer/Expression.pm ↑ Summary blib/lib/SQL/Composer/Quoter.pm »
1 package SQL::Composer::Join;
2  
3 4 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 4 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
5  
6 4 require Carp;
7 4 ▶use SQL::Composer::Quoter;
Subroutine BEGIN: called CC=1 SCAR=0.0
8 4 ▶use SQL::Composer::Expression;
Subroutine BEGIN: called CC=1 SCAR=0.0
9  
10 sub new {
11 15 ▶ my $class = shift;
Subroutine new: called CC=8 SCAR=20.9
Pod undocumented
12 15 my (%params) = @_;
13  
14 15 my $self = {};
15 15 bless $self, $class;
16  
17 $self->{quoter} = $params{quoter}
18 || SQL::Composer::Quoter->new(
19 driver => $params{driver},
20 default_prefix => $params{as} || $params{source}
21 15 ▶ );
Condition66%4/6
$params{'quoter'} || 'SQL::Composer::Quoter'->new('driver', $params{'driver'}, 'default_prefix', $params{'as'} || $params{'source'})
l!l&&r!l&&!r
1140
$params{'as'} || $params{'source'}
l!l&&r!l&&!r
130
MC/DC0%0/2
$params{'quoter'} || 'SQL::Composer::Quoter'->new('driver', $params{'driver'}, 'default_prefix', $params{'as'} || $params{'source'})
$params{'quoter'} 'SQL::Composer::Quoter'->new('driver', $params{'driver'}, 'default_prefix', $params{'as'} || $params{'source'})
MC/DC0%0/2
$params{'as'} || $params{'source'}
$params{'as'} $params{'source'}
Truth table66%2/3
A || B
A= $params{'quoter'}B= 'SQL::Composer::Quoter'->new('driver', $params{'driver'}, 'default_prefix', $params{'as'} || $params{'source'})
ABresult
1X1
011
000
Truth table66%2/3
A || B
A= $params{'as'}B= $params{'source'}
ABresult
1X1
011
000
22  
23 15 my $sql = '';
24 15 my @bind;
25  
26 15 ▶ $sql .= uc($params{op}) . ' ' if $params{op};
Branch: 1 branch
BranchTrueFalseTotal
if $params{"op"} 2 13 15
27 15 $sql .= 'JOIN ';
28  
29 15 $sql .= $self->_quote($params{source}) . ' ';
30  
31 15 ▶ if (my $as = $params{as}) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $as = $params{"as"}) 7 8 15
32 7 $sql .= 'AS ' . $self->_quote($as) . ' ';
33 }
34  
35 15 ▶ if (my $constraint = $params{on}) {
Branch: 2 branches
BranchTrueFalseTotal
if (my $constraint = $params{'on'}) { } 14 1 15
elsif (my $column = $params{'using'}) { } 1 0 1
36 my $expr = SQL::Composer::Expression->new(
37 default_prefix => $params{as} || $params{source},
38 quoter => $self->{quoter},
39 14 ▶ expr => $constraint
Condition66%2/3
$params{'as'} || $params{'source'}
l!l&&r!l&&!r
770
MC/DC0%0/2
$params{'as'} || $params{'source'}
$params{'as'} $params{'source'}
Truth table66%2/3
A || B
A= $params{'as'}B= $params{'source'}
ABresult
1X1
011
000
40 );
41 14 $sql .= 'ON ' . $expr->to_sql;
42 14 push @bind, $expr->to_bind;
43 }
44 elsif (my $column = $params{using}) {
45 1 $sql .= 'USING ' . $self->_quote($column);
46 }
47  
48 15 $self->{sql} = $sql;
49 15 $self->{bind} = \@bind;
50  
51 15 return $self;
52 }
53  
54 15 ▶sub to_sql { shift->{sql} }
Subroutine to_sql: called CC=1 SCAR=0.0
Pod undocumented
55 15 ▶sub to_bind { @{shift->{bind} || []} }
Subroutine to_bind: called CC=2 SCAR=7.2
Pod undocumented
Branch: 1 branch
BranchTrueFalseTotal
+(shift())->{"bind"} or [] 0 15 15
56  
57 sub _quote {
58 23 ▶ my $self = shift;
Subroutine _quote: called CC=1 SCAR=0.0
59 23 my ($column) = @_;
60  
61 23 return $self->{quoter}->quote($column);
62 }
63  
64 4 1;
65 __END__
« blib/lib/SQL/Composer/Expression.pm ↑ Summary blib/lib/SQL/Composer/Quoter.pm »