首页 > 解决方案 > 在 django 模型中获取 2 个相关模型的所有列

问题描述

我正在尝试将服务和供应商的所有字段作为查询集查看

class supplierMaster(models.Model):
    supplierId = models.AutoField(primary_key=True)
    supplierName = models.CharField(max_length=25)
    status = models.ForeignKey(statusMaster, on_delete=models.CASCADE)
    createdOn = models.DateTimeField(auto_now_add=True)
    def __str__(self):
        return self.supplierName

class servicesMaster(models.Model):
    serviceId = models.AutoField(primary_key=True)
    serviceName = models.CharField(max_length=50)
    supplierId = models.ForeignKey(supplierMaster, on_delete=models.CASCADE)
    status = models.ForeignKey(statusMaster, on_delete=models.CASCADE)
    createdOn = models.DateTimeField(auto_now_add=True)
    def __str__(self):
        return self.serviceName

视图.py:

def dashboard(request): 
    myservice = servicesMaster.objects.select_related('serviceName','supplierName').all() 

    return render(request, 'testing.html', { 'myservice': myservice, })

标签: djangodjango-models

解决方案


推荐阅读