Thanks. I think I tried that (of course I don't have any notes...) There didn't appear to be a way to get fields from joined tables referred to using select/as to inflate.
Hu Hailin wrote: > > 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 <[email protected]> > 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/[email protected] >> > > > > -- > islue > > _______________________________________________ > 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/[email protected] > > -- View this message in context: http://n2.nabble.com/Prefetch-and-From-tp1693458p2116737.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/[email protected]
