from sqlalchemy import and_, or_
User.query.order_by(and_(User.popularity.desc(), User.date_created.desc())).all()
cvg_items = session.query(Ww).order_by(and_(Ww.site, Ww.pn)).all()
自定义排序
cvg_items = session.query(Ww).order_by(case(value=Ww.site, whens={'CVG':0,
'Dub':1,
'Venlo':3,
'SGP':4,
'SLC':5,
'CMH':6,
'LUK':7,
'TJ Direct ship':8
}
),Ww.pn).all()
参考
https://stackoverflow.com/questions/15791760/how-can-i-do-multiple-order-by-in-flask-sqlalchemy