一、过滤条件
过滤是数据提取的一个很重要的功能,以下对一些常用的过滤条件进行解释,并且这些过滤条件都是只能通过filter方法实现的
equals
query.filter(User.name == 'ed')或query.filter_by(name = 'ed')
not equals
query.filter(User.name != 'ed')
like
query.filter(User.name.like('%ed%'))
in
query.filter(User.name.in_(['ed','wendy','jack']))
not in
query.filter(User.name.notin_(['ed','wendy','jack']))
is null(nul与Nonenone不占位置而null相当于空字符串)
query.filter(User.name != None)
and
from sqlalchemy import and_
query.filter(and_(User.name=='ed',User.fullname=='Ed Jones')