[Dbix-class] Fwd: [Catalyst] Selecting from more tables(DBIC-bug?)

Carl Johnstone dbixclass at fadetoblack.me.uk
Wed Jan 20 15:57:27 GMT 2010


Octavian Rasnita wrote:
> So is it not possible to create the following query with DBIC?
>
> SELECT me.id, blogs.id, blog_comments.id
> FROM user me LEFT JOIN blog blogs ON blogs.user = me.id
> LEFT JOIN blog_comment blog_comments ON blog_comments.blog = blogs.id;

Yes, but if you want to spend your life designing queries - you don't need 
an ORM. It's also half the equation as the query doesn't define how that 
maps back into objects.

> Can you please tell me how to do that?

Peter Rabbitson already answered you:

http://lists.scsys.co.uk/pipermail/dbix-class/2010-January/008804.html

Carl




More information about the DBIx-Class mailing list