|Just another Perl shrine|
Re: correlated subqueries in DBIx::Classby morgon (Priest)
|on Jan 16, 2011 at 05:20 UTC||Need Help??|
I figured out my real problem, which is similar.
Instead of artists/cds/tracks I have customers/boxes/devices.
A customer has many boxes, a box has many devices.
I want to have a customer-resultset that contain a count-column of all devices that belong to a customer (via a box).
Here is what seems to do the trick, comments would be very welcome as this is the most complex thing I ever did with dbix::class:
What may look as utter gibberish in fact generates the following SQL:
I would like to stress that while this may look complex it actually is not too bad once you've wrapped your brain around the way DBIx::Class represents queries.
While this may not be the best demonstration of DBIx::Class strenghts I cannot recommend it high enough - while sometimes it may take some time figuring it out it saves tons of time in the long run.
If you don't use it already check it out.