django model relation definition

Posted by Laurent Luce on Stack Overflow See other posts from Stack Overflow or by Laurent Luce
Published on 2010-05-05T00:47:08Z Indexed on 2010/05/05 0:48 UTC
Read the original article Hit count: 318

Filed under:

django-models

|

foreign-key

|

relations

Hello,

Let say I have 3 models: A, B and C with the following relations.

A can have many B and many C.

B can have many C

Is the following correct:

class A(models.Model):
  ...

class B(models.Model):
  ...
  a = ForeignKey(A)

class C(models.Model):
  ...
  a = ForeignKey(A)
  b = ForeignKey(B)

© Stack Overflow or respective owner

Related posts about django-models

how to import csv data into django models

as seen on Stack Overflow - Search for 'Stack Overflow'
i have some csv data and i want to export into django models the example of csv data 1;"02-01-101101";"Worm Gear HRF 50";"Ratio 1 : 10";"input shaft, output shaft, direction A, color dark green"; 2;"02-01-101102";"Worm Gear HRF 50";"Ratio 1 : 20";"input shaft, output shaft, direction A, color dark… >>> More
Subclassed django models with integrated querysets

as seen on Stack Overflow - Search for 'Stack Overflow'
Like in this question, except I want to be able to have querysets that return a mixed body of objects: >>> Product.objects.all() [<SimpleProduct: ...>, <OtherProduct: ...>, <BlueProduct: ...>, ...] I figured out that I can't just set Product.Meta.abstract to true or otherwise… >>> More
List display names from django models

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an object: POP_CULTURE_TYPES = ( ('SG','Song'), ('MV', 'Movie'), ('GM', 'Game'), ('TV', 'TV'), ) class Pop_Culture(models.Model): name = models.CharField(max_length=30, unique=True) type = models.CharField(max_length=2, choices = POP_CULTURE_TYPES, blank=True,… >>> More
Best way to re-use the same django models and admin for multiple apps

as seen on Stack Overflow - Search for 'Stack Overflow'
Given a reference app ( called guide), how can I create additional apps that will reuse the same model/admin/views than guide - the motivation behind is to be able to individually control each subapp. guide guideApp1 exact same models/admin/views than guide guideApp2 exact same models/admin/views… >>> More
Generate unique hashes for django models

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to use unique hashes for each model rather than ids. I implemented the following function to use it across the board easily. import random,hashlib from base64 import urlsafe_b64encode def set_unique_random_value(model_object,field_name='hash_uuid',length=5,use_sha=True,urlencode=False): … >>> More

Related posts about foreign-key

Easy way to observe user activity - how improve my database structure.

as seen on Stack Overflow - Search for 'Stack Overflow'
Welcome, I need some advise to improve perfomence my web application. In the begin I had this structure of database: USER -id (Primary Key) -name -password -email .... PROFILE -user Primary Key, Foreign Key (USER) -birthday -region -photoFile ... … >>> More
Using SET NULL and SET DEFAULT with Foreign Key Constraints

as seen on SQL Team - Search for 'SQL Team'
Cascading Updates and Deletes, introduced with SQL Server 2000, were such an important, crucial feature that it is hard to imagine providing referential integrity without them. One of the new features in SQL Server 2005 that hasn't gotten a lot of press from what I've read is the new options for… >>> More
recursive delete trigger and ON DELETE CASCADE contraints are not deleting everything

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a very simple datamodel that represents a tree structure: The RootEntity is the root of such a tree, it can contain children of type ContainerEntity and of type AtomEntity. The type ContainerEntity again can contain children of type ContainerEntity and of type AtomEntity but can not contain… >>> More
EF4 generates invalid script

as seen on Stack Overflow - Search for 'Stack Overflow'
When I right-click in a .EDMX file and click Generate Database From Model, the resulting script is obviously wrong because of the table names. What it generates is the following script. Note the table names in the DROP TABLE part versus the CREATE TABLE part. Why is this inconsistent? This is obviously… >>> More
ON DELETE RESTRICT Causing Error 150

as seen on Stack Overflow - Search for 'Stack Overflow'
CREATE TABLE project ( id INTEGER NOT NULL AUTO_INCREMENT, created_at DATETIME NOT NULL, name VARCHAR(75) NOT NULL, description LONGTEXT NOT NULL, is_active TINYINT NOT NULL DEFAULT '1', PRIMARY KEY (id), INDEX(name, created_at) ) ENGINE = INNODB; CREATE TABLE role ( … >>> More