Django：如何从两个模型中获取数据并在模板中显示？

Question

有两种型号Product和ProductImage我的代码如下：

models.py

class Product(models.Model):
   product_name = models.CharField(max_length=100)
   product_weight = models.CharField(max_length=30)

models.py

from django.db.models.signals import post_save, pre_save
from django.dispatch import receiver

_UNSAVED_IMAGEFIELD = 'unsaved_imagefield'

def upload_path_handler(instance, filename):
    import os.path
    fn, ext = os.path.splitext(filename)
    return "images/{id}/{fname}".format(id=instance.product_id, 
    fname=filename)

class ProductImage(models.Model):
   product = models.ForeignKey(Product, on_delete=models.DO_NOTHING)
   image = models.ImageField(upload_to=upload_path_handler, blank=True)

@receiver(pre_save, sender=ProductImage)
def skip_saving_file(sender, instance, **kwargs):
    if not instance.pk and not hasattr(instance, _UNSAVED_IMAGEFIELD):
        setattr(instance, _UNSAVED_IMAGEFIELD, instance.image)
        instance.image = None

@receiver(post_save, sender=ProductImage)
def update_file_url(sender, instance, created, **kwargs):
    if created and hasattr(instance, _UNSAVED_IMAGEFIELD):
        instance.image = getattr(instance, _UNSAVED_IMAGEFIELD)
        instance.save()

views.py

def products(request):
    products = Product.objects.all()
    context = {
        'products' : products
    }

    return render(request, 'products/products.html', context)

products.html

{% if products %}
        {% for product in produucts %}
            <div class="col-sm-5 col-lg-5">
                <div class="equipmentbox">
                    <div class="equipmentimgbox"> <img src="{{"**IMAGE URL HERE**"}}"> </div>
                    <a href="">{{ product.product_name }}</a>
                </div>
            </div>
        {% endfor %}
    {% else %}
        <div class="col-md-12">
            <p>No Products Available</p>
        </div>
{% endif %}

Product表包含产品详细信息，ProductImage包含与特定产品相关的图像。我有一个列表页面，我想在其中显示ProductTitle和图像。如何从另一个表中获取图像并将其与产品标题一起显示

提前谢谢

Answer 1

以下是解决方案：

{% if products %}
        {% for product in produucts %}
            <div class="col-sm-5 col-lg-5">
                <div class="equipmentbox">
                    <div class="equipmentimgbox"> <img src="{{"product.productimage_set.all.0.image_main.url"}}"> </div>
                    <a href="">{{ product.product_name }}</a>
                </div>
            </div>
        {% endfor %}
    {% else %}
        <div class="col-md-12">
            <p>No Products Available</p>
        </div>
{% endif %}

查看此问题以了解更多详细信息。 Django: How to get data connected by ForeignKey via Template?