I have products within categories. The url for a product is /store/
category-slug/product-slug. My question is about the best way to get
the url for this product while looping through a product listing
page. My view simply defines a context variable called products,
assigned to the results of a .filter() call.
Given these models:
def Category(models.Model):
name = models.CharField(max_length=255)
slug = models.SlugField()
def Product(models.Model):
name = models.CharField(max_length=255)
slug = models.SlugField()
category = models.ForeignKey(Category)
def get_absolute_url(self):
category_slug = Category.objects.get(id=self.category_id).slug
return "/%s/%s" % (category_slug, self.slug)
You can see that calling get_absolute_url() while looping through a
list of products in a template will require an extra query to be sent
to the server for each iteration of a product, which is clearly not
ideal. My other option to use .values() in the view to select out
the category slug along with all the other columns on the product,
but this doesn't seem ideal either.
I guess I'm so used to things being unbelievably elegant in django,
I'm trying to convince myself there must be a better way! Is there?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
