Django restframework：带有两个模型字段的url过滤器

Question

我想设计一个url，如：

url(r'^theaters/(?P<area>.+)/(?P<title>.+)/$', TheaterAreaList.as_view(), name='theater-area'),

然后我就可以转到如下链接：

http://127.0.0.1:8000/theaters/north/moviename

但是title和area处于不同的模型中，具有许多关系：

你知道吗型号.py你知道吗

class Movie(models.Model):
    link = models.URLField()
    title = models.CharField(max_length=255, null=True)

class MovieTheater(models.Model):
    movietheater = models.ManyToManyField(Movie,null=True,blank=True,through="MovieShowtime")
    movie_theater = models.CharField(max_length=255, null=True)     
    city = models.CharField(max_length=255, null=True)     #east west north south

class MovieShowtime(models.Model):
    theater = models.ForeignKey( MovieTheater, null=True,blank=True,related_name = 'theater' )
    movie = models.ForeignKey( Movie, null=True,blank=True,related_name = 'movie' )
    time = models.TextField(null=True,blank=True)     

我的视图.py有错误QuerySet' object has no attribute 'movietheater_set' 视图.py地址：

class TheaterAreaList(generics.ListAPIView):
    serializer_class = TheaterSerializer

    def get_queryset(self):

        area = self.kwargs['city']
        title = self.kwargs['title']
        return MovieTheater.objects.filter(city=area).movietheater_set.filter(title=title)

请教我如何查询两个模型，非常感谢。你知道吗

Answer 1

_set只适用于对象，而不适用于过滤的查询集。你知道吗

试试这个：

MovieTheater.objects.filter(city=area, movietheater__movie__title=title)

这是relevant documentation