Skip to main content
 首页 » 编程设计

python之来自内联模型的循环查询集

2025年04月02日14开发

有一个模型和一个内联模型.. 我需要创建一个查询集,它从内联模型中检索数据并在模板中返回一个 for 循环。看起来我的代码无法正常工作......有人可以帮忙吗?

class Account(models.Model): 
    uuid = ShortUUIDField(unique=True) 
    name = models.CharField(max_length=80) 
    desc = models.TextField(blank=True) 
    address_one = models.CharField(max_length=100) 
 
    def __str__(self): 
        return u"%s" % self.name 
 
class Rates(models.Model): 
     airline = models.CharField(max_length=30, blank=True, verbose_name= 'AIRLINE') 
     dest = models.CharField(max_length=3,blank=True,verbose_name= 'DEST') 
 
     name= models.ForeignKey (Account, default = False, related_name="rates") 
         def __str__(self): 
        return self.airline 
 
My for loop should retrieve all rates in case account name is XXX 
 
def rates_acc(request, account): 
    account = Account.objects.get(name = xxx) 
    rates = [x for x in account.rates.all()] 
    context = { 
 
        'rates': Account.objects.filter (name__name__icontains = 'xxx'), 
       } 
    return render(request,'accounts/account.html',context) 

请您参考如下方法:

My for loop should retrieve all rates in case account name is XXX

然后这个:

'rates': Account.objects.filter(name__name__icontains='xxx)  

应该是这样

'rates': Rates.objects.filter(name__name='XXX')  

或者,如果您想获取帐户名称包含 XXX 的所有费率

'rates': Rates.objects.filter(name__name__icontains='XXX')