這篇文章主要介紹了舉例講解Django中數據模型訪問外鍵值的方法,Django是最具人氣的Python web開發框架,需要的朋友可以參考下
先設置一個關于書本(book)的數據模型:
- from django.db import models
- class Publisher(models.Model):
- name = models.CharField(max_length=30)
- address = models.CharField(max_length=50)
- city = models.CharField(max_length=60)
- state_province = models.CharField(max_length=30)
- country = models.CharField(max_length=50)
- website = models.URLField()
- def __unicode__(self):
- return self.name
- class Author(models.Model):
- first_name = models.CharField(max_length=30)
- last_name = models.CharField(max_length=40)
- email = models.EmailField()
- def __unicode__(self):
- return u'%s %s' % (self.first_name, self.last_name)
- class Book(models.Model):
- title = models.CharField(max_length=100)
- authors = models.ManyToManyField(Author)
- publisher = models.ForeignKey(Publisher)
- publication_date = models.DateField()
- def __unicode__(self):
- return self.title
訪問外鍵(Foreign Key)值
當你獲取一個ForeignKey 字段時,你會得到相關的數據模型對象。 例如:
- >>> b = Book.objects.get(id=50)
- >>> b.publisher
- <Publisher: Apress Publishing>
- >>> b.publisher.website
- u'http://www.apress.com/'
對于用`` ForeignKey`` 來定義的關系來說,在關系的另一端也能反向的追溯回來,只不過由于不對稱性的關系而稍有不同。 通過一個`` publisher`` 對象,直接獲取 books ,用 publisher.book_set.all() ,如下:
- >>> p = Publisher.objects.get(name='Apress Publishing')
- >>> p.book_set.all()
- [<Book: The Django Book>, <Book: Dive Into Python>, ...]
實際上,book_set 只是一個 QuerySet,所以它可以像QuerySet一樣,能實現數據過濾和分切,例如:
- >>> p = Publisher.objects.get(name='Apress Publishing')
- >>> p.book_set.filter(name__icontains='django')
- [<Book: The Django Book>, <Book: Pro Django>]
屬性名稱book_set是由模型名稱的小寫(如book)加_set組成的。
新聞熱點
疑難解答