use Carp::Clan qw/^DBIx::Class|^HTML::FormHandler|^Try::Tiny/;
use Scalar::Util qw( blessed );
use List::MoreUtils qw/ any /;
+use Try::Tiny;
sub recursive_update {
my %params = @_;
my $source = $self->result_source;
+ croak "first parameter needs to be defined"
+ unless defined $updates;
+
+ croak "first parameter needs to be a hashref"
+ unless ref($updates) eq 'HASH';
+
# warn 'entering: ' . $source->from();
- carp 'fixed fields needs to be an array ref'
+ croak 'fixed fields needs to be an arrayref'
if defined $fixed_fields && ref $fixed_fields ne 'ARRAY';
+ # always warn about additional parameters if storage debugging is enabled
+ $unknown_params_ok = 0
+ if $source->storage->debug;
+
if ( blessed($updates) && $updates->isa('DBIx::Class::Row') ) {
return $updates;
}
- if ( exists $updates->{id} ) {
+
+ if ( !defined $object && exists $updates->{id} ) {
+
# warn "finding object by id " . $updates->{id} . "\n";
$object = $self->find( $updates->{id}, { key => 'primary' } );
+
# warn "object not found by id\n"
# unless defined $object;
}
my %fixed_fields = map { $_ => 1 } @$fixed_fields
if $fixed_fields;
+
+ # the updates hashref might contain the pk columns
+ # but with an undefined value
my @missing =
- grep { !exists $updates->{$_} && !exists $fixed_fields{$_} }
+ grep { !defined $updates->{$_} && !exists $fixed_fields{$_} }
$source->primary_columns;
- if ( !$object && !scalar @missing ) {
+
+ # warn "MISSING: " . join(', ', @missing) . "\n";
+ if ( !defined $object && scalar @missing == 0 ) {
# warn 'finding by: ' . Dumper( $updates ); use Data::Dumper;
$object = $self->find( $updates, { key => 'primary' } );
}
+
+ # add the resolved columns to the updates hashref
$updates = { %$updates, %$resolved };
- @missing =
- grep { !exists $resolved->{$_} } @missing;
- if ( !$object && !scalar @missing ) {
- # warn 'finding by +resolved: ' . Dumper( $updates ); use Data::Dumper;
+ # the resolved hashref might contain the pk columns
+ # but with an undefined value
+ @missing = grep { !defined $resolved->{$_} } @missing;
+
+ #warn "MISSING2: " . join( ', ', @missing ) . "\n";
+ if ( !defined $object && scalar @missing == 0 ) {
+
+ # warn 'finding by +resolved: ' . Dumper( $updates ); use Data::Dumper;
$object = $self->find( $updates, { key => 'primary' } );
}
- $object = $self->new( {} )
+ $object = $self->new_result( {} )
unless defined $object;
# warn Dumper( $updates ); use Data::Dumper;
# warn 'updates: ' . Dumper( $updates ); use Data::Dumper;
# warn 'columns: ' . Dumper( \%columns_by_accessor );
for my $name ( keys %$updates ) {
+
# columns
if ( exists $columns_by_accessor{$name}
&& !( $source->has_relationship($name)
my @rows;
my $result_source = $object->$name->result_source;
my @updates;
- if ( !defined $value ) {
- #next;
- @updates = ();
- }
- elsif ( ref $value ) {
+ if ( defined $value && ref $value eq 'ARRAY' ) {
@updates = @{$value};
}
- else {
+ elsif ( defined $value && !ref $value ) {
@updates = ($value);
}
+ elsif ( defined $value ) {
+ carp
+ "value of many-to-many rel '$name' must be an arrayref or scalar: $value";
+ }
for my $elem (@updates) {
- if ( ref $elem ) {
+ if ( blessed($elem) && $elem->isa('DBIx::Class::Row') ) {
push @rows, $elem;
- # recursive_update(
- # resultset => $result_source->resultset,
- # updates => $elem
- # );
+ }
+ elsif ( ref $elem eq 'HASH' ) {
+ push @rows,
+ recursive_update(
+ resultset => $result_source->resultset,
+ updates => $elem
+ );
}
else {
push @rows,
&& $DBIx::Class::ResultSource::UNRESOLVABLE_CONDITION
== $resolved;
+ #warn "RESOLVED: " . Dumper($resolved); use Data::Dumper;
+
my @rel_cols = keys %{ $info->{cond} };
map {s/^foreign\.//} @rel_cols;
->{is_nullable};
}
- $if_not_submitted = $all_fks_nullable ? 'nullify' : 'delete'
+ $if_not_submitted = $all_fks_nullable ? 'set_to_null' : 'delete'
unless defined $if_not_submitted;
#warn "\tNULLABLE: $all_fks_nullable ACTION: $if_not_submitted\n";
$rs_rel_delist =
$rs_rel_delist->search_rs( { -not => [@cond] } );
}
+ #warn "\tCOND: " . Dumper(\@cond);
}
- #warn "\tCOND: " . Dumper(\%cond);
#my $rel_delist_cnt = $rs_rel_delist->count;
if ( $if_not_submitted eq 'delete' ) {
#warn "\tupdating rel '$name': $if_not_submitted\n";
my $sub_object;
if ( ref $updates ) {
+ if ( blessed($updates) && $updates->isa('DBIx::Class::Row') ) {
+ $sub_object = $updates;
+ }
# for might_have relationship
- if ( $info->{attrs}{accessor} eq 'single'
+ elsif ( $info->{attrs}{accessor} eq 'single'
&& defined $object->$name )
{
$sub_object = recursive_update(
if ( $rclass->can('_m2m_metadata') ) {
return $rclass->_m2m_metadata->{$relation};
}
- my $object = $self->new( {} );
+ my $object = $self->new_result( {} );
if ( $object->can($relation)
and !$self->result_source->has_relationship($relation)
and $object->can( 'set_' . $relation ) )
->related_source(
$rclass->_m2m_metadata->{$relation}{foreign_relation} );
}
- my $object = $self->new( {} );
+ my $object = $self->new_result( {} );
my $r = $object->$relation;
return $r->result_source;
}