Python sqlalchemy 高级用法

最新推荐文章于 2024-09-13 18:11:35 发布

weixin_30570101

最新推荐文章于 2024-09-13 18:11:35 发布

阅读量196

点赞数

文章标签： python

原文链接：http://www.cnblogs.com/rixian/p/11495757.html

版权

一. 关联查询

sys_user_list = SysPermission.query.join(OrgRolePermission, OrgRolePermission.sys_permission_id == SysPermission.id).filter(OrgRolePermission.role_name == user_cache["role"]).all()

二. 过滤查询

from sqlalchemy import not_
sys_list = SysPermission.query.filter(not_(SysPermission.type == 1))

三. and, or查询

from sqlalchemy import and_, or_
sys_user_list = SysPermission.query.filter(and_(SysPermission.type == 2, SysPermission.type == 3)).all()
sys_user_list = SysPermission.query.filter(or_(SysPermission.type == 2, SysPermission.type == 3)).all()

转载于:https://www.cnblogs.com/rixian/p/11495757.html