查询
常用筛选器运算符
在filter()
中:
-
euqals:
query.filter(User.name == ‘ed’) -
not equals:
query.filter(User.name != ‘ed’) -
LIKE:(某些后端区分大小写,某些不区分大小写)
query.filter(User.name.like(’%ed%’)) -
ILIKE:(不区分大小写)
query.filter(User.name.ilike(’%ed%’)) -
IN:
query.filter(User.name.in_[‘ed’, ‘webdy’, ‘jack’])query.filter(User.name.in_(session.query(User.name).filter(User.name.like(’%ed%’))))
-
NOT IN
query.filter(~User.name.in_([‘ed’], ‘wendy’, ‘jack’)) -
IS NULL:
query.filter(User.name != None) -
AND
from sqlalchemy import and_- query.filter(and_(User.name == ‘ed’, User.fullname == ‘ED Jones’))
- query.filter(User.name == ‘ed’, User.fullname == ‘ED Jones’) <