Try select_related()
On Fri, 25 Oct, 2019, 1:15 AM Gil Obradors, <gil.obrad...@gmail.com> wrote:
> What field of Category you want to get from post model ? name?
> maybe k.category instead of k.name? ( template)
>
> Or explain better :P
>
>
> Missatge de Benedict Uwazie <nonwa...@gmail.com> del dia dj., 24 d’oct.
> 2019 a les 21:19:
>
>> Thanks, but this did not help
>>
>> On Thursday, 24 October 2019 19:43:51 UTC+1, Gil Obradors wrote:
>>>
>>> Hi,
>>>
>>> I don't know if I understand what you mean...
>>>
>>> Is this good for you?
>>> from first_app.models import Author, Category, Post
>>> def post_from_cat(request, cat_id):
>>> b = Category.objects.get(pk=cat_id)
>>> return render(request, 'first_app/index.html', {'key': b})
>>>
>>>
>>> Missatge de Benedict Uwazie <nonw...@gmail.com> del dia dj., 24 d’oct.
>>> 2019 a les 18:41:
>>>
>>>> *Please I am new to using google groups. This post have been posted
>>>> earlier but the*
>>>> *code was not clear enough*
>>>>
>>>> I have an issue that I have been battling for a long time I
>>>> want to get data out from different related models. I have three
>>>> models. Category, Author, Post. The Category model categories my post
>>>> that are on the Post model. The issue I am having is this, when I
>>>> perform my loop
>>>> on my template (i.e html file) I can get data out from my Post model
>>>> but I can not
>>>> get data out from my Category model. Please I need someone to help me
>>>> out or tell me
>>>> what I am doing wrong.
>>>> below is my sample code for you to know what I am talking about.
>>>>
>>>>
>>>> class Category(models.Model):
>>>> name = models.CharField(max_length=100)
>>>> tagline = models.TextField()
>>>>
>>>> def __str__(self):
>>>> return self.name
>>>>
>>>> class Author(models.Model):
>>>> name = models.CharField(max_length=200)
>>>> email = models.EmailField()
>>>>
>>>> def __str__(self):
>>>> return self.name
>>>>
>>>> class Post(models.Model):
>>>> category = models.ForeignKey(Category, on_delete=models.CASCADE,
>>>> null=True, related_name='my_category')
>>>> headline = models.CharField(max_length=255)
>>>> body_text = models.TextField()
>>>> authors = models.ManyToManyField(Author)
>>>>
>>>>
>>>> def __str__(self):
>>>> return self.headline
>>>> on views.py
>>>> from first_app.models import Author, Category, Post
>>>> def post_from_cat(request, cat_id):
>>>> b = Category.objects.get(pk=cat_id)
>>>> result = b.my_category.all()
>>>> return render(request, 'first_app/index.html', {'key':result})
>>>>
>>>> on urls.py
>>>> from first_app import views
>>>>
>>>> urlpatterns = [
>>>> path('', views.home_app, name='home_app'),
>>>> path('post-cat/<int:cat_id>/', views.post_from_cat,
>>>> name='post_from_cat'),
>>>> ]
>>>>
>>>>
>>>>
>>>> on my template that (my html file)
>>>>
>>>> {% if key %}
>>>> {% for k in key %}
>>>> <p><strong>Category: </strong> {{ k.name }}</p>
>>>> <p><strong>Title</strong><br>{{ k.headline }}</p>
>>>> <p><strong>Body</strong><br>{{ k.body_text }}</p>
>>>> <hr>
>>>> {% endfor %}
>>>> {% else %}
>>>> <p>No data</p>
>>>> {% endif %}
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Django users" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to django...@googlegroups.com.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/django-users/493caf8b-d3c8-4033-99ab-e01f9eb4ed93%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/django-users/493caf8b-d3c8-4033-99ab-e01f9eb4ed93%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django-users+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/72e30f40-f636-45fb-88c1-6ac96c5c9c11%40googlegroups.com
>> <https://groups.google.com/d/msgid/django-users/72e30f40-f636-45fb-88c1-6ac96c5c9c11%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAK-JoTTSCEcaOr-uZvR_VXBgqRaS_xVO0h6htHsD7yMRSrGM%3DA%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAK-JoTTSCEcaOr-uZvR_VXBgqRaS_xVO0h6htHsD7yMRSrGM%3DA%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAPjsHcEGew9RzY9XCDPfNd1o2FNAm7sbKAXbzmWKwgHMJ4N99A%40mail.gmail.com.
