Как загрузить 2 кверисета одним запросом в django

class Order(models.Model):
    ID = models.AutoField(primary_key=True)
    product = models.ForeignKey(Products,
                                on_delete=models.CASCADE)
    customer = models.ForeignKey(Customer,
                                 on_delete=models.CASCADE)    Items = 
    models.ManyToManyField('OrderItems')

    def placeOrder(self):
        self.save()

    @staticmethod
    def get_orders_by_customer(customer_id):
        return Order.objects.filter(customer=customer_id).order_by('-date')


    def __str__(self):        
        return self.product.name + ' / ' + self.customer.email

class OrderItems(models.Model):
    ID = models.AutoField(primary_key=True)
    Item = models.ForeignKey(Products, on_delete=models.DO_NOTHING)
    Quantity = models.IntegerField('Quantity')
    Price = models.DecimalField('Price', max_digits=10, decimal_places=2)
    OrderNo = models.ForeignKey(Order, on_delete=models.DO_NOTHING)

    def __str__(self):
        return str(self.ID)

Как загрузить заказы вместе с их OrderItems в одном запросе

Вернуться на верх