如何使用django-tastypie查询ToManyField的属性



编辑:这种方法确实有效,我有一个错字。感谢您@eran指出,固定在下面。

在控制台中,我可以这样做:

Performance.objects.filter(ticket_blocks__price__gt=200)

并获得价格高于 200 美元的门票块的表演。但是这个:

http://localhost:8000/api/v1/performance/?ticket_blocks__price__gt=200

给了我KeyError: u'price'.我做错了什么?

models.py

class TicketBlock(models.Model):
    name = models.CharField(max_length=100)
    price = models.DecimalField(max_digits=8, decimal_places=2)
class Performance(models.Model):
    start_time = models.DateTimeField(db_index=True)
    end_time = models.DateTimeField(default=None, blank=True, null=True)
    sold_out = models.BooleanField(default=False)
    # All performance have at least one ticket block
    ticket_blocks = models.ManyToManyField('TicketBlock')

api.py

class TicketBlockResource(ModelResource):
    class Meta:
        queryset = TicketBlock.objects.all()
        allowed_methods = ['get']
        resource_name = 'ticket-block'
        filtering = {
            'price': ALL
        }
class PerformanceResource(ModelResource):
    ticket_blocks = fields.ToManyField(TicketBlockResource, 'ticket_blocks', blank=True, null=True, full=True)
    class Meta:
        queryset = Performance.objects.all()
        allowed_methods = ['get']
        resource_name = 'performance'
        filtering = {
            'ticket_blocks': ALL_WITH_RELATIONS
        }

IT 应该可以工作,我认为您只是在定义中存在混淆并使用了错误的模型VenueType而不是TicketBlock

更改行:

queryset = VenueType.objects.all()

自:

TicketBlock.objects.all()

我认为它会解决你的问题。

最新更新