# 增加数据 from book.models import BookInfo from book.models import PeopleInfo book = BookInfo(name='Django', pub_date='2000-1-1', readcount=10) book.save() # ----------------2-------------- BookInfo.objects.create(name='Django企业开发实战', pub_date='2020-1-1', readcount=100) # 修改数据 book = BookInfo.objects.get(id=6) book.name = '运维入门' book.save() # ----------------2-------------- BookInfo.objects.filter(id=6).update(name='爬虫入门', commentcount=777) # 删除数据 # ---------1:物理删除--------------- book = BookInfo.objects.get(id=1) book.delete() # ---------2:物理删除--------------- BookInfo.objects.get(id=6).delete() # 查询数据 # ---------1:查询单一结果--------------- book = BookInfo.objects.get(id=2) # ---------2:查询多个结果---------------
# Create your views here. def index(request): return HttpResponse('index') from book.models import BookInfo book=BookInfo(name='Django', pub_date='2000-1-1', readcount=10 ) book.save() BookInfo.objects.create(name='Django', pub_date='2000-1-1', readcount=10) book=BookInfo.objects.get(id=6) book.name='运维开发入门' book.save() BookInfo.objects.filter(id=6).update(name='爬虫入门',commentcount=6) book=BookInfo.objects.get(id=6) book.delete() BookInfo.objects.filter(id=5).delete() BookInfo.objects.all() try: book=BookInfo.objects.get(id=6)
# 方式1 book = BookInfo( name='Django', pub_date='2020-1-1', readcount=100, ) book.save() # 必须调用对象的方法 save()将数据保存到数据库 # 方式2 # object -- 相当于一个代理 实现增删改查 BookInfo.objects.create(name='测试开发入门', pub_date='2020-1-1', readcount=100) # ############################修改数据############################## # 方法1 select * from bookinfo where id =6; book = BookInfo.objects.get(id=6) book.name = '运维入门方法' book.commentcount = 666 book.save() # 方法2 select * from bookinfo where id =6; BookInfo.objects.filter(id=5).update(name='python入门方法', commentcount=999) ############################## 删除数据 ############################ # 删除分2种,物理删除(这条记录的数据 删除) 和 逻辑删除 (修改标记位 例如 is_delete=False) # 方法1: book = BookInfo.objects.get(id=6) book.delete() # 方式2 BookInfo.objects.get(id=6).delete()
return HttpResponse('ok') #################################新增数据 book = BookInfo(name='django', pub_date='2000-01-1', readcount=10) book.save() # 方式2 book1 = BookInfo.objects.create(name='django1', pub_date='2000-01-1', readcount=10) book1.save() #################################修改数据 # 方式一 book = BookInfo.objects.get(id=1) book.name = '射雕英雄传---1' book.save() # 方法二 BookInfo.objects.filter(id=8).update(name='爬虫', commentcount=666) # 删除数据 BookInfo.objects.get(id=8).delete() BookInfo.objects.filter(name='django').delete() # 查询数据 BookInfo.objects.get(id=1) BookInfo.objects.get(pk=1) BookInfo.objects.all() BookInfo.objects.count()
readcount=100 ) """ book = BookInfo.objects.create(name='java1', pub_date='2010-1-1', readcount=100) # 修改数据 #第一种 # 先获取模型对象 # select * from bookinfo where id = 1 book = BookInfo.objects.get(id=6) # 直接采用 对象.属性 = 值 book.name = 'java 啦啦啦啦' book.readcount = 20 #需要调用 save来保存 book.save() # BookInfo.objects.get(id=5).update(name='python ~~~') 错误的 # 第二种方式 直接保存 BookInfo.objects.filter(id=5).update(name='python高级', commentcount=10000) # 在命令行第二行显示的1,表示受影响的行数是1行 # >>> BookInfo.objects.filter(id=5).update(name='python高级',commentcount=10000) # 1 # >>> # 得到的是单一对象
# 数据可以直接保存 # objects 相当于模型的管理属性 book = BookInfo.objects.create(name='django', pub_date='2005-1-1', readcount=666, commentcount=999) #######################修改数据################################## # 方式1 # 1. 先查询出某一个对象 # select * from bookinfo where id=6 book = BookInfo.objects.get(id=6) # 2.调用对象的属性来赋值 book.name = 'Flask' book.readcount = 1000 # 3. 调用save方法 book.save() # 方式2 # select * from bookinfo where id=6 BookInfo.objects.filter(id=6).update(name='爬虫', readcount=789, commentcount=123, pub_date='2010-1-1') ####################删除数据################################### # 方式1 # 1. 先查询出某一个对象
book.save() # insert data method 2 BookInfo.objects.create( name='Django2', pub_date='1931-4-25', readcount=0, commentcount=0, is_delete=0 ) # update method 1 book = BookInfo.objects.get(id=6) book.name = "manage" book.save() # update method 2 BookInfo.objects.filter(id=6).update(name="show show") # drop method 1 # physical(here use this) or logical book=BookInfo.objects.get(id=6) book.delete() # drop method 2 BookInfo.objects.filter(id=5).delete() # get one record