| 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
| |||||||||||
| 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__ | ||||||||||