[Dbix-class] Prefetch and From

[Hu Hailin]

Hi, Martin

2) select/as could help, but not convenient. and also i think you knew
it already.

On Tue, Dec 23, 2008 at 8:10 PM, Martinc <martin.j.clayton at gmail.com> wrote:
>
> First post ... be gentle.
>
> I've resorted to using DBIx::Class::ResultSet 'from' in a search.
> There's an outer join with an IN list in an ON clause.
> Being greedy, I want to prefetch too.
>
> The only way I've got it to 'work' is to violate encapsulation and not
> respect the privacy of the module as follows:
>
>  my $rs = $result_set->search(
>    {
>      ... criteria ...
>    },
>    {
>      prefetch => ... entities to prefetch ...
>    }
>  );
>  $rs->_resolved_attrs();
>  $rs->{_attrs}->{from} = ... manual FROM clause ...
>
>  while ( $rs->next )
>  {
>    ...
>  }
>
> The manual 'from' clause ensures all the prefetched tables are included as
> specified in prefetch.
>
> Questions:
>
> 1) Is there a way to mix prefetch and manual 'from' that does not require
> the hack above.
> 2) I don't need all the columns in the underlying (nested) tables, can I
> prefetch a subset of columns?
>
> Version is 0.08009.
>
> Regards,
>
> Martin.
> --
> View this message in context: http://n2.nabble.com/Prefetch-and-From-tp1693458p1693458.html
> Sent from the DBIx-Class mailing list archive at Nabble.com.
>
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>



-- 
islue