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 at all. so...you actually just want to
multiply geo_route rows times geo_location rows ?
anyway, to add a FROM clause explicitly, use query.select_from
(geo_location), and the table will be added to the FROM clause.
On Aug 9, 2007, at 10:23 AM, mattrussell wrote:
>
> Hi, related to my recent post on subclassing Column:
>
> The problem I have is that the right tables are not appearing in the
> "FROM" list in the query.
> I have overriden the 'in_' operatror on the column.
>
> When calling 'all()' on my query instance, I get the result back as I
> expected, but when calling 'count()' a table is missing which is used
> in the where clause:
>
> This is an example of a query which works using the 'count()'
> function on my query object:
>
> 2007-08-07 19:42:43,082 INFO sqlalchemy.engine.base.Engine.0x..8c
> SELECT count(geo_route.id)
> FROM geo_route, geo_location
> WHERE geo_location.id IN (%(geo_location_id)s, %(geo_location_id_1)s)
>
> And this is the one produced with my Column subclass overrindg 'in_'
> in place.
> Whether or not it overrides 'in_' or uses a different name ('within'
> for example) is irrelevent here i think.
> SELECT count(geo_route.id) \nFROM geo_route \nWHERE geo_location.point
> && SetSRID('BOX3D(-74.847708 39.884318, -74.823589 39.904667)'::box3d,
> 4326)" {}
>
> What am I missing? I assume operators do something to add the correct
> columns to the FROM list, but I can't see where. I've added print
> statements to the SA source to that end, but haven't been able to see
> it.
>
> Any help much appriciated.
>
> Thanks,
> Matt
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
