Django 数据库的增、删、改、查

#Django 数据库的增、删、改、查
增

#views.py
def add_xiaoqu(resquest):
	#1
    xiaoqu = models.Xiaoqu()
    xiaoqu.name = '吉利大学'
    xiaoqu.save()
    #2
    models.Xiaoqu.objects.create(name='吉利大学1')
    return HttpResponse('very')

查

#views.py
def select_xiaoqu(request):
    #1
    xiaoqu = models.Xiaoqu.objects.get(name='吉利大学')

    #2
    xiaoqu1 = models.Xiaoqu.objects.filter(name='吉利大学1').first()
    return HttpResponse(xiaoqu1)

改

#views.py
def change_xiaoqu(request):

    xiaoqu1 = models.Xiaoqu.objects.filter(name='吉利大学1').first()
    #1
    # xiaoqu1.name = '北京大学'
    # xiaoqu1.save()

    #2 修改的是结果集
    xiaoqu1 = models.Xiaoqu.objects.filter(name='北京大学').update(name='吉利大学1')

    return HttpResponse('ok')

删除

#views.py
def delete_xiaoqu(request):
    #1
    # xiaoqu1 = models.Xiaoqu.objects.filter(name='吉利大学1').first()
    # xiaoqu1.delete()
    #2
    xiaoqu1 = models.Xiaoqu.objects.get(name='吉利大学').delete()

    return HttpResponse('ok')

增和查

#views.py
def add_table(request):
    xiaoqu = models.Xiaoqu.objects.filter(name='吉利大学').first()
    #1
    # school = models.School()
    # school.name = '积云教育'
    # school.xiaoqu = xiaoqu
    # school.save()

    #2
    school = models.School()
    school.name = '海岩教育'
    school.xiaoqu_id = xiaoqu.id
    school.save()

    return HttpResponse('add ok!')

def select_table(request):
    #1通过学校查校区
    # s = models.School.objects.filter(name='积云教育').first()
    # print(s.xiaoqu.name)

    #2通过主表查子表
    xiaoqu = models.Xiaoqu.objects.filter(name='吉利大学').first()
    for i in xiaoqu.school_set.all():
        print(i.name)

    return HttpResponse('select ok!')

def sql_exe(request):
    s = models.School.objects.filter(name='积云教育').first()
    zhuanye = models.Zhuanye()
    zhuanye.name = '人工智能'
    zhuanye.school = s
    zhuanye.save()

    zhuanye = models.Zhuanye()
    zhuanye.name = '大数据'
    zhuanye.school = s
    zhuanye.save()
    
    return HttpResponse('add ok!')


def select_sql(request):
    #1人工智能属于哪个校区
    xiaoqu = models.Xiaoqu.objects.filter(school__zhuanye__name='人工智能').first()
    print(xiaoqu)

    print('*'*40)
    #2查找吉利大学有哪些专业
    zhuanyu = models.Zhuanye.objects.filter(school__xiaoqu__name='吉利大学')
    for i in zhuanyu:
        print(i)

    print('*'*40)
    #3查询积云教育下的专业
    s = models.School.objects.filter(name='积云教育').first()
    zhuanye = models.Zhuanye.objects.filter(school_id=s.id)
    for i in zhuanye:
        print(i.name)

    print('*'*40)
    #4通过隐藏属性查找
    s = models.School.objects.filter(name='积云教育').first()
    zhuanye = s.zhuanye_set.filter()
    print(zhuanye)

    return HttpResponse('ok!')