sqlalchemy filter

最新推荐文章于 2025-01-22 11:57:36 发布

Claroja

最新推荐文章于 2025-01-22 11:57:36 发布

阅读量1.9k

点赞数 1

分类专栏： SQL 文章标签： filter

SQL 专栏收录该内容

65 篇文章

订阅专栏

                    
                        
                    
                    方法orm
equalsquery.filter(User.name == ‘wang’)
not equalsquery.filter(User.name != ‘wang’)
LIKEquery.filter(User.name.like(‘%ed%’))
INquery.filter(User.name.in_([‘ed’, ‘wendy’, ‘jack’]))
NOT INquery.filter(~User.name.in_([‘ed’, ‘wendy’, ‘jack’]))
IS NULLquery.filter(User.name == None)
IS NOT NULLquery.filter(User.name != None)
ANDquery.filter(and_(User.name == ‘ed’, User.fullname == ‘Ed Jones’)) 或者query.filter(User.name == ‘ed’, User.fullname == ‘Ed Jones’)
ORquery.filter(or_(User.name == ‘ed’, User.name == ‘wendy’))

                

方法	orm
equals	query.filter(User.name == ‘wang’)
not equals	query.filter(User.name != ‘wang’)
LIKE	query.filter(User.name.like(‘%ed%’))
IN	query.filter(User.name.in_([‘ed’, ‘wendy’, ‘jack’]))
NOT IN	query.filter(~User.name.in_([‘ed’, ‘wendy’, ‘jack’]))
IS NULL	query.filter(User.name == None)
IS NOT NULL	query.filter(User.name != None)
AND	query.filter(and_(User.name == ‘ed’, User.fullname == ‘Ed Jones’)) 或者query.filter(User.name == ‘ed’, User.fullname == ‘Ed Jones’)
OR	query.filter(or_(User.name == ‘ed’, User.name == ‘wendy’))