blib/lib/Otogiri/Plugin/DeleteCascade.pm

filter: Statementstmt 100% 38 / 38 Branchbran 100% 2 / 2 Conditioncond n/a MC/DCmcdc n/a Subroutinesub 100% 8 / 8 Podpod 100% 1 / 1 totaltotal 100% 49 / 49 CC 3 SCAR 3.4
CC
3
Cov
100%
delete_cascade
2.0
_delete_child
2.0
BEGIN
1.0
CRAP 1.4
↑ Summary
1 package Otogiri::Plugin::DeleteCascade;
2 2 ▶use 5.008005;
Subroutine BEGIN: called CC=1 SCAR=0.0
3 2 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 2 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
5  
6 2 our $VERSION = "0.04";
7  
8 2 ▶use Otogiri;
Subroutine BEGIN: called CC=1 SCAR=0.0
9 2 ▶use Otogiri::Plugin;
Subroutine BEGIN: called CC=1 SCAR=0.0
10 2 ▶use DBIx::Inspector;
Subroutine BEGIN: called CC=1 SCAR=0.0
11  
12 2 our @EXPORT = qw(delete_cascade);
13  
14 2 ▶sub delete_cascade {
Subroutine delete_cascade: called CC=2 SCAR=6.9
Pod documented
15 2 my ($self, $table_name, $cond_href) = @_;
16  
17 2 my @parent_rows = $self->select($table_name, $cond_href);
18 2 my $inspector = DBIx::Inspector->new(dbh => $self->dbh);
19 2 my $iter = $inspector->table($table_name)->pk_foreign_keys();
20 2 my $affected_rows = 0;
21 2 ▶ while( my $child_table_fk_info = $iter->next ) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $child_table_fk_info = $iter->next) 1 2 3
22 1 $affected_rows += _delete_child($self, $child_table_fk_info, @parent_rows);
23 }
24 2 $affected_rows += $self->delete($table_name, $cond_href);
25 2 return $affected_rows;
26 }
27  
28 1 ▶sub _delete_child {
Subroutine _delete_child: called CC=2 SCAR=6.9
29 1 my ($db, $child_table_fk_info, @parent_rows) = @_;
30 1 my $affected_rows = 0;
31 1 for my $parent_row ( @parent_rows ) {
32 1 my $child_table_name = $child_table_fk_info->fktable_name;
33 1 my $parent_column_name = $child_table_fk_info->pkcolumn_name;
34 1 my $child_column_name = $child_table_fk_info->fkcolumn_name;
35  
36 my $child_delete_condition = {
37 1 $child_column_name => $parent_row->{$parent_column_name},
38 };
39 1 $affected_rows += $db->delete_cascade($child_table_name, $child_delete_condition);
40 }
41 1 return $affected_rows;
42 }
43  
44  
45 2 1;
46 __END__
↑ Summary