Hi,
I have different outputs depending on using a select statement as
oppose to an object mapped query. This is happening when I am using
outer joins.
Here is the trace of the select that gives me something:
In <1>: a = select([tblspotbandsol.c.spotbandsolid, tbllane.c.laneid],
tblspotbandsol.c.spotbandsolid==32978,
from_obj=[tblspotbandsol.outerjoin(tbllane,
tbllane.c.laneid==tblspotbandsol.c.laneid)])
In <2>: Session.execute(a).fetchall()
2008-01-23 15:00:39,034 INFO sqlalchemy.engine.base.Engine.0x..94
SELECT "TBLSPOTBANDSOL".spotbandsolid, "TBLLANE".laneid
FROM j1."TBLSPOTBANDSOL" LEFT OUTER JOIN j1."TBLLANE" ON
"TBLLANE".laneid = "TBLSPOTBANDSOL".laneid
WHERE "TBLSPOTBANDSOL".spotbandsolid = :TBLSPOTBANDSOL_spotbandsolid
2008-01-23 15:00:39,035 INFO sqlalchemy.engine.base.Engine.0x..94
{'TBLSPOTBANDSOL_spotbandsolid': 32978.0}
Out<2>: [(Decimal("32978"), None)]
Object query returns an empty set:
In <3>: jLane = tblspotbandsol.outerjoin(tbllane,
tbllane.c.laneid==tblspotbandsol.c.laneid)
In <4>: mapper(LaneClass,jLane)
Out<4>: <sqlalchemy.orm.mapper.Mapper object at 0xb36f382c>
In <5>:
Session.query(LaneClass).filter(LaneClass.spotbandsolid==32978).all()
2008-01-23 15:00:59,379 INFO sqlalchemy.engine.base.Engine.0x..94
SELECT "TBLSPOTBANDSOL".spotbandsolid AS
"TBLSPOTBANDSOL_spotbandsolid", "TBLSPOTBANDSOL".class AS
"TBLSPOTBANDSOL_class", "TBLSPOTBANDSOL".createdate AS
"TBLSPOTBANDSOL_createdate", "TBLLANE".createdate AS
"TBLLANE_createdate", "TBLSPOTBANDSOL".createusername AS
"TBLSPOTBANDSOL_createusername", "TBLLANE".createusername AS
"TBLLANE_createusername", "TBLSPOTBANDSOL".laneid AS
"TBLSPOTBANDSOL_laneid", "TBLLANE".laneid AS "TBLLANE_laneid",
"TBLSPOTBANDSOL".ltekd AS "TBLSPOTBANDSOL_ltekd", "TBLLANE".lanenumber
AS "TBLLANE_lanenumber", "TBLLANE".label AS "TBLLANE_label",
FROM j1."TBLSPOTBANDSOL" LEFT OUTER JOIN j1."TBLLANE" ON
"TBLLANE".laneid = "TBLSPOTBANDSOL".laneid
WHERE "TBLSPOTBANDSOL".spotbandsolid = :TBLSPOTBANDSOL_spotbandsolid
ORDER BY "TBLSPOTBANDSOL".rowid
2008-01-23 15:00:59,380 INFO sqlalchemy.engine.base.Engine.0x..94
{'TBLSPOTBANDSOL_spotbandsolid': 32978.0}
Out<5>: []
I am pretty new with sqlalchemy, so maybe the answer is obvious for
everyone...
Thank you
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
