Skip to content

Instantly share code, notes, and snippets.

@youqingkui

youqingkui/SQLALCHEMY LEFT JOIN.py

Last active August 29, 2015 14:25
Show Gist options
  • Save youqingkui/71c3868c90742b055fb7 to your computer and use it in GitHub Desktop.
Save youqingkui/71c3868c90742b055fb7 to your computer and use it in GitHub Desktop.
Download ZIP
SQLALCHEMY 外联结
Raw
SQLALCHEMY LEFT JOIN.py
# SQLALCHEMY LEFT JOIN
db.session.query(PushHistory, CronPublish).\
outerjoin(CronPublish, and_(CronPublish.tid == PushHistory.id, CronPublish.ttype == 4))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment