[Dbix-class] Subquery question
luke.saunders at gmail.com
Tue May 16 14:04:08 CEST 2006
On 5/16/06, Dan Horne <dan.horne at redbone.co.nz > wrote:
> Hi All
> I'm trying to figure out how to perform subqueries with DBIx::Class. For
> example, I want to find all the roles that user 2 hasn't been assigned.
> The standard SQL is
> select role_id, display_name
> from app_role a
> where not exists
> (select 1
> from user_role u
> where u.user_id = 2
> and u.role_id = a.role_id);
> What would the DBIx::Class equivalent be?
> Dan Horne
Sadly subselects like this aren't possible with DBIC at the moment.
It's definitely on the TODO list, I guess Matt will be able to tell you
roughly when it'll be ready. Until then you'll have to find a way of doing
it that doesn't require the subselect.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Dbix-class