[sqlalchemy] Re: Question about queries and operators

2007-08-09 Thread Michael Bayer
add_entity() by itself is not going to add a table to a count() function; the extra entities arent taken into account by count(). Looking at the query you have below, i.e. the one which works, im a little puzzled. you aren't associating the geo_route and geo_location tables together

[sqlalchemy] Re: Question about queries and operators

2007-08-09 Thread mattrussell
Hi Michael, I've sorted this one now :) I'm sorry for the amigious nature of my post... wasn't clear in my head at the time. You are right, I wasn't associating between the two entities in the example I gave. I ended up using sqlalchemy.sql._BinaryExpresssion in my subclass, which enabled the

[sqlalchemy] Re: Question about queries and operators

2007-08-09 Thread Michael Bayer
hey matt - you might also look at a new feature we have in 0.4 called composite column types, this is an ORM-only feature whereby you can provide column-behavior on a plugin basis and also use multiple columns to represent a single scalar unit: