X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FResultSet.pm;h=05cb24c254947ffe1e87d27604843eca09f7b09c;hb=2af0ade2b3a8487711d0a4f97ef21fbadad8916a;hp=4f5f7224f1bb29c779e8f67bcb604f5d0f3f0cf1;hpb=98ba74b42c19f817bd58641a018b4bd1320d66cf;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/ResultSet.pm b/lib/DBIx/Class/ResultSet.pm index 4f5f722..05cb24c 100644 --- a/lib/DBIx/Class/ResultSet.pm +++ b/lib/DBIx/Class/ResultSet.pm @@ -11,6 +11,9 @@ use Data::Page; use Storable; use DBIx::Class::ResultSetColumn; use base qw/DBIx::Class/; + +use Data::Dumper; $Data::Dumper::Indent = 1; + __PACKAGE__->load_components(qw/AccessorGroup/); __PACKAGE__->mk_group_accessors('simple' => qw/result_source result_class/); @@ -93,7 +96,6 @@ sub new { } $attrs->{alias} ||= 'me'; - $attrs->{_orig_alias} ||= $attrs->{alias}; bless { result_source => $source, @@ -157,44 +159,23 @@ always return a resultset, even in list context. sub search_rs { my $self = shift; + my $rows; + + unless (@_) { # no search, effectively just a clone + $rows = $self->get_cache; + } + my $attrs = {}; $attrs = pop(@_) if @_ > 1 and ref $_[$#_] eq 'HASH'; - my $our_attrs = exists $attrs->{_parent_attrs} - ? { %{delete $attrs->{_parent_attrs}} } - : { %{$self->{attrs}} }; + my $our_attrs = { %{$self->{attrs}} }; my $having = delete $our_attrs->{having}; - # XXX should only maintain _live_join_stack and generate _live_join_h from that - if ($attrs->{_live_join_stack}) { - foreach my $join (reverse @{$attrs->{_live_join_stack}}) { - $attrs->{_live_join_h} = defined $attrs->{_live_join_h} - ? { $join => $attrs->{_live_join_h} } - : $join; - } - } - # merge new attrs into inherited foreach my $key (qw/join prefetch/) { next unless exists $attrs->{$key}; - if (my $live_join = $attrs->{_live_join_stack} || $our_attrs->{_live_join_stack}) { - foreach my $join (reverse @{$live_join}) { - $attrs->{$key} = { $join => $attrs->{$key} }; - } - } - $our_attrs->{$key} = $self->_merge_attr($our_attrs->{$key}, delete $attrs->{$key}); } - - $our_attrs->{join} = $self->_merge_attr( - $our_attrs->{join}, $attrs->{_live_join_h} - ) if ($attrs->{_live_join_h}); - - if (defined $our_attrs->{prefetch}) { - $our_attrs->{join} = $self->_merge_attr( - $our_attrs->{join}, $our_attrs->{prefetch} - ); - } - + my $new_attrs = { %{$our_attrs}, %{$attrs} }; my $where = (@_ ? ( @@ -234,13 +215,8 @@ sub search_rs { } my $rs = (ref $self)->new($self->result_source, $new_attrs); - $rs->{_parent_source} = $self->{_parent_source} if $self->{_parent_source}; - - unless (@_) { # no search, effectively just a clone - my $rows = $self->get_cache; - if ($rows) { - $rs->set_cache($rows); - } + if ($rows) { + $rs->set_cache($rows); } return $rs; } @@ -365,6 +341,7 @@ sub find { sub _unique_queries { my ($self, $query, $attrs) = @_; + my $alias = $self->{attrs}{alias}; my @constraint_names = exists $attrs->{key} ? ($attrs->{key}) : $self->result_source->unique_constraint_names; @@ -374,15 +351,21 @@ sub _unique_queries { my @unique_cols = $self->result_source->unique_constraint_columns($name); my $unique_query = $self->_build_unique_query($query, \@unique_cols); - next unless scalar keys %$unique_query; + my $num_query = scalar keys %$unique_query; + next unless $num_query; # Add the ResultSet's alias - my $alias = $self->{attrs}{alias}; - foreach my $key (grep { ! m/\./ } keys %$unique_query) { - $unique_query->{"$alias.$key"} = delete $unique_query->{$key}; + foreach my $col (grep { ! m/\./ } keys %$unique_query) { + $unique_query->{"$alias.$col"} = delete $unique_query->{$col}; } - push @unique_queries, $unique_query; + # XXX: Assuming quite a bit about $self->{attrs}{where} + my $num_cols = scalar @unique_cols; + my $num_where = exists $self->{attrs}{where} + ? scalar keys %{ $self->{attrs}{where} } + : 0; + push @unique_queries, $unique_query + if $num_query + $num_where == $num_cols; } return @unique_queries; @@ -555,9 +538,9 @@ sub _collapse_query { } else { # warn "LEAF: " . Dumper $query; - foreach my $key (keys %$query) { - my $value = $query->{$key}; - $collapsed->{$key}{$value}++; + foreach my $col (keys %$query) { + my $value = $query->{$col}; + $collapsed->{$col}{$value}++; } } } @@ -693,13 +676,14 @@ sub _resolved_attrs { my $self = shift; return $self->{_attrs} if $self->{_attrs}; - my $attrs = $self->{attrs}; - my $source = $self->{_parent_source} || $self->{result_source}; - my $alias = $attrs->{_orig_alias}; + my $attrs = { %{$self->{attrs}||{}} }; + my $source = $self->{result_source}; + my $alias = $attrs->{alias}; # XXX - lose storable dclone my $record_filter = delete $attrs->{record_filter}; - $attrs = Storable::dclone($attrs || {}); # { %{ $attrs || {} } }; + #$attrs = Storable::dclone($attrs || {}); # { %{ $attrs || {} } }; + $attrs->{record_filter} = $record_filter if $record_filter; $attrs->{columns} ||= delete $attrs->{cols} if exists $attrs->{cols}; @@ -709,9 +693,8 @@ sub _resolved_attrs { $attrs->{columns} = [ $self->{result_source}->columns ]; } - my $select_alias = $self->{attrs}{alias}; $attrs->{select} ||= [ - map { m/\./ ? $_ : "${select_alias}.$_" } @{delete $attrs->{columns}} + map { m/\./ ? $_ : "${alias}.$_" } @{delete $attrs->{columns}} ]; $attrs->{as} ||= [ map { m/^\Q${alias}.\E(.+)$/ ? $1 : $_ } @{$attrs->{select}} @@ -732,19 +715,23 @@ sub _resolved_attrs { push(@{$attrs->{as}}, @$adds); } - $attrs->{from} ||= [ { $alias => $source->from } ]; - $attrs->{seen_join} ||= {}; - my %seen; - if (my $join = delete $attrs->{join}) { - foreach my $j (ref $join eq 'ARRAY' ? @$join : ($join)) { - if (ref $j eq 'HASH') { - $seen{$_} = 1 foreach keys %$j; - } else { - $seen{$j} = 1; - } + $attrs->{from} ||= [ { 'me' => $source->from } ]; + if ($attrs->{_parent_from}) { + push @{$attrs->{from}}, @{$attrs->{_parent_from}}; + } + + if (exists $attrs->{join} || exists $attrs->{prefetch}) { + + my $join = delete $attrs->{join} || {}; + + if (defined $attrs->{prefetch}) { + $join = $self->_merge_attr( + $join, $attrs->{prefetch} + ); } + push(@{$attrs->{from}}, - $source->resolve_join($join, $alias, $attrs->{seen_join}) + $source->resolve_join($join, $alias, { %{$self->{_parent_seen_join}||{}} }) ); } @@ -759,24 +746,12 @@ sub _resolved_attrs { if (my $prefetch = delete $attrs->{prefetch}) { my @pre_order; foreach my $p (ref $prefetch eq 'ARRAY' ? @$prefetch : ($prefetch)) { - if ( ref $p eq 'HASH' ) { - foreach my $key (keys %$p) { - push(@{$attrs->{from}}, $source->resolve_join($p, $alias)) - unless $seen{$key}; - } - } else { - push(@{$attrs->{from}}, $source->resolve_join($p, $alias)) - unless $seen{$p}; - } # bring joins back to level of current class - $p = $self->_reduce_joins($p, $attrs) if $attrs->{_live_join_stack}; - if ($p) { - my @prefetch = $self->result_source->resolve_prefetch( - $p, $alias, {}, \@pre_order, $collapse - ); - push(@{$attrs->{select}}, map { $_->[0] } @prefetch); - push(@{$attrs->{as}}, map { $_->[1] } @prefetch); - } + my @prefetch = $source->resolve_prefetch( + $p, $alias, { %{$attrs->{_parent_seen_join}||{}} }, \@pre_order, $collapse + ); + push(@{$attrs->{select}}, map { $_->[0] } @prefetch); + push(@{$attrs->{as}}, map { $_->[1] } @prefetch); } push(@{$attrs->{order_by}}, @pre_order); } @@ -785,6 +760,25 @@ sub _resolved_attrs { return $self->{_attrs} = $attrs; } +sub _resolve_from { + my ($self) = @_; + my $source = $self->result_source; + my $attrs = $self->{attrs}; + + my $from = $attrs->{_parent_from} || []; +# || [ { $attrs->{alias} => $source->from } ]; + + my $seen = { %{$attrs->{_parent_seen_join}||{}} }; + + if ($attrs->{join}) { + push(@{$from}, + $source->resolve_join($attrs->{join}, $attrs->{alias}, $seen) + ); + } + + return ($from,$seen); +} + sub _merge_attr { my ($self, $a, $b) = @_; return $b unless $a; @@ -828,32 +822,6 @@ sub _merge_attr { } } -# bring the joins (which are from the original class) to the level -# of the current class so that we can resolve them properly -sub _reduce_joins { - my ($self, $p, $attrs) = @_; - - STACK: - foreach my $join (@{$attrs->{_live_join_stack}}) { - if (ref $p eq 'HASH') { - return undef unless exists $p->{$join}; - $p = $p->{$join}; - } elsif (ref $p eq 'ARRAY') { - foreach my $pe (@{$p}) { - return undef if $pe eq $join; - if (ref $pe eq 'HASH' && exists $pe->{$join}) { - $p = $pe->{$join}; - next STACK; - } - } - return undef; - } else { - return undef; - } - } - return $p; -} - sub _construct_object { my ($self, @row) = @_; my $info = $self->_collapse_result($self->{_attrs}{as}, \@row); @@ -1001,7 +969,7 @@ sub _count { # Separated out so pager can get the full count # todo: try CONCAT for multi-column pk my @pk = $self->result_source->primary_columns; if (@pk == 1) { - my $alias = $attrs->{_orig_alias}; + my $alias = $attrs->{alias}; foreach my $column (@distinct) { if ($column =~ qr/^(?:\Q${alias}.\E)?$pk[0]$/) { @distinct = ($column); @@ -1018,10 +986,8 @@ sub _count { # Separated out so pager can get the full count # offset, order by and page are not needed to count. record_filter is cdbi delete $attrs->{$_} for qw/rows offset order_by page pager record_filter/; - my $tmp_rs = (ref $self)->new($self->result_source, $attrs); - $tmp_rs->{_parent_source} = $self->{_parent_source} if $self->{_parent_source}; - #XXX - hack to pass through parent of related resultsets + my $tmp_rs = (ref $self)->new($self->result_source, $attrs); my ($count) = $tmp_rs->cursor->next; return $count; } @@ -1359,7 +1325,7 @@ sub new_result { "Can't abstract implicit construct, condition not a hash" ) if ($self->{cond} && !(ref $self->{cond} eq 'HASH')); my %new = %$values; - my $alias = $self->{attrs}{_orig_alias}; + my $alias = $self->{attrs}{alias}; foreach my $key (keys %{$self->{cond}||{}}) { $new{$1} = $self->{cond}{$key} if ($key =~ m/^(?:\Q${alias}.\E)?([^.]+)$/); } @@ -1605,30 +1571,21 @@ sub related_resultset { "' has no such relationship $rel") unless $rel_obj; - my @live_join_stack = @{$self->{attrs}{_live_join_stack}||[]}; - - # XXX mst: I'm sure this is wrong, somehow - # something with complex joins early on could die on search_rel - # followed by a prefetch. I think. need a test case. - - my $join_count = scalar(grep { $_ eq $rel } @live_join_stack); + my $join_count = $self->{attrs}{_parent_seen_join}{$rel}; my $alias = $join_count ? join('_', $rel, $join_count+1) : $rel; - - push(@live_join_stack, $rel); - - my $rs = $self->result_source->schema->resultset($rel_obj->{class})->search( + + my $rs = $self->search(undef, { join => $rel }); + my ($from,$seen) = $rs->_resolve_from; + + $self->result_source->schema->resultset($rel_obj->{class})->search_rs( undef, { select => undef, as => undef, alias => $alias, - _live_join_stack => \@live_join_stack, - _parent_attrs => $self->{attrs}} - ); - - # keep reference of the original resultset - $rs->{_parent_source} = $self->{_parent_source} || $self->result_source; - - return $rs; + where => $self->{cond}, + _parent_from => $from, + _parent_seen_join => $seen, + }); }; }