CODEWITHSUNDEEP
pythondjango
duy do
duy do

Reputation: 23

How to get fields of foreign key

In models.py:

class Comment(models.Model):
    item = models.ForeignKey(Item, on_delete=models.CASCADE, related_name='comments')
    author = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
    body = models.TextField()
    rating = models.FloatField(null=True)
    aggregate = models.FloatField(null=True)
    date = models.DateTimeField(auto_now_add=True)


class Item(models.Model):
    id_item = models.AutoField(primary_key='true')
    item_name = models.CharField(max_length=100, null=False)
    slug = models.SlugField(max_length=250, blank=True, null=True)
    item_description = models.TextField()
    item_img = models.ImageField(blank=True, null=True, upload_to="static/item/cover/")
    tags = TaggableManager()

In views.py:

def detail(request, slug_text):
    details = Item.objects.filter(slug=slug_text)
    if details.exists():
        reviews = Comment.objects.filter(item=slug_text)
        details = details.first()
        average = reviews.aggregate(Avg("rating"))["rating_avg"]
        average = round(average, 2)
        form = CommentForm()
        if request.method == "POST":
            form = CommentForm(request.POST, author=request.user, item=details)
            if form.is_valid():
                form.save()
                return HttpResponseRedirect(slug_text)
    else:
        return HttpResponse('<h1>Trang không tồn tại</h1>')
    return render(request, 'homepage/detail.html', {'detail': details, 'form': form, 'average': average})

What if I want to get the item.slug = slug_text field in here? 

reviews = Comment.objects.filter(item=slug_text)

Upvotes: 0

Views: 47

Answers (1)

Nkosikhona Carlos
Nkosikhona Carlos

Reputation: 117

You not far from it, to get data from a foreignkey you use double under score __ i.e: to get item slug use item__slug see below

reviews = Comment.objects.filter(item__slug=slug_text)

All the best.

Upvotes: 1

Related Questions