Как использовать "Order" с prefetch_related для одновременного присоединения значений других таблиц?

class Order(models.Model):
    user = models.ForeignKey(Account, on_delete=models.DO_NOTHING, related_name='orders')

class Invoice(models.Model):
    order = models.ForeignKey(Order, on_delete=models.CASCADE, related_name='invoices')

class Flight(models.Model):
    order = models.ForeignKey(Order, on_delete=models.CASCADE, related_name='flights')

class Hotel(models.Model):
    order = models.ForeignKey(Order, on_delete=models.CASCADE, related_name='hotels')


===================================================================
iqs = Invoice.objects.filter(order_id=pk)
prefetch_invoices = Prefetch('invoices', queryset=iqs, to_attr='invoices')

fqs = Flight.objects.filter(order_id=pk)
prefetch_flights = Prefetch('flights', queryset=fqs, to_attr='flights')
        
hqs = Hotel.objects.filter(order_id=pk)
prefetch_hotels = Prefetch('hotels', queryset=hqs, to_attr='hotels')
        
order = Orders.objects.prefetch_related(prefetch_invoices, prefetch_flights, prefetch_hotels).get(pk=pk)

Я пытаюсь использовать prefetch_related для объединения трех таблиц одновременно. *** Я ПРОБОВАЛ ВЫШЕПРИВЕДЕННЫЙ КОД, НО ОН НЕ РАБОТАЕТ ***

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