blib/lib/SQL/Composer/Insert.pm

filter: Statementstmt 96.5% 56 / 58 Branchbran 77.7% 14 / 18 Conditioncond 55.5% 5 / 9 MC/DCmcdc 33.3% 2 / 6 Subroutinesub 100% 8 / 8 Podpod 0.0% 0 / 4 totaltotal 82.5% 85 / 103 CC 13 SCAR 20.7
CC
13
Cov
88%
new
12.4
to_bind
2.1
BEGIN
1.0
CRAP 7.9
« blib/lib/SQL/Composer/Update.pm ↑ Summary blib/lib/SQL/Composer/Expression.pm »
1 package SQL::Composer::Insert;
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  
9 sub new {
10 9 ▶ my $class = shift;
Subroutine new: called CC=12 SCAR=25.2
Pod undocumented
11 9 my (%params) = @_;
12  
13 9 my $self = { table => $params{into} };
14 9 bless $self, $class;
15  
16 $self->{quoter} =
17 9 ▶ $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
090
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
18  
19 9 my $sql = '';
20 9 my @bind;
21  
22 9 $sql .= 'INSERT INTO ';
23  
24 9 $sql .= $self->_quote($params{into});
25  
26 9 ▶ if ($params{values} && @{$params{values}}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($params{'values'} and @{$params{'values'};}) { } 7 2 9
Condition66%2/3
$params{"values"} and @{$params{"values"};}
!ll&&!rl&&r
027
MC/DC50%1/2
$params{"values"} and @{$params{"values"};}
$params{"values"} @{$params{"values"};}
Truth table66%2/3
A and B
A= $params{"values"}B= @{$params{"values"};}
ABresult
0X0
100
111
27 7 my @columns;
28 my @values;
29 7 ▶ while (my ($key, $value) = splice @{$params{values}}, 0, 2) {
Branch: 1 branch
BranchTrueFalseTotal
if (() = splice(@{$params{"values"};}, 0, 2)) 10 7 17
30 10 push @columns, $key;
31  
32 10 ▶ if (ref $value) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $value) { } 2 8 10
33 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
34 1 push @values, $$value;
35 }
36 elsif (ref $value eq 'REF') {
37 1 ▶ if (ref $$value eq 'ARRAY') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $$value eq 'ARRAY') { } 1 0 1
38 1 push @values, $$value->[0];
39 1 push @bind, @$$value[1 .. $#{$$value}];
40 }
41 else {
42 0 Carp::croak('unexpected reference');
43 }
44 }
45 else {
46 0 Carp::croak('unexpected reference');
47 }
48 }
49 else {
50 8 push @values, '?';
51 8 push @bind, $value;
52 }
53 }
54  
55 7 ▶ if (@columns) {
Branch: 1 branch
BranchTrueFalseTotal
if (@columns) 7 0 7
56 7 $sql .= ' (' . (join ',', map { $self->_quote($_) } @columns) . ')';
57 7 $sql .= ' VALUES (';
58 7 $sql .= join ',', @values;
59 7 $sql .= ')';
60 }
61  
62 # save this for later ...
63 7 $self->{columns} = \@columns;
64 }
65 else {
66 2 my $driver = $params{driver};
67 2 ▶ if ($driver && $driver =~ m/(?:sqlite|pg)/i) {
Branch: 1 branch
BranchTrueFalseTotal
if ($driver and $driver =~ /(?:sqlite|pg)/i) { } 1 1 2
Condition66%2/3
$driver and $driver =~ /(?:sqlite|pg)/i
!ll&&!rl&&r
101
MC/DC50%1/2
$driver and $driver =~ /(?:sqlite|pg)/i
$driver $driver =~ /(?:sqlite|pg)/i
Truth table66%2/3
A and B
A= $driverB= $driver =~ /(?:sqlite|pg)/i
ABresult
0X0
100
111
68 1 $sql .= ' DEFAULT VALUES';
69 }
70 else {
71 1 $sql .= ' () VALUES ()';
72 }
73 }
74  
75 9 $self->{sql} = $sql;
76 9 $self->{bind} = \@bind;
77  
78 9 return $self;
79 }
80  
81 1 ▶sub table { shift->{table} }
Subroutine table: called CC=1 SCAR=0.0
Pod undocumented
82  
83 8 ▶sub to_sql { shift->{sql} }
Subroutine to_sql: called CC=1 SCAR=0.0
Pod undocumented
84 8 ▶sub to_bind { @{shift->{bind} || []} }
Subroutine to_bind: called CC=2 SCAR=7.2
Pod undocumented
Branch: 1 branch
BranchTrueFalseTotal
+(shift())->{"bind"} or [] 0 8 8
85  
86 sub _quote {
87 21 ▶ my $self = shift;
Subroutine _quote: called CC=1 SCAR=0.0
88 21 my ($column, $prefix) = @_;
89  
90 21 return $self->{quoter}->quote($column, $prefix);
91 }
92  
93 4 1;
94 __END__
« blib/lib/SQL/Composer/Update.pm ↑ Summary blib/lib/SQL/Composer/Expression.pm »