diff options
| author | rubenwardy <rw@rubenwardy.com> | 2020-07-18 03:14:56 +0100 |
|---|---|---|
| committer | rubenwardy <rw@rubenwardy.com> | 2020-07-18 03:14:56 +0100 |
| commit | 64dab0c4b65ee9742108c64d304a66c28e84788d (patch) | |
| tree | 1b4e1acd846fd6d5048d96acba6e9e8a536f3aeb /app/blueprints/packages/packages.py | |
| parent | dd7146205acda0b87f773b110d171c6a345c987d (diff) | |
| download | cheatdb-64dab0c4b65ee9742108c64d304a66c28e84788d.tar.xz | |
Filter tags by available packages in package search
Diffstat (limited to 'app/blueprints/packages/packages.py')
| -rw-r--r-- | app/blueprints/packages/packages.py | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/app/blueprints/packages/packages.py b/app/blueprints/packages/packages.py index f8124ea..17a12a1 100644 --- a/app/blueprints/packages/packages.py +++ b/app/blueprints/packages/packages.py @@ -96,8 +96,9 @@ def list_all(): qb.show_discarded = True topics = qb.buildTopicQuery().all() - tags = db.session.query(func.count(Tags.c.tag_id), Tag) \ - .select_from(Tag).outerjoin(Tags).group_by(Tag.id).order_by(db.asc(Tag.title)).all() + tags_query = db.session.query(func.count(Tags.c.tag_id), Tag) \ + .select_from(Tag).join(Tags).join(Package).group_by(Tag.id).order_by(db.asc(Tag.title)) + tags = qb.filterPackageQuery(tags_query).all() selected_tags = set(qb.tags) |