正向查找与反向查找原理

两表之间的数据(Book与Publisher)

正向查找(查询第一本书的所在出版社是什么)

import osif __name__ == '__main__': #加载Django项目的配置信息 os.environ.setdefault("DJANGO_SETTINGS_MODULE","testinclude.settings") #导入Django,并启动Django项目 import django django.setup() from ormtest import models #正向查询(查找书的类型对象,然后通过外键关联,在出版社列中查出那家出版社) book_obj = models.Book.objects.first() book_obj_publisher = book_obj.publisher.name print("书名:",book_obj,"出版社为:",book_obj_publisher)反向查询(查询第一个版社下的所有书籍)

#反向查询 publisher_obj = models.Publisher.objects.first() print(publisher_obj) publisher_obj_book = publisher_obj.books.all() #books为book类中定义的related_name print(publisher_obj_book)运行结果:

书名: book_title:网络基础原理 出版社为: 东北大学出版社publisher_name:清华大学出版社 <QuerySet [<Book: book_title:Linux基础>, <Book: book_title:计算机原理>, <Book: book_title:Django从入门到精通>]>