[Answer]-Django relationship query

by

1👍

✅

So basically what you want is all information for the invoice and associated contact for the invoice having the id 5; to do this:

# Fetch the invoice with id = 5
invoice = Invoice.objects.get(id=5)

Now, to fetch information about the related contact, simply “follow” the foreign key:

print(invoice.contact.first_name)
print(invoice.contact.last_name)
👤Burhan Khalid

2👍

you would rather set your models in this way: (Contact first, then invoice..)

class Contact(models.Model):
  first_name = models.CharField(max_length=30)
  last_name = models.CharField(max_length=30)
  address = models.CharField(max_length=30)

class Invoice(models.Model):
  contact = models.ForeignKey(Contact, related_name="contact_invoice")
  dateCreated =  models.DateTimeField(auto_now_add=True)
  jobName = models.CharField(max_length=30)
  jobAddress = models.CharField(max_length=30, blank=True)

then this query: 

contact = Contact.objects.get(id=someid)#just to get first contact object

contact_address = contact.address
contact_firstname = contact.first_name
contact_lastname = contact.last_name
invoice_of_this_contact = contact.contact_invoice.get(id=5)
👤doniyor

-2👍

Contact.invoice_set.filter(id=5)
👤Andrew Luo

Leave a comment