Ok, so I've done some reading up on this but I'm still unsure how
exactly I can get around this. Right now it seems that I have two
options, I can either manually create my own ManyToMany relationship
table like so:
class Product(models.Model):
name = models.CharField(max_length=255)
class Purchase(models.Model):
date = models.DateTimeField(auto_now_add=True)
class PurchaseProducts(models.Model):
product = ForeignKey(Product)
purchase = ForeignKey(Purchase)
In this case, I would just add any additional fields/columns that I
would want to the relationship table. However, I'm thinking that this
would break some useful Django functionality because, as far as the
model is concerned, Django has no idea that there is a ManyToMany
relationship between the Product and Purchase classes... is this
correct?
If so, my second option would be to still use the standard Django
ManyToMany field like so:
class Product(models.Model):
name = models.CharField(max_length=255)
class Purchase(models.Model):
products = models.ManyToManyField(Product)
date = models.DateTimeField(auto_now_add=True)
and then create another class to hold the meta information related to
the Product + Purchase combination:
class PurchaseMeta(models.Model):
meta1 = CharField(max_length=100)
meta2 = CharField(max_length=100)
My question now is, how would I relate the PurchaseMeta class to the
ManyToMany table Django automagically creates? When I look at the SQL
that Django generates as the result of a ManyToMany field, it gives
the new class a primary key as well. Is there any way I can find out
what the time of the class would be? Since Django is OO, I'm assuming
that it automagically creates a new class for the ManyToMany
intermediary table, if I want to add meta information to this using a
custim table (PurchaseMeta) above, how would I go about linking it?
Thanks guys!
On Oct 11, 4:12 am, "Russell Keith-Magee" <[EMAIL PROTECTED]>
wrote:
> On 10/11/07, TopRamen <[EMAIL PROTECTED]> wrote:
>
>
>
> > Gentlemen, I'm new to the Django seen and am currently working on my
> > first application in it. In part of my model, I have a ManyToMany
> > relationship between the Purchase class and the Product class. The
> > ManyToMany relationship is called products and is in the Purchase
> > class. I'd like to add some additional columns/fields to the
> > automatically generated ManyToMany table. In this case, Django makes a
> > new table called <app>_purchase_products. I'd like to store some extra
> > info in this table such as a password for a download for example. Is
> > this possible in Django? I've combed the Model API and Google and
> > can't find an answer to this anywhere.
>
> There isn't anything explicitly in the API to support this, although
> it has been discussed many times. Search the archives (including
> django-developers) for 'm2m intermediate'.
>
> There is also a workaround solution, described
> here:http://www.djangoproject.com/documentation/models/m2m_intermediary/
>
> Yours,
> Russ Magee %-)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
