# 增加数据
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
