I want to filter movies, that fit only to selected genres, for example:
def get_queryset(self):
queryset = Movie.objects.all()
if 'genres' in self.request.GET:
queryset = queryset.filter(genre__in=self.request.GET.getlist('genres'))
return queryset
This filter shows movies that fit into at least one to filter, but I want to show movies that are fit all of the selected genress like 'comedy, horror, fantasy' and all of the selected genres must be in the movie genres How cat I do this?
Models:
class Genre(models.Model):
title = models.CharField('Title', max_length=100)
description = models.TextField('Description')
slug = models.SlugField(max_length=100, unique=True)
class Movie(models.Model):
title = models.CharField('Title', max_length=100)
tagline = models.CharField('Tagline', max_length=200, default='')
description = models.TextField('Description')
poster = models.ImageField('Poster', upload_to='movies/')
country = models.CharField('Country', max_length=50)
actors = models.ManyToManyField(
Actor, verbose_name='actors', related_name='film_actor'
)
genres = models.ManyToManyField(
Genre, verbose_name='genres', related_name='genres'
)
category = models.ForeignKey(
Category,
verbose_name='category',
related_name='category',
on_delete=models.SET_NULL,
null=True
)
slug = models.SlugField(max_length=100, unique=True)
