Hi all
Thanks in advance to whomever reads this :)
Is it possible in a django view, to take objects from 2 different models, which
are related one to the other through a ForeignKey (primary key of one model is
foreign key in the other model), make something similar to an SQL JOIN and have
the collection of these joined instances passed to the template through the
render_to_response shortcut? I need to do this specifically to show fields from
both models in the same template/view.
Here's a more detailed description of what I'm doing:
I have this view, where I collect objects from 2 different models and then I
construct a dictionary that I pass to the render_to_response shortcut in the
form of a python dictionary
The table/model "ItemPedido" has a foreign key to the model called "Consumibles"
This is my view:
def itempedidos(request, a_pedido_nro):
pedidos_available = Pedido.objects.get(id=a_pedido_nro)
items_available = ItemPedido.objects.filter(nro_pedido=a_pedido_nro)
#populate this dictionary with the corresponding Consumibles from the
foreign key we have at ItemPedido
consumibles_inthispedido = {}
for item in items_available:
myconsumible = Consumible.objects.get(id=item.id)
consumibles_inthispedido[item.item_id] = myconsumible #this is a
dictionary; key is the item_id, value is the "consumible" instance
mydict = {"pedidos_available":pedidos_available,
"items_available":consumibles_inthispedido}
return render_to_response('sidea/itempedidos.html', {'mydict': mydict})
Now what I'm trying to do is to iterate in the template (itempedidos.html)
through the dictionary. The thing is that what I get in the second key of the
dictionary is a collection of "Consumible" instances (namely
"items_available"), but I would also need to show some fields from the
"ItemPedido" instances that match through the corresponding foreignkey (note
again that ItemPedido has a foreignkey to Consumible)
This is the template I'm using to iterate through the dictionary I pass to it
in my view
{% if mydict.pedidos_available %}
<p>Nro Pedido: {{ mydict.pedidos_available.id }} - Mesa: {{
mydict.pedidos_available.mesa }}</p>
<ul>
{% if mydict.items_available %}
{% for item in mydict.items_available %}
<li><a href="{{ item.id }}" title="link">Item
nro: {{ item.id }}</a> -- Cant: {{ item.cantidad }} -- Desc: {{
item.descripcion }}</li>
{% endfor %}
{% else %}
<p>No hay items para este pedido.</p>
{% endif %}
</ul>
{% else %}
<p>El pedido no existe.</p>
{% endif %}
Is there a way that I can construct a new kind of object to be passed to the
template, so it would show *something similar to the sql join of fields from
both ItemPedido and Consumible models*?
As you can see in the template, I'm trying to access "item.cantidad" which is a
field from ItemPedido, but of course the collection of objects I'm passing to
the template is not ItemPedido objects but rather Consumible objects, that's
why the field "cantidad", defined in ItemPedido, is not there in my dictionary
(made of Consumible objects, where no "cantidad" field is defined).
These are the models:
class Pedido(models.Model):
mesa = models.IntegerField()
fecha_pedido = models.DateTimeField('date published')
pedido_cerrado = models.BooleanField()
def __unicode__(self):
return u'%s' % self.id
class Admin:
list_display = ('mesa', 'fecha_pedido', 'pedido_cerrado')
class ItemPedido(models.Model):
nro_pedido = models.ForeignKey(Pedido, edit_inline=models.TABULAR,
num_in_admin=4, core=True)
item_id = models.ForeignKey(Consumible, edit_inline=models.TABULAR,
num_in_admin=4, core=True)
cantidad = models.IntegerField()
def __unicode__(self):
return u'%s - %s' % (self.nro_pedido, self.item_id)
class Admin:
list_display = ('nro_pedido','item_id')
class Consumible(models.Model):
descripcion = models.CharField(max_length=200, core=True)
receta = models.TextField(blank=True)
precio = models.DecimalField(max_digits=6, decimal_places=2, core=True)
dcto_especial = models.DecimalField(max_digits=6, decimal_places=2)
pub_date = models.DateTimeField('date published')
foto = models.CharField(max_length=200, blank=True)
def __unicode__(self):
return self.descripcion
class Admin:
list_display = ('descripcion','tipo_consumible', 'receta', 'precio',
'dcto_especial')
Again thanks a lot for any help or reference
Best,
Mario
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
