Dirk,
Thanks for your comment! I simplified my use case for the sake of
clarity, but in my actual application it does make sense to have
Dishes and Restaurants to be many-to-many. Does anyone have any
insight as to my original question? Can the choices of dish be
narrowed to only dishes at a particular Restaurant somehow using the
Admin class or other magic?
Wiley
On Jun 23, 1:13 am, "Dirk van Oosterbosch, IR labs"
<[EMAIL PROTECTED]> wrote:
> Hi Wiley,
>
> I would say your data model -as you describe it- makes more sense if
> Dishes has a foreign key to Restaurants. Because it seems a typical
> dish (say mc_burger) can only be ordered in one restaurant (mcD).
> Then you don't need the foreign key Restaurants in IndividualMeals.
>
> ... However, this is debatable. It might not be the best data model
> if you want to scale things up later on (like add more dishes). See,
> you have double dishes (mc_fries AND bk_fries). That is redundant (if
> the dishes are equal). So maybe Restaurants should have a many2many
> relation with Dishes. Then you can specify which dishes can be
> ordered from which Restaurants.
> On the other hand, when you want to extend the information about the
> dishes, (a dish might have a price or a volume), you'll run into
> problems there. ...
>
> HTH
> dirk
>
> On 22-jun-2007, at 13:24, Wiley wrote:
>
>
>
>
>
> > I'm a true novice programmer, brand new to django, but lovin' it so
> > far. I was wondering if there was any way to do something a little
> > tricky via the Admin classes that could help me not write a custom
> > view.
>
> > Basically I'd love to do all my data entry from the Admin interface,
> > but I need to filter a set of choices on one Admin input interface
> > based on a choice I make further up the form.
>
> > I live in a world with:
>
> > 2 restaurants (McDonalds and Burger King)
> > 4 menu items, the same type of food at each restaurant (mc_burger,
> > mc_fries, bk_burger, bk_fries)
>
> > Each time I eat at one of those restaurants I want to make a record of
> > the meal in my database. So I do the data entry through the django
> > Admin backend. If I select "Burger King" as the restaurant that I eat
> > my meal at, when it comes time to select the dishes I ate, I really
> > only want to see bk_fries and bk_burger, cuz I ate at BK and not
> > mickey D's.
>
> > Can this be done just using the Admin class in models.py?
>
> > Here's the sample code that I'm working with in model.py:
>
> > class Restaurant(models.Model):
> > def __str__(self):
> > return self.name
>
> > name = models.CharField('Restaurant Name', maxlength=200, blank=True)
> > class Admin:
> > fields = (
> > ('Restaurant Name' , {'fields': ('name',)}),
> > )
> > pass
>
> > class Dishes(models.Model)
> > def __str__(self):
> > return self.name
>
> > name = models.CharField('Restaurant Name', maxlength=200, blank=True)
> > class Admin:
> > fields = (
> > ('Dish Name' , {'fields': ('name',)}),
> > )
> > pass
>
> > class IndividualMeal(models.Model):
> > def __str__(self):
> > return self.name
>
> > restaurant_name = models.ForeignKey(Restaurant,
> > verbose_name="restaurant")
> > date_of_visit = models.DateTimeField('date of visit')
> > dishes = models.ManyToManyField(Dish, verbose_name="individual
> > dishes")
> > class Admin:
> > fields = (
> > ('Restaurant Name' , {'fields': ('restaurant_name',)}),
> > ('Date of Visit', {'fields': ('date_of_visit',)}),
> > ('Dishes', {'fields': ('dishes',)}),
> > )
> > pass
>
> -----------------------------
> Dirk van Oosterbosch
> de Wittenstraat 225
> 1052 AT Amsterdam
> the Netherlands
>
> http://labs.ixopusada.com
> -----------------------------
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
