Breaking News: Grepper is joining You.com. Read the official announcement!

SQLAlchemy ordering by count on a many to many relationship

SAMER SAEID answered on May 15, 2022 Popularity 1/10 Helpfulness 1/10

answer SQLAlchemy ordering by count on a many to many relationship

related SQLAlchemy ordering by count on a many to many relationship

SQLAlchemy ordering by count on a many to many relationship

Comment

db.session.query(Post, func.count(likes.c.user_id).label('total')).join(likes).group_by(Post).order_by('total DESC')

Popularity 1/10 Helpfulness 1/10 Language python

Source: Grepper

Tags: count many-to-many python relationship sqlalchemy

Link to this answer
Share Copy Link

Contributed on May 15 2022

SAMER SAEID

0 Answers Avg Quality 2/10

Closely Related Answers

SQLAlchemy ordering by count on a many to many relationship

Comment

likes = db.Table('likes',
    db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
    db.Column('post_id', db.Integer, db.ForeignKey('post.id'))
)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20))

    def __repr__(self):
        return "<User('%s')>" % self.username

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(255))

    likes = db.relationship('User', secondary = likes,
        backref = db.backref('posts', lazy='dynamic'))

    def __repr__(self):
        return "<Post('%s')>" % self.title

Popularity 1/10 Helpfulness 1/10 Language python

Source: Grepper

Tags: count many-to-many python relationship sqlalchemy

Link to this answer
Share Copy Link

Contributed on May 15 2022

SAMER SAEID

0 Answers Avg Quality 2/10

SQLAlchemy ordering by count on a many to many relationship

Contents

More Related Answers

SQLAlchemy ordering by count on a many to many relationship

Closely Related Answers

SQLAlchemy ordering by count on a many to many relationship

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.