一对多
1、添加记录
Book.objects.create(name="Python进阶",price=77,pub_date="2019-12-12",publish_id=2)
Book.objects.create(name="GO",price=23,pub_date="2017-05-12",publish=publish_obj)
2、通过对象查询记录
book_obj=Book.objects.get(name="python进阶")
pub_obj=book_obj.publish----》书籍对象对应的出版社对象
pub_obj.name
pub_obj = Publish.objects.filter(name="人民出版社")[0]
pub_obj.book_set.all().values("name","price")
3、通过filter查询记录(filter values 双下划线__)
ret=Book.objects.filter(publish__name="人民出版社").values("name","price")
ret2=Publish.objects.filter(book__name="python进阶").values("name")
ret3=Book.objects.filter(name="python").values("publish__name")
ret4=Book.objects.filter(publish__city="北京").values("name")
ret5=Book.objects.filter(pub_date__lt="2019-07-01",pub_date__gt="2017-01-01").values("publish__name")
多对多
1、创建多对多的关系 author= models.ManyToManyField(“Author”)(推荐)
2、书籍对象它的所有关联作者 obj=book_obj.authors.all()
绑定多对多的关系 obj.add(*QuerySet)
obj.remove(author_obj)
3、如果想向第三张表插入值的方式绑定关系: 手动创建第三张表
# class Book_Author(models.Model):
# book=models.ForeignKey("Book")
# author=models.ForeignKey("Author")
Book_Author.objects.create(book_id=2,author_id=3)
4、练习
pub_obj=Publish.objects.filter(name="人民出版社")[0]
ret=Book.objects.filter(publish=pub_obj).values("name","price")
print(ret)
pub_obj = Publish.objects.filter(name="人民出版社")[0]
print(pub_obj.book_set.all().values("name","price"))
print(type(pub_obj.book_set.all()))
ret=Book.objects.filter(publish__name="人民出版社").values("name","price")
print(ret)
ret2=Publish.objects.filter(book__name="python").values("name")
print(ret2)
ret3=Book.objects.filter(name="python").values("publish__name")
print(ret3)
ret4=Book.objects.filter(publish__city="北京").values("name")
print(ret4)
ret5=Book.objects.filter(pub_date__lt="2017-07-01",pub_date__gt="2017-01-01").values("publish__name")
print(ret5)
book_obj=Book.objects.get(id=3)
print(book_obj.authors.all())
print(type(book_obj.authors.all()))
author_obj=Author.objects.get(id=2)
print(author_obj.book_set.all())
book_obj=Book.objects.get(id=3)
author_objs=Author.objects.all()
book_obj.authors.add(*author_objs)
book_obj.authors.remove(*author_objs)
book_obj.authors.remove(4)
Book_Author.objects.create(book_id=2,author_id=2)
obj=Book.objects.get(id=2)
print(obj.book_author_set.all()[0].author)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)