blib/lib/SQL/Composer/Upsert.pm

filter: Statementstmt 96.3% 26 / 27 Branchbran 83.3% 5 / 6 Conditioncond 50.0% 1 / 2 MC/DCmcdc 0.0% 0 / 1 Subroutinesub 100% 5 / 5 Podpod 0.0% 0 / 1 totaltotal 88.1% 37 / 42 CC 5 SCAR 11.8
CC
5
Cov
91%
new
5.1
BEGIN
1.0
BEGIN
1.0
CRAP 3.3
« blib/lib/SQL/Composer/Quoter.pm ↑ Summary blib/lib/SQL/Composer/Delete.pm »
1 package SQL::Composer::Upsert;
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 ▶use SQL::Composer::Insert;
Subroutine BEGIN: called CC=1 SCAR=0.0
7  
8 3 ▶our @ISA; BEGIN { @ISA = ('SQL::Composer::Insert') };
Subroutine BEGIN: called CC=1 SCAR=0.0
9  
10 sub new {
11 3 ▶ my $class = shift;
Subroutine new: called CC=5 SCAR=16.2
Pod undocumented
12 3 my (%params) = @_;
13  
14 my $driver = $params{driver}
15 3 ▶ || die 'Cannot create an Upsert object without specifying a `driver`';
Condition50%1/2
$params{'driver'} || die('Cannot create an Upsert object without specifying a `driver`')
l!l
30
MC/DC0%0/1
$params{'driver'} || die('Cannot create an Upsert object without specifying a `driver`')
$params{'driver'}
Truth table50%1/2
A
A= $params{'driver'}
Aresult
11
00
16  
17 3 my $self = $class->SUPER::new( %params );
18 3 my $sql = $self->{sql};
19  
20 3 ▶ if ($driver =~ m/sqlite/i) {
Branch: 3 branches
BranchTrueFalseTotal
if ($driver =~ /sqlite/i) { } 1 2 3
elsif ($driver =~ /mysql/i) { } 1 1 2
elsif ($driver =~ /pg/i) { } 1 0 1
21 1 $sql =~ s/^INSERT /INSERT OR REPLACE /;
22 }
23 elsif ($driver =~ m/mysql/i) {
24 $sql .= ' ON DUPLICATE KEY UPDATE '
25 . (join ', ' => map {
26 2 my $c = $self->_quote($_);
27 2 ($c.' = VALUES('.$c.')')
28 1 } @{ $self->{columns} });
29 }
30 elsif ($driver =~ m/pg/i) {
31 1 $sql .= ' ON CONFLICT DO UPDATE'
32 }
33 else {
34 0 die 'The Upsert `driver` (' . $driver . ') is not supported';
35 }
36  
37 3 $self->{sql} = $sql;
38  
39 3 return $self;
40 }
41  
42 3 1;
43 __END__
« blib/lib/SQL/Composer/Quoter.pm ↑ Summary blib/lib/SQL/Composer/Delete.pm »