django get values from a related model (foreignkey)

Question

In home (views.py) how to display a list of all exercises (name and repetitions) linked to the same user Card?

models.py

class Card(models.Model):
    user = models.OneToOneField(User)
    trainer = models.ForeignKey(User, related_name='trainer')
    def __unicode__(self):
        return u'%s' % (self.id)




class Exercise(models.Model):
    card = models.ForeignKey(Card)
    name = models.CharField(max_length=50)
    repetitions = models.IntegerField(default=0, blank=True, null=True)

    def __unicode__(self):
        return u'%s' % (self.name)

views.py

from django.http import HttpResponse
from django.contrib.auth.decorators import login_required
from cards.models import Card, Exercise

@login_required
def home(request):
    user = request.user.get_full_name()      
    return HttpResponse("Welcome %s This is your home." % (user))

catherine · Accepted Answer · 2013-03-31 09:55:05Z

4

I never give up and finally I fix it. I tried it and it works.

@login_required
def home(request):
    user = request.user.get_full_name() 

    exercises = Exercise.object.filter(card__user=request.user)

    html = []
    for k in exercises:
        html.append('<tr><td>%s - %s</td></tr>' % (k.name, k.repetitions))
    return HttpResponse('Welcome %s This is your home.<br/><table>%s</table>' % (user, '\n'.join(html)))

edited Mar 31, 2013 at 9:55

answered Mar 30, 2013 at 9:11

catherine

22.8k15 gold badges64 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

avafab Over a year ago

I used it but I get this: [, , ] what does it means? (note that my Exercise model contains other fields not only name and repetitions)

avafab Over a year ago

yes I should have because I put some using admin interface. Anyway how can I check if I have exercises data there?

avafab Over a year ago

I get this: Welcome Fabrizio Avantaggiato This is your home. [, , ] (ops you changed the response wait alittle bit) I use HttpResponse because from the moment I'm learning the django/python side, I want to understand that first, I will concentrate on rendering a template after.

avafab Over a year ago

ok I get this: Welcome Fabrizio Avantaggiato This is your home. [{'repetitions': 30, 'name': u'bicipiti'}, {'repetitions': 10, 'name': u'tricipiti'}, {'repetitions': 0, 'name': u'panca'}] now how to isolate each value and display that in a list (without all that brackets)? is render_to_response needed?

avafab Over a year ago

can we use render instead? how to use it?

|

Collectives™ on Stack Overflow

django get values from a related model (foreignkey)

models.py

views.py

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

models.py

views.py

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related