Django talk: Re: Models and relationships

Monday, July 6, 2015

Re: Models and relationships

If you have at least one entry in contact with a valid location, then it should work:

from app.models import Contact
contact = Contact.all()[0]
print contact.locationid.locationname

2015-07-06 18:04 GMT+06:00 Chris Strasser <cstrasser11@gmail.com>:

Hi ,I am fairly new to Django and am struggling with models hope someone can sort me out. 


Models:
class Organization(models.Model):  #customer or vendor person or company      orgid = models.AutoField(db_column='OrgID', primary_key=True)        is_company = models.NullBooleanField(db_column='IsCompany', default =True)      organizationname = models.CharField(db_column='OrgName', max_length=75,blank=True, null=True)      main_phone = models.CharField(db_column='MainPhone',max_length=20, blank=True, null=True)   ...
...
   class Location(models.Model):      locationid = models.AutoField(db_column='LocationID', primary_key=True)        orgid = models.ForeignKey(Organization, db_column='OrgID')        locationname = models.CharField(db_column='LocationName', max_length=75, null=True)        address1 = models.CharField(db_column='Address1', max_length=200, blank=True, null=True)    ...
...

 class Contact(models.Model):       contactid = models.AutoField(db_column='ContactID', primary_key=True)        locationid = models.ForeignKey(Location, db_column='LocationID')        firstname = models.CharField(db_column='FirstName', max_length=50,blank=True, null=True)        lastname = models.CharField(db_column='LastName', max_length=50,blank=True, null=True)   ...
...

my problem is with reverse lookups (i think it is called) the docs say that i can access entries through blog.entry,(by lowercaseing the class)
it appears to me that i have the same setup with contact and location but i am getting errors ??


what I am trying to do is access a contacts address and organization at both the views level and the templates.(I would like to create a 
list of contacts, their company and their address ordered by contact name)

if someone would point me in the right direction it would be greatly appreciated. 

Thanks.