- books = models.Book.tagged.with_all(tags).order_by()
- l_tags = [models.Tag.objects.get(slug = 'l-' + book.slug) for book in books]
- book_keys = [book.pk for book in books]
- related_tags = models.Tag.objects.usage_for_queryset(books, counts=True,
- extra={'where': ["catalogue_tag.category NOT IN ('set', 'book', 'theme')"]})
- related_tags = (tag for tag in related_tags if tag not in tags)
+ # get relevant books and their tags
+ objects = models.Book.tagged.with_all(tags).order_by()
+ l_tags = [book.book_tag() for book in objects]
+ # eliminate descendants
+ descendants_keys = [book.pk for book in models.Book.tagged.with_any(l_tags)]
+ if descendants_keys:
+ objects = objects.exclude(pk__in=descendants_keys)
+
+ # get related tags from `tag_counter` and `theme_counter`
+ related_counts = {}
+ tags_pks = [tag.pk for tag in tags]
+ for book in objects:
+ for tag_pk, value in itertools.chain(book.tag_counter.iteritems(), book.theme_counter.iteritems()):
+ if tag_pk in tags_pks:
+ continue
+ related_counts[tag_pk] = related_counts.get(tag_pk, 0) + value
+ related_tags = models.Tag.objects.filter(pk__in=related_counts.keys())
+ related_tags = [tag for tag in related_tags if tag not in tags]
+ for tag in related_tags:
+ tag.count = related_counts[tag.pk]
+