这里有两张一对多的关系表,User和Comment。
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(32), unique=True, index=True)
username = db.Column(db.String(64), unique=True, index=True)
password_hash = db.Column(db.String(128))
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
comments = db.relationship('Comment', backref='author', lazy='dynamic')
class Comment(db.Model):
__tablename__ = 'comments'
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
star = db.Column(db.Boolean, default=False)
author_id = db.Column(db.Integer, db.ForeignKey('users.id'))
User表是用户, Comment表是用户的评论, 怎么按用户的评论数做降序排列?
需要哪些参数,自行在with_entities和下面的query中添加。
更改排序方式的话,自行更改asc或desc。