Re: [SQLObject] Filtering Many-To-Many relations
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Oleg B. <ph...@ma...> - 2006-08-27 20:32:22
|
On Sun, Aug 27, 2006 at 05:07:19PM -0300, Jorge Godoy wrote: > What I need is a JOIN. I believe I can't have it automatically done without > resorting to sqlbuilder... In SQL it would be: > > SELECT classone.* FROM classone c1, classone_classtwo c1c2 WHERE > c1c2.classone_id = c1.id AND c1c2.classtwo_id = <CONDITION>; > > I.e., filter results from ClassOne due to its relationship with ClassTwo in > the intermediate table. No, SQLObject currently cannot do such joins. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |