主页 / 问题 / 1491463
Accepted
Turchik
Asked:2023-01-31 02:56:04 +0000 UTC2023-01-31 02:56:04 +0000 UTC

Django 从另一个外键模型中获取数据

  • 772

帮助我了解如何从rgb模型中获取rgb_name数据，现在我只得到rgb_numb

模型.py

class Rgb(models.Model):
    rgb_numb = models.CharField('Номер', max_length=10)
    rgb_name = models.CharField('Наименование', max_length=500)
    rgb_mod = models.CharField('Наименование', max_length=500)

    def __str__(self):
        return self.rgb_numb
  
class Reestr_db(models.Model):
    id_numb = models.CharField('Номер протокола', max_length=10, blank=True)
    rgb_numb = models.ForeignKey(rgb, on_delete=models.PROTECT, related_name="result_rgb_numb", verbose_name="Номер")
    rgb_name = models.ForeignKey(rgb, on_delete=models.PROTECT, related_name="result_rgb_name", verbose_name="Наименование")

视图.py

def reestr(request):
    bazar = rgb.objects.all()
    baza = reestr_db.objects.order_by('id_numb')
    datar = {
        'baza': baza,
        'bazar': bazar
    }
    return render(request, 'main/reestr.html', datar)

注册.html

  {% for el in baza %}
        <tr>
            <td>{{ el.result_rgb_numb.rgb_mod }}</td>
            <td>{{ el.result_rgb_name.rgb_name }}</td>
django-model

2 个回答

  1. Best Answer

    我想你打算做这样的事情：

    class RGB(models.Model):
    rgb_numb = models.CharField('Номер', max_length=10)
    rgb_name = models.CharField('Наименование', max_length=500)
    rgb_mod = models.CharField('Наименование', max_length=500)

    def __str__(self):
        return self.rgb_numb
  
class ReestrDB(models.Model):
    id_numb = models.CharField('Номер протокола', max_length=10, blank=True)
    rgb = models.ForeignKey(
        rgb, on_delete=models.PROTECT,
        related_name="result_rgb",
        verbose_name="Номер")

    然后在模板中：

      {% for el in baza %}
        <tr>
            <td>{{ el.rgb.rgb_mod }}</td>
            <td>{{ el.rgb.rgb_name }}</td>
    • 1

  2. related_name将从主表开始工作！您在变量的上下文中犯了错误，您应该使用bazar，而不是baza。我baza不result_rgb_numb和result_rgb_name

      {% for el in bazar %}
        <tr>
            <td>{{ el.result_rgb_numb.rgb_mod }}</td>
            <td>{{ el.result_rgb_name.rgb_name }}</td>
    • -1

相关问题