(Job.status == 'queued').\
filter(~Job.dependencies.any(Job.status != 'done')).all()
assert jobs == [j1]
On Apr 18, 2014, at 5:20 AM, Maik Riechert maik.riech...@arcor.de
mailto:maik.riech...@arcor.de wrote:
query(Job).filter(Job.status ==
‘queued’).filter
==
‘queued’).filter(~Job.dependencies.any(Dependency.status != ‘done’))
On Apr 17, 2014, at 8:51 AM, Maik Riechert maik.r...@arcor.dejavascript:
wrote:
Hi everyone,
I am really lost on a query I try to formulate. In LINQ it would probably
like that (haven't done LINQ in quite some time):
from j
query(Job).filter(Job.status ==
‘queued’).filter(~Job.dependencies.any(Dependency.status != ‘done’))
One more thing. Dependency doesn't exist as a class. Job.dependencies is a
many-to-many association. That's why you probably have to use aliases to
refer to the status of the dependency
Hi everyone,
I am really lost on a query I try to formulate. In LINQ it would probably
like that (haven't done LINQ in quite some time):
from j in Job
where j.status == 'queued' and j.dependencies.all(d = d.status == 'done')
select j
So, Job.dependencies is a self-referential many-to-many