Django Left Outer Join

20 views
Skip to first unread message

sebasti...@gmail.com

unread,
Apr 25, 2023, 4:41:12 AM4/25/23
to Django users
Hello Friends,

i have in models.py following:

class Money(Standard_Model_Mixin):
    title = models.CharField(default="", max_length=120, blank=True, null=True)
    amount = models.DecimalField(max_digits=6, decimal_places=2, blank=False, null=False)

class Moneyreport(Standard_Model_Mixin,Mayan_DMS_Mixin):
    date = models.DateField (default=now, blank=False, null=False)


class Moneyreport_Line(Standard_Model_Mixin):
    moneyreport_link = models.ForeignKey(Moneyreport,default='', blank=False, null=False, on_delete=models.CASCADE, related_name="moneyreport_link")
    money_link = models.ForeignKey(Money, on_delete=models.CASCADE,default='', blank=False, null=False, related_name="money_link")
    quantity = models.PositiveIntegerField(default=0, blank=False, null=False)

Now i have in Money a entry like:

(id,title,amount) Values ((1,"50 $","50"),(2,"100 $","100"))

in Moneyreport:

(id,date) VALUES (1,'25.04.2023')

and Moneyreport_Line:

('moneyreport_link','money_link','quantity') VALUES ((1,1,3))

Now i want i left outer join so i get a table like:

|money_link.title|quantity|
|50 $                    |               |
|100 $                  |3            |

In SQL i would make a left join like:

SELECT Money.title,ml.quantity FROM Moneyreport_Line as ml LEFT OUTER JOIN Money ON Money.id = ml.money_link   

How i make this in django without raw query?

Regards                      


Reply all
Reply to author
Forward
0 new messages