orm查询2

与 或 查询

db.session.query(Employee).filter(Employee.gender=='男',Employee.salary>5000)

from sqlalchemy import and_,or_  #sqlalchemy框架中准备的

db.session.query(Employee).filter(and_(Employee.gender=='男',Employee.salary>5000)) #与

db.session.query(Employee).filter(or_(Employee.name.startswith('刘'),Employee.salary>5000)) #或

排序

db.session.query(User).order_by(User.id) #默认按照升序

from sqlalchemy import desc

db.session.query(User).order_by(desc(User.id))#倒序

first() one()

运用sql语句

from sqlalchemy import text

count统计

db.session.query(User).filter(User.name='tom',User.password='123456').count() #统计用户名为tom和密码为123456的数量

from sqlalchemy import func
db.session.query(func.count(User.name),User.name).group_by(User.userlevelid).all()#统计用户的姓名，显示为用户的姓名，按照userlevelid分组