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]
