Hi All,
I'm having trouble getting my head around how to set up my data entry
and queries, so that a listing/detail entry is categorised properly.
firstly, my models look like this:
class Category(models.Model):
name = models.CharField(max_length=100, unique=True)
slug = models.SlugField(max_length=100, unique=True)
parent = models.ForeignKey('self',blank=True,null=True)
...etc..
class Entry(models.Model):
categories = models.ManyToManyField(Category)
title = models.CharField(max_length=200)
description = models.TextField()
....etc..
I'm trying to achieve this:
Each entry can be linked to one or more categories
When browsing/searching categories, I want all child entries (from
next level down to lowest level) to be listed in one result.
I know this probably seems simple, and in django admin, when adding/
editing an Entry, it already includes the list-box, which allows me
to select multiple categories, however my problem is this:
The manually selected categories from the list-box are obviously the
only ones linked to the Entry, so when I someone browses/searches
listings by category, they will not automatically get the all child
Entries.
my view filter to get Entries looks like this:
entry_list=Entry.objects.filter(categories__slug=this_cat,....
theoretically I can think of two options:
1. At the time an Entry is added/edited - I need to have a routine
that rebuilds the many-many link table so that the Entry is linked
directly to each parent, of all selected categories. Although this
would cause other issues, like duplicated results on the search, how
to display all linked categories on the detail page, changing the
model to have a separate many-to-many link table etc..
2. The other option, sounds better to me, is the way the browse/search
query is built, when a user is browsing a top level category, I need
to somehow create a left/outer join or union so that all child
categories are linked with their Entries. But since I do not know the
depth of cateogories, this sounds like quite a complex bit of code to
dynamically build the sql, although it might be quite simple using
some kind of custom method in the model or something.. (but would this
query cause a performance issue.)
Anyway, as I get more and more questions as I write, so I'll leave it
at this for now.
If anyone can help me on this, would be greatly appreciated, thanks.
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
