python-20 Djangoでのmysql追加削除

class BookView(View):
    #  
    def get(self,request):
        blist=BookInfo.objects.all()                                                                              #     
        blist=BookInfo.objects.filter(pk__exact=3)                                                  # id  3
        blist=BookInfo.objects.filter(pk=3)                                                                 # id  3
        blist=BookInfo.objects.filter(btitle__contains=' ')                                     # btitle   ‘ ’
        blist=BookInfo.objects.filter(btitle__endswith=' ')                                     # bittle   ‘ ’  
        blist=BookInfo.objects.exclude(btitle__endswith=' ')                               # btitle  ‘ ’  
        blist=BookInfo.objects.filter(btitle__isnull=False)                                        # btitle   
        blist=BookInfo.objects.filter(pk__in=[1,3,4])                                                 # id 1,3,4
        blist=BookInfo.objects.filter(pk__in=[1,4])                                                    # id 1,4
        blist=BookInfo.objects.filter(pk__gt=3)                                                          # id  3
        blist=BookInfo.objects.exclude(pk__gt=3)                                                    # id   3（    3）
        blist=BookInfo.objects.filter(pk__lt=3)                                                           # id  3
        blist=BookInfo.objects.filter(bpub_date__year=1980)                              #         1980
        blist=BookInfo.objects.filter(bpub_date__lt=date(1995,1,1))                  #       1995.1.1

        blist=BookInfo.objects.filter(bread__gte=F('bcomment'))                         #             
        blist=BookInfo.objects.filter(bread__gt=F('bcomment')*2)                       #            2 

        blist=BookInfo.objects.filter(Q(pk__gt=2)&Q(bcomment__gt=3))            #    
        blist=BookInfo.objects.filter(Q(pk__gt=2,bcomment__gt=3))                   #    
        blist=BookInfo.objects.filter(Q(pk__gt=4)|Q(pk__lt=3))                              #    
        blist=BookInfo.objects.filter(~Q(pk=4))                                                          #    

        bread_sum=BookInfo.objects.aggregate(Sum('bread'))
        print(bread_sum)

        book_count=BookInfo.objects.aggregate(Count('pk'))
        # book_count=BookInfo.objects.count()
        print(book_count)

        blist=BookInfo.objects.all().order_by('bread')
        blist=BookInfo.objects.all().order_by('-bread')
        blist=BookInfo.objects.all().order_by('-bread').order_by('-pk')


        return render(request,'book.html',{"blist":blist})
        pass


    #  (     ，       update， insert)
    def post(self,request):
        #     
         book=BookInfo.objects.create(
             btitle='   ',
             bpub_date=date(2017,11,18)
         )
        #     
        # book=BookInfo()
        # book.btitle='   '
        # book.bpub_date=date(2017,5,14)
        # book.save()
        # return HttpResponse(book.btitle)
        pass

    #  (     ，       update， insert)
    def put(self,request):
        #      
        # BookInfo.objects.filter(pk=41).update(btitle='    ')
        # return HttpResponse('ok')
        #      
        book=BookInfo.objects.get(pk=3)
        book.btitle='    '
        book.save()
        return HttpResponse('ok')
        pass

    #  
    def delete(self,request):
        #     ，           
        # BookInfo.objects.filter(pk__gt=4).delete()
        #     ，      
        book=BookInfo.objects.get(pk=41)
        book.delete()
        return HttpResponse('ok')
        pass