from  .models import UserInfo

from django.http import HttpResponse

#新增一个对象

def add(self):

    userInfo = UserInfo.objects.create(

        code='1',

        name='zhangsan',

        age='18',

        count=1,

    )

    print(userInfo)

    return HttpResponse("add success")

#查询一条数据(使用get查询多条数据会报错)

def getSingle(self):

     userInfo= UserInfo.objects.get(code="1")

     print(userInfo)

     return HttpResponse("getSingle success")

#查询所有数据

def getAll(self):

    userInfoList = UserInfo.objects.all()

    for i in range(len(userInfoList)):

        print(i, '---->', userInfoList[i])

    return HttpResponse("getAll success")

#查询多条数据,增加查询条件

def getAllSelect(self):

    userInfoList = UserInfo.objects.filter(code="1",name="lisi")

    for i in range(len(userInfoList)):

        print(i, '---->', userInfoList[i])

    return HttpResponse("getAll success")

#删除数据(删除所有)

def delete(self):

    UserInfo.objects.delete()

    return HttpResponse("delete success")

# 更新

def update(self):

    userInfo = UserInfo.objects.filter(code="1")

    userInfo.update(age="22",count=2)

    return HttpResponse("update success")

#删除单条(查询出来就是单条,这里使用get把所有的数据都删除了)

def deleteSingle(self):

    userInfo = UserInfo.objects.filter(code="4")

    userInfo.delete()

    return HttpResponse("deleteSingle success")