> Hi Daniel > Hi Oleg, > > I don´t know how to realize this with union but i think this should do it > > > # plain sql would be sth like this (untested) > select * from comment > where (object='zoo' and object_id=?) > or (object='cage' and object_id in (select id from cage where zoo=?)) > or (object='animal' and object_id in (select id from animal where cage > in (select id from cage where zoo=?))) > > > > > # could be translated to python with sqlbuilder to sth like this (untested) > > from sqlobject.sqlbuilder import * > aZoo = zoo.get(?) > someAnimals = [animal.id for animal in aCage.animals for aCage in > aZoo.cages] > > sql = SELECT(OR( > AND(comment.q.object == 'zoo', comment.q.object_id == ? ), > AND(comment.q.object == 'cage', IN(comment.q.object_id, aZoo.cages) ), > AND(comment.q.object == 'animal', IN(comment.q.object_id, someAnimals)) > )) > > result = comment._connection.queryAll(sql) > > didn´t test it but i think this should work? > maybe the subselect for animals can be included into a single select > select statement in sqlbuilder as well...? > > HTH, > Frank > > > On Thu, Mar 12, 2009 at 10:16, Oleg Broytmann <p...@phd.pp.ru> wrote: >> On Wed, Mar 11, 2009 at 06:52:17PM -0700, Daniel Fetchinson wrote: >>> Unfortunately I haven't found >>> working examples of SQLBuilder + UNION constructions so far, if I >>> don't manage to get it right I'll probably come back :) >> >> If you manage to get it right please come back anyway and show us an >> example! :)
Hi Frank, thanks a lot for this example! I'll test this and let you guys know if it worked for me or not. Since I couldn't get this working with a single query I simply did multiple different queries and combined the results in python. But if your solution works that would be even better. Cheers, Daniel -- Psss, psss, put it down! - http://www.cafepress.com/putitdown ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
