On Dec 8, 2008, at 3:49 PM, [EMAIL PROTECTED] wrote:
> > hi > back to that old question about relation vs query, > i have some relation, say m2m via table with some additional fields > like timestamps (which are setup automaticaly). > so plain relation via secondary join is ok, no really need for > explicit assoc_object. > > by default, the relation will give me all items, regardless of timing. > now, i want to filter by times. it will be done by some function, > which will have the timing context and ... what? > the easiest answer is python-filtering: [x for x in the_relation if > x.fits.filter ] but that would be very expensive. i dont want that > relation loaded in full, it's meaningless. > so, is it possible easy to obtain the query which the relation will > issue, so i additionaly put .filter() on it and issue it myself? no > changes to original relation. sure... query (A).join(A.bs).filter(B.whatever=='foo').options(contains_eager(A.bs)) or if you want the B's by themselves given an "a" query(B).with_parent(some_a, "bs").filter(B.whatever=='foo') --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---