列举了江西的许多领域

2024-03-28 20:32:49 发布

您现在位置:Python中文网/ 问答频道 /正文

我的模特-

class tags(models.Model):
        tag_id = models.AutoField(primary_key = True)
        tname = models.CharField(max_length = 30, unique = True)
        def __unicode__(self):
            return u'%s %s' % (str(self.tag_id), self.tname)
        class Meta:
            ordering = ('tag_id',)

class food(models.Model):
    food_id = models.AutoField(primary_key = True)
    fname = models.CharField(max_length = 150, unique = True)
    image = models.ImageField(default = 'index.png')
    tag = models.ManyToManyField('tags')
    def __unicode__(self):
        return u'%s %s (%s)' % (str(self.food_id), self.fname, ", ".join(t.tname for t in self.tag.all()))
    class Meta:
        ordering = ('food_id','fname')

class price_list(models.Model):
    price_id = models.AutoField(primary_key = True)
    rate = models.PositiveSmallIntegerField(default = 0)
    h = models.ForeignKey('hotels')
    f = models.ForeignKey('food')
    def __unicode__(self):
        return u'%s %s %s' % (str(self.price_id), self.h.hname, self.f.fname)

我想查询给定酒店所有食物的所有标签。你知道吗

我试着这样做-

data['menu'] = list(price_list.objects.filter(h__hotel_id = post['hotel_id']).values('f__fname','f__tag__tname'))

但结果是-

{"menu": [{"f__tag__tname": "Veg", "f__fname": "Paneer Butter Masala"}, {"f__tag__tname": "Indian", "f__fname": "Paneer Butter Masala"}, {"f__tag__tname": "Continental", "f__fname": "Paneer Butter Masala"}]}

我希望我的结果是-

{"menu": [{"f__tag__tname": ["Veg", "Indian", "Continental"], "f__fname": "Paneer Butter Masala"}]}

我也尝试了prefetch_related,但无法获得所需的输出。你知道吗

感谢您的帮助。你知道吗

提前谢谢。你知道吗

编辑:

我这样修改了我的查询-

data = {}
            data['menu'] = list(price_list.objects.filter(h__hotel_id = post['hotel_id']).values('f__fname'))
            i = 0
            for d in data['menu']:
                data['menu'][i]['tag_list'] = list(food.objects.filter(food_id = d['f__food_id']).values('tag__tname')) 
                i = i+1
            return JsonResponse(data)

它给了我输出-

{"menu": [{"f__fname": "Paneer Butter Masala", "tag_list": [{"tag__tname": "Veg"}, {"tag__tname": "Indian"}, {"tag__tname": "Continental"}]}]}

这不是我想要的,但比以前的输出更好。但我认为我所做的查询效率很低。你知道吗

我如何优化我的查询,如何得到我想要的输出,即

{"menu": [{"f__tag__tname": ["Veg", "Indian", "Continental"], "f__fname": "Paneer Butter Masala"}]}

提前谢谢。你知道吗


Tags: selfidtruedatafoodmodelstagfname
1条回答
网友
1楼 · 发布于 2024-03-28 20:32:49

尝试这样的操作(使其成为模型的属性):

def get_tnames_fnames(self):
    return map(str, self.f.all().values('fname', 'tag__tname', flat=True))

另外,我会把你们模型的第一个字母大写。例如

class Tags(models.Model):
    . . .

class Food(models.Model):
    . . .

class PriceList(models.Model):
    . . .

相关问题 更多 >