CODEWITHSUNDEEP
django
dhooonk
dhooonk

Reputation: 2615

How to print foreignkey Model relation?

If in My model, Moneybook have a many moneylogs.

so, I design a model

Moneybook/models.py

   name = models.CharField(max_length=30, default="행복한 여행!")
    owner = models.ForeignKey(
        user_models.User, on_delete=models.CASCADE, related_name="owner")
    companion = models.ManyToManyField(
        user_models.User, related_name="companion", blank=True)
    country = CountryField()
    location = models.CharField(max_length=50, blank=True)
    start_date = models.DateTimeField(default=NOW)
    end_date = models.DateTimeField(default=NOW)

Moneylog/models.py

moneybook = models.ForeignKey(
    moneybook_models.Moneybook, on_delete=models.CASCADE, related_name="moneybooks")
payer = models.ForeignKey(
    user_models.User, on_delete=models.CASCADE, related_name="payer")
dutch_payer = models.ManyToManyField(
    user_models.User, related_name="dutch_payer")
price = models.IntegerField()
category = models.CharField(max_length=10)
memo = models.TextField()

If i want to load all the moneylogs in the each belonging moneybook. how can i load it?

I guess...

def moneybook_detail(request, pk):
    moneylogs=moneylog.filter(moneylog.moneybook.id=request.moneybook.id)
    return render(request, "moneybooks/detail.html")

but error occured.

moneylogs = moneylog.filter(request.moneybook.id=request.moneybook.id)
SyntaxError: keyword can't be an expression

Upvotes: 0

Views: 50

Answers (2)

Radwan Abu-Odeh
Radwan Abu-Odeh

Reputation: 2045

You can either query the Moneylog table with the following query by using the double underscore __ to filter based on referenced object fields.

moneylogs = MoneyLog.filter(moneybook__id=<<<MoneyBookID_GOES_HERE>>>)

Or by using the internal ReverseManyToOneManager in Django

just by using

moneybook = MoneyBook.objects.get(pk=<<<<MoneyBookID_GOES_HERE>>>>)
moneylogs = moneybook.moneylog_set.all() # all() to get all money logs
# You can do filter(...) on it too to filter the moneylogs too.

this will return all money logs related to the money book.

Upvotes: 2

Lord Elrond
Lord Elrond

Reputation: 16002

In general, you have to use double underscore __ to reference foreign key columns in filters:

def moneybook_detail(request, pk):
    moneylogs=moneylog.filter(moneybook__id=request.moneybook.id)
    return render(request, "moneybooks/detail.html")

Upvotes: 1

Related Questions