Django - objects.values() and prefetch_related() in same query

Viewed 5645

I have Book, Profile, Book_stat model as below. I am trying to minimize the fields from Book model and prefetch_related method to get the data from Book_stat model.

models.py

class Book(models.Model):
    title = models.CharField(max_length=200)
    image = models.FileField(upload_to="mp/", blank=True)

    def __str__(self):
        return self.title

class Profile(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE)
    full_name = models.CharField(max_length=150)

    def __str__(self):
        return self.full_name

class Book_stat(models.Model):
    user = models.ForeignKey(User)
    book = models.ForeignKey(Book)
    rating = models.DecimalField(max_digits=5, decimal_places=2, default=Decimal('0.00'))
    like = models.BooleanField(default=False)

    def __str__(self):
        return self.book.title + ' by: ' + self.user.profile.full_name  

views.py

def books(request):
    books = books = Book.objects.prefetch_related('book_stat_set').values('id','title', 'image')
    for book in books:
        for book_stat in book.book_stat_set.all(): # error: 'dict' object has no attribute 'book_stat_set'
            book.stats = book_stat
            pprint(vars(book_stat))
    return HttpResponse(books, content_type= 'json')

1) I would like to send the json response to front end as below
2) If possible i want to use book_stat_set.values('like', 'rating') instead of book_stat_set.all() so that i query for like, rating only

books = [
    {
        id: 1,
        title: 'some title1',
        image: 'image1.jpg',
        stats: {
            like: true,
            rating: 3.50
        }
    },
    {
        id: 2,
        title: 'some title2',
        image: 'image1.jpg',
        stats: {
            like: true,
            rating: 3.50
        }
    }
]
2 Answers
Related