Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
744 views
in Technique[技术] by (71.8m points)

flask多对多关系怎么根据关联属性进行排序或查找?

标签Tag和文章Post是多对多的关系,标签model如下:

class Tag(db.Model):
  __tablename__ = 'tags'
  id = db.Column(db.Integer, primary_key = True)
  title = db.Column(db.String(64))
  posts = db.relationship('Post',
    secondary = post_tag_relations,
    backref = db.backref('tags', lazy = 'dynamic'),
    lazy='dynamic')

post_tag_relations是中间表。
现在我想分别进行以下两个操作:

  1. 根据post数量对tag进行排序
  2. 获取所有post数量大于1的tag

该怎么写查询?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...