Python manage.py shell#进入SQL的shell
p=Publisher(id=2,name='Lee',address='C',city='C',country='C',state_province='C',website='https://www.baidu.com')
p.save()
Publisher.objects.filter(name='Lee') #相当于SQL的where
Publisher.objects.filter(name__contains='L')#相当于SQL的LIKE %like%
Publisher.objects.order_by("name")#SQL的order by
#连锁查询
Publisher.objects.filter(name='L').order_by('name') #where 和 order by的组合
Publisher.objects.order_by(name='L')[0]#相当于limit 1
Publisher.objects.order_by(name='L')[0::2]#相当于offset 0 limit 2
#错误示范
Publisher.objects.order_by(name='L')[-1] #错误,没有负索引
#更新对象
p=Publisher.objects.get(name='L')
p.name='Lee'
p.save()
publisher.objects.get(name='L').update(name='Lee')
#删除对象delete
利用admin更改网页
#将页面改成中文 setting.py
LANGUAGE_CODE = 'zh-hans'
#在app里面的models.py
@admin.register(Book)
class BookAdmin(admin.ModelAdmin):#都要以元祖tuple,dict为内容填充
list_display = (['id','title','publishion_date'])#呈现的内容
list_per_page = 20#能显示最大的数目条
ordering = (['id','publishion_date'])#以什么为排序条件
list_editable = (['title'])#可以直接编辑的
list_filter = ['publishion_date']#以什么为过滤条件
要是之前注册过要先解绑
admin.site.unregister(Book)
效果图如下