X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fp5-DBIx-Class-ResultSet-RecursiveUpdate;a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FResultSet%2FRecursiveUpdate.pm;h=c0be5cdd27a82ec2e0eeb8d7be061a547a1cb67f;hp=fcc3b0a92d0bf5d2ccfc840edc5de9ad44b615ab;hb=26d2267b2b938a7b6ee683d1b8e6e500bbb893d1;hpb=b09b840cdf99eb0279eba29f46b2a98fd67b8c82 diff --git a/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm b/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm index fcc3b0a..c0be5cd 100644 --- a/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm +++ b/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm @@ -267,21 +267,19 @@ sub _update_relation { ->{is_nullable}; } - #warn "\tNULLABLE: $all_fks_nullable\n"; $if_not_submitted = $all_fks_nullable ? 'nullify' : 'delete' unless defined $if_not_submitted; - # handle undef - #if (not defined $updates && $if_not_submitted eq 'delete') { - # warn "$name " . ref $object; - # $object->related_resultset($name)->delete; - # return; - #} + #warn "\tNULLABLE: $all_fks_nullable ACTION: $if_not_submitted\n"; #warn "RELINFO for $name: " . Dumper($info); use Data::Dumper; # the only valid datatype for a has_many rels is an arrayref if ( $info->{attrs}{accessor} eq 'multi' ) { + + # handle undef like empty arrayref + $updates = [] + unless defined $updates; $self->throw_exception( "data for has_many relationship '$name' must be an arrayref") unless ref $updates eq 'ARRAY'; @@ -301,7 +299,6 @@ sub _update_relation { #warn "\tcreated and updated related rows\n"; - my @cond; my @related_pks = $related_resultset->result_source->primary_columns; my $rs_rel_delist = $object->$name; @@ -314,8 +311,10 @@ sub _update_relation { } ); } + # foreign table has multiple pk columns else { + my @cond; for my $obj (@updated_objs) { my %cond_for_obj; for my $col (@related_pks) { @@ -323,7 +322,10 @@ sub _update_relation { } push @cond, \%cond_for_obj; } - $rs_rel_delist = $rs_rel_delist->search_rs({ -not => [@cond] }); + # only limit resultset if there are related rows left + if (scalar @cond) { + $rs_rel_delist = $rs_rel_delist->search_rs( { -not => [@cond] } ); + } } #warn "\tCOND: " . Dumper(\%cond); @@ -332,36 +334,12 @@ sub _update_relation { #warn "\tdeleting related rows: $rel_delist_cnt\n"; $rs_rel_delist->delete; - - # # only handles related result classes with single primary keys - # if ( 1 == $rel_col_cnt ) { - # $object->$name->search( - # { $rel_cols[0] => - # { -not_in => [ map ( $_->id, @updated_objs ) ] } - # } - # )->delete; - # } - # else { - # warn "multi-column relationships aren't supported\n"; - # } } elsif ( $if_not_submitted eq 'set_to_null' ) { #warn "\tnullifying related rows: $rel_delist_cnt\n"; my %update = map { $_ => undef } @rel_cols; $rs_rel_delist->update( \%update ); - - # # only handles related result classes with single primary keys - # if ( 1 == $rel_col_cnt ) { - # $object->$name->search( - # { $rel_cols[0] => - # { -not_in => [ map ( $_->id, @updated_objs ) ] } - # } - # )->update( { $rel_cols[0] => undef } ); - # } - # else { - # warn "multi-column relationships aren't supported\n"; - # } } } elsif ($info->{attrs}{accessor} eq 'single'