On Mar 16, 2009, at 10:48 PM, Alisue wrote:
>
> Hey thanks! I figured out but I still don't know why...
>
> subquery = query.subquery()
> minroom = meta.Session.query(subquery.c.property_id, func.min
> (subquery.c.house_rent).label('minprice'))
> minroom = minroom.group_by(subquery.c.property_id
Hey thanks! I figured out but I still don't know why...
subquery = query.subquery()
minroom = meta.Session.query(subquery.c.property_id, func.min
(subquery.c.house_rent).label('minprice'))
minroom = minroom.group_by(subquery.c.property_id)
minroom = minroom.subquery()
query = meta.Session.query(m
Oops. actually the out put was the below... sorry
11:34:23,867 INFO [iyeiye.lib.search.wringout]
-
11:34:23,887 INFO [sqlalchemy.engine.base.Engine.
0x...e8ec._beg
Well... sorry I can't find the issue from my code and output.
---output--
11:25:02,197 INFO [iyeiye.lib.search.wringout]
-
11:25:02,220 INFO [sqlalch
the Query will consolidate multiple rows with the same primary key into a
single object instance - comparing the rows returned by the two different
approaches will reveal the source of the issue. set echo='debug' to see
that output.
Alisue wrote:
>
> SQLAlchemy: 0.5.2
> SQLite: 3.5.9
> MySQL