Thanks for the feedback. I found an example in google groups that got
me on the right track.
For those interested, my sqlalchemy looks like:
multi_obs2 = aliased(multi_obs)
subQ = qaqc.db.session.query(multi_obs2).\
filter(multi_obs2.m_date >= beginDate).\
filter(multi_obs2.m_date < endDate).\
filter(multi_obs2.sensor_id == nnSensorId).\
filter(multi_obs2.d_top_of_hour == 1).\
filter(multi_obs2.d_report_hour ==
multi_obs.d_report_hour).\
correlate(multi_obs.__table__).\
statement
recs = qaqc.db.session.query(multi_obs).\
filter(multi_obs.m_date >= beginDate).\
filter(multi_obs.m_date < endDate).\
filter(multi_obs.sensor_id == sensorId).\
filter(multi_obs.d_top_of_hour == 1).\
filter(exists(subQ)).\
order_by(multi_obs.m_date.asc()).all()
--
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.
