How to return multiple objects related with ForeignKey in Django

Question

I have the following in my models.py:

class HostData(models.Model):
  Manager = models.ForeignKey(Managers)
  Host = models.CharField(max_length=50, null=True)
  HostStatus = models.CharField(max_length=200, null=True)
  Cpu = models.PositiveIntegerField(max_length=10, null=True)
  Disk = models.FloatField(null=True)

I would like to return the query for objects related to a certain "Manager". The problem is that the user may add/delete as many managers as he wants. So my initial thought was to have in my views.py something like this:

def get_data(request):
 for server in Managers.objects.all():
    host_data = HostData.objects.filter(Manager=server)
    # Lost after this :(
 return render_to_response('mypage.html', {'first_set': host_data1, 'second_set': host_data2})

So, how can I return multiple objects? Like if the user adds another "Manager" I'll get a third set in my views.py.

Seth · Accepted Answer · 2010-10-01 04:25:43Z

12

You can query on related objects like so:

manager = Managers.objects.get(pk=1) # identify which manager you want
manager.hostdata_set.all()  # retrieve all related HostData objects

In your template, you can also just access the hostdata_set directly:

{% for manager in managers %}
    {% for data in manager.hostdata_set.all %}
      do something with {{ data }}
    {% endfor %}
{% endfor %}

I believe this is what you're asking for.

Incidentally, if your Managers model stores data about a single "Manager", you may find it useful to change it's name to the singular Manager.

edited Oct 1, 2010 at 4:25

answered Oct 1, 2010 at 0:39

Seth

46.8k10 gold badges87 silver badges123 bronze badges

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

2 Comments

Ruben Quinones Over a year ago

Thanks! this is what I was looking for. Just a note: Parentheses are not used in the template tags, so in the template it should be: manager.hostdata_set.all

meder omuraliev Over a year ago

Funny.. I ended up needing the exact same thing just now. Thanks Seth.

Avid Coder · Accepted Answer · 2012-01-01 17:04:26Z

2

It seems that you want to ask the HostData to return all objects that are related to a certain Manager. If so, then you should know one unique piece of information about the certain Manager you are looking for.

For the sake of argument, let's assume the Manager "id" is used as a primary key and therefore unique and we are looking for a id = 5.

id = 5
hostdata = HostData.objects.filter(Manager__id=id)

edited Jan 1, 2012 at 17:04

user212218

answered Nov 17, 2010 at 15:42

Avid Coder

18.5k14 gold badges65 silver badges70 bronze badges

Comments

meder omuraliev · Accepted Answer · 2010-10-01 00:36:25Z

0

I think (maybe??) you are looking for something like...

managers = Managers.objects.all()
host_data = HostData.objects.filter( managers__in=managers )

Then you can do looping inside the view?

I'm not exactly so sure this will work but let me know if it helps.

edited Oct 1, 2010 at 0:36

answered Oct 1, 2010 at 0:13

meder omuraliev

187k76 gold badges402 silver badges443 bronze badges

Comments

marcelor · Accepted Answer · 2010-10-01 00:48:17Z

0

Just add host data sets dinamically to the template context:

def get_data(request):
 host_data_sets = []

 for server in Managers.objects.all():
    host_data_set = HostData.objects.filter(Manager=server)
    host_data_sets.append(host_data_set)

 return render_to_response('mypage.html', {'host_data_sets': host_data_sets})

Then in your template you can iterate over the data sets:

{% for host_data_set in host_data_sets %}
  <!-- do something with host_data_set -->
{% endfor %}

answered Oct 1, 2010 at 0:48

marcelor

923 bronze badges

Collectives™ on Stack Overflow

How to return multiple objects related with ForeignKey in Django

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related