Django_Model1.0

导入包

from App_model.models import User
# django的model有增删改查，所以要继承
# 也因为继承，所以代码变的如此简化

增加

    user = User(username='lzk', password='666')
    user.save()

删除

pk就表示主键

    try:
        user = User.objects.get(pk=1)
        print(user, type(user))
        if user:
            user.delete()
    except Exception as e:
        print(e)

修改

    user = User.objects.get(pk=1)
    user.password = '000'
    user.save()

简单查询

    # all 过滤器 查询所有数据
    users = User.objects.all()
    # filter 过滤器 where              .all()可加可不加
    users = User.objects.filter(uid=45).all()
    users = User.objects.filter(uid=45).filter(uid=46)  # 过滤器可以串联调用
    print(users)
    users = User.objects.filter(uid__gt=40)  # uid大于等于40的
    return HttpResponse('Model Find OK')

便利方法

# 便利方法
    # 创建
    user = {'username': 'lsx', 'password': '777'}
    User.objects.create(**user)

    # 批量创建
    User.objects.bulk_create([User(username='aaa', password=111), User(username='bbb', password=222)])

    # 批量删除
    user = User.objects.filter(uid__gte=1)  # uid__gte删除主键以N数字开头的记录
    user.delete()