[Dbix-class] PATCH: Support for arbitrary SQL in relationship definition

Rob Kinyon rob.kinyon at gmail.com
Mon Jun 29 15:17:27 GMT 2009


On Mon, Jun 29, 2009 at 10:13, Peter Rabbitson<rabbit+dbic at rabbit.us> wrote:
> A classical use-case is "right side condition on a left-join". There is
> no way to emulate those appropriately with WHERE - the condition has to
> reside in the join spec itself: i.e. you need to get ALL artists, and
> all cds issued in a *specific year*. If you do a regular join - you get
> only artists with CDs. If you do a (standard for has_many) left join -
> you populate the right side of the join with CDs you don't want, and there
> is no way to WHERE them out.

I'm not seeing this. Code, please?

-- 
Thanks,
Rob Kinyon



More information about the DBIx-Class mailing list