[Dbix-class] Multi table join

[Jon Molin]

On 1/1/06, Matt S Trout <dbix-class at trout.me.uk> wrote:

> my $rs = Book2Author->search({
>            'book.title' => { 'like', 'foo%' },
>            ' author.first_name' => { 'like', 'bar%' } },
>          { prefetch => [ qw/book author/ ] });
>
> should do what you want, since prefetch automatically fills out the 'join'
> attribute to include the tables.



Thanks, I'll try that.

I'm afraid the docs are still fairly light on join stuff; the join.tl in
> t/run
> is probably the best source of examples. Contributions would be very much
> welcome :)


Point taken :)

If I end up feeling I know enough I'll try to contribute.


--
>      Matt S Trout       Offering custom development, consultancy and
> support
>   Technical Director    contracts for Catalyst, DBIx::Class and BAST.
> Contact
> Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more
> information
>
> + Help us build a better perl ORM:
> http://dbix-class.shadowcatsystems.co.uk/ +
>
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/dbix-class/attachments/20060102/a6c45af1/attachment.htm