与 或 查询
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分组