[Catalyst] prefetch specific columns

vti mbit at ukr.net
Tue Jul 10 09:57:07 GMT 2007


Jonathan Rockway(jon at jrock.us)@Tue, Jul 10, 2007 at 02:18:46AM -0500:
> On Sunday 08 July 2007 08:19:43 am vti wrote:
> > Hello.
> >
> > Is there any way when using 'prefetch' attribute to specify which columns
> > to get from db? Or is there any low-level way to change SQL before doing
> > any fetches?
> 
> Could you give us a bit of information on what you're trying to do?  What 
> Model are you using?  DBIC::Schema?
> 
> If you're using DBIx::Class, a better place to ask your DBIC questions is on 
> the DBIx::Class mailing list:
> 
> http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> 
> BTW, I have a hunch that you want is:
> 
>   $rs->search({ ... }, 
>                         { join       => [qw/relationship_name/], 
>                           columns => [qw/foo bar relationship_name.baz .../],
>                          });

I'm sorry, I resended my letter to dbix-class list. It is there.

-- 
vti -- Viacheslav Tikhanovskii



More information about the Catalyst mailing list