#插入數(shù)據(jù)
def add(request):
 
 G_title=request.POST.get('title')#-------值為：python書本
 
 G_publish=request.POST.get('publish') #-------值為：1
 G_authors_list=request.POST.getlist('authors')#-------值為：[3,7]
 
 
 
 publish_obj=Publish.objects.get(id=G_publish)#查找Publish表對應(yīng)id的obj 
 authors_obj_list=Author.objects.filter(id__in=G_authors_list)#查找Author表對應(yīng)id的多個obj
 
 title  #-------普通字段
 publish  #-------一對多外鍵
 authors  #-------多對多外鍵
 
 book_obj=Book.objects.create(title=G_title,publish=publish_obj)#添加普通和一對多外鍵的值
 
 
 #添加多對多外鍵的值
 方式一
 book_obj.authors.add(*authors_obj_list)
 方式二
 for obj in authors_obj_list:
  book_obj.authors.add(obj)
 
 return redirect('/index/')

def edit(request,b_id):#b_id-----為書本的id
 
 G_title=request.POST.get('title')#-------值為：linux書本
 
 G_publish = request.POST.get('publish')#-------值為：2
 G_authors_list = request.POST.getlist('authors')#-------值為：[3,5]
 
 
 book_obj = Book.objects.get(id=b_id)#查找Book表要修改的id對象
 
 publish_obj = Publish.objects.get(id=G_publish)#查找Publish表對應(yīng)id的obj
 author_objs = Author.objects.filter(id__in=G_authors_list)#查找Author表對應(yīng)id的多個obj
 
 
 book_obj.title=G_title   #-------修改普通字段
 book_obj.publish=publish_obj #-------修改一對多字段
 book_obj.authors=author_objs #-------修改多對多字段 
 #注意：多對多字段 必須是.all()/.filter()等的查詢集(QuerySet)
 book_obj.save()     #-------一定得save(),才能對數(shù)據(jù)庫進行修改
 
 return redirect('/index/')

 # 添加作者 ringo
 ringo = Author.objects.create(name='Ringo',email='ringo@qq.com')
 # 添加作者paul
 paul = Author.objects.create(name='Paul',email='paul@qq.com')
 # 添加書籍 python book1
 book1 = Book.objects.create(title='python book1')
 # 給多對多添加值也就是添加多對多關(guān)系
 m1 = BookAuthor(author=ringo,book=book)
 # 第二種添加方式
 m2 = BookAuthor.objects,create(author=paul,book=book1)