会python真的可以为所欲为0(回)
365天前
这里还有人吗1(回)
550天前这里还有人吗0(回)
550天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
775天前到处都是羊，不想上班0(回)
855天前
鸽子
0(回)
859天前def query(request): |
# 1 all方法：models.表名.objects.all() |
book_all = models.Book.objects.all() # 结果是querySet集合 |
# print(book_all) |
# 2 filter: models.表名.objects.filter() |
ret = models.Book.objects.filter(title='PHP') # 结果是querySet集合 |
ret2 = models.Book.objects.filter(nid=1) # 结果是querySet集合 |
ret3 = models.Book.objects.filter(author='Alex', price=35) # 结果是querySet集合,且的关系，两个条件都要满足 |
# print(ret) |
# 3 get：models.表名.objects.get() |
ret4 = models.Book.objects.get(nid=3) # model对象，如果取不到值则会报错 |
# print(ret4,ret4.price) |
# 4 exclude：排除条件，取非 |
ret5 = models.Book.objects.exclude(author='oldboy') |
# 5 values方法 |
# ret6=models.Book.objects.filter(author='Alex').values('title','price') |
# print('ret6',ret6) |
# #6 values_list方法 |
# ret7 = models.Book.objects.filter(author='Alex').values_list('title', 'price') |
# print('ret7', ret7) |
# ret8 = models.Book.objects.filter(author='Alex').values('author').distinct() |
# print('ret8',ret8) |
# 双线划线 |
ret9 = models.Book.objects.filter(price__gt=30) |
ret10 = models.Book.objects.filter(title__startswith='P') |
ret11 = models.Book.objects.filter(id_lt=4, id_gt=2) # id 大于2小于4 |
print('ret10', ret10) |
return HttpResponse("OK") |
