我有這個模型：class Image(models.Model): image_name=models.CharField(max_length=30) image=models.ImageField(upload_to='images',width_field='image_width', height_field='image_height',) image_width=models.PositiveIntegerField(null=True, blank=True, editable=False) image_height=models.PositiveIntegerField(null=True, blank=True, editable=False) image_size=models.IntegerField(null=True, blank=True,editable=False)視圖是這樣的：class ImageViewSet(viewsets.ModelViewSet): queryset = Image.objects.all() serializer_class = ImageSerializer filter_backends = (DjangoFilterBackend, OrderingFilter,) filter_fields = ('image_name',) ordering_fields = ('id','image_name,)我能夠保存具有所有這些屬性的圖像。我想要這樣的查詢來返回高度大于 100 且小于 300 的所有圖像：GET /images/?minheight=100&maxheight=300如何在 Django 中實現(xiàn)這一點？我收到 500 服務(wù)器錯誤 如果我嘗試在 minheight 為空的情況下啟動 api GET /images/?minheight=
2 回答
慕雪6442864
TA貢獻(xiàn)1812條經(jīng)驗 獲得超5個贊
您必須根據(jù)GET參數(shù)手動過濾查詢集。
class ImageViewSet(viewsets.ModelViewSet):
queryset = Image.objects.all()
serializer_class = ImageSerializer
filter_backends = (DjangoFilterBackend, OrderingFilter,)
filter_fields = ('image_name',)
ordering_fields = ('id','image_name,')
def get_queryset(self):
minheight = self.request.GET.get('minheight')
maxheight = self.request.GET.get('maxheight')
return self.queryset.filter(image_height__gte=minheight, image_height__lt=maxheight)
繁星點點滴滴
TA貢獻(xiàn)1803條經(jīng)驗 獲得超3個贊
一般來說，查詢看起來像：
qs = models.Image.objects.filter(image_height__gt=100, image_height__lt=300)
這使用gt和lt字段查找。還有大于或等于 ( gte) 和小于或等于 ( lte) 的變體。
class ImageViewSet(viewsets.ModelViewSet):
serializer_class = ImageSerializer
filter_backends = (DjangoFilterBackend, OrderingFilter,)
filter_fields = ('image_name',)
ordering_fields = ('id','image_name',)
def get_queryset(self):
queryset = Image.objects.all()
minheight = self.request.query_params.get('minheight', '')
maxheight = self.request.query_params.get('maxheight', '')
if(minheight and maxheight):
queryset = queryset.filter(image_height__gt=minheight,
image_height__lt=maxheight)
return queryset
添加回答
舉報
0/150
提交
取消