文章内容
2018/10/30 14:17:36,作 者: 黄兵
SQLAlchemy 多条件查询
SQLAlchemy and or 查询方式范例:
• AND:
# use and_() from sqlalchemy import and_ query.filter(and_(User.name == 'ed', User.fullname == 'Ed Jones')) # or send multiple expressions to .filter() query.filter(User.name == 'ed', User.fullname == 'Ed Jones') # or chain multiple filter()/filter_by() calls query.filter(User.name == 'ed').filter(User.fullname == 'Ed Jones')
• OR:
from sqlalchemy import or_ query.filter(or_(User.name == 'ed', User.name == 'wendy'))
• MATCH:
query.filter(User.name.match('wendy'))
黄兵个人博客原创。
转载请注明出处:黄兵个人博客 - SQLAlchemy 多条件查询
评论列表