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'))