from django.db.models import Count, Avg, Q, F, Prefetch
from django.db.models.functions import TruncMonth
 
class BookManager(models.Manager):
    def get_published_with_authors(self):
        return self.get_queryset().filter(
            is_published=True
        ).select_related('author').prefetch_related(
            Prefetch('collaborators', queryset=Author.objects.only('id', 'name'))
        )
 
    def monthly_publication_stats(self):
        return self.get_queryset().filter(
            is_published=True
        ).annotate(
            month=TruncMonth('published_date')
        ).values('month').annotate(
            book_count=Count('id'),
            avg_rating=Avg('rating')
        ).order_by('-month')
 
    def search_books(self, query, min_rating=None):
        filters = Q(title__icontains=query) | Q(description__icontains=query)
        if min_rating:
            filters &= Q(rating__gte=min_rating)
        return self.filter(filters)
 
# Usage
books = Book.objects.search_books('python', min_rating=4.0)
top_rated = books.order_by('-rating')[:5]