Hi
This is making me mad :(
I have two tables without defined relations in their models(i have to make
my app works with given db) and this is how i make a join query:
subq = DBSession.query(models.ZT_420_001.ma_master_code,
models.ZT_420_001.ma_region,
models.ZT_420_001.ma_subs,
models.ZT_420_001.ma_grid,
models.ZT_420_001.ma_xutm,
models.ZT_420_001.ma_yutm).subquery()
query = DBSession.query(models.StatSheet).\
join(subq, and_(models.StatSheet.ma_region_id == subq.c.ma_region,
models.StatSheet.ma_utm_x == subq.c.ma_xutm,
models.StatSheet.ma_utm_y == subq.c.ma_yutm,
models.StatSheet.ma_unique_code ==
func.TO_CHAR(subq.c.ma_subs))
).filter(models.StatSheet.ma_resource_type_id == 1)
Now when i run query by query.all() it gives me 1803 records but when i use
execute and fetchall, i'll have 1810 rows!
results = query.all() #=> returns 1803 rows
results = DBSession.execute(query).fetchall() #=> returns 1810 rows
I checked the result by running the same query in oracle sqldeveloper and
the correct result was 1810.
So why is this happening?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
