Django2.2 学习笔记 (4)_model增删改查

1、在views.py文件中更改代码

from django.shortcuts import render

# Create your views here.
from apps.message_form.models import Message

# 官方文档
# https://docs.djangoproject.com/zh-hans/2.2/ref/models/querysets/
# queryset to json
# https://www.cnblogs.com/sly27/p/10474883.html

def message_form(request):

    # 取所有的数
    all_message = Message.objects.all()
    # all 是 queryset 类，它有 1、for循环 2、切片两种操作
    # 本身不执行sql语句操作
    print(all_message.query)
    # SELECT `message`.`name`, `message`.`email`, `message`.`address`, `message`.`message` FROM `message`

    sliced_query = Message.objects.all()[:1]
    # print(sliced_query.query)
    # SELECT `message`.`name`, `message`.`email`, `message`.`address`, `message`.`message` FROM `message` Limit 1

    # filter,数据筛选
    all_message = Message.objects.filter(name="zhs")
    for message in all_message:
        print(message.name)

    # delete,数据删除
    all_message = Message.objects.filter(name="zhs")
    all_message.delete()
    for message in all_message:
        print(message.name)
        message.delete()


    # get,如果数据不存在，或者数据存在多条，则会抛出异常
    message = Message.objects.get(name="zhs")
    #print(message)

    # insert,在mysql数据库中插入并保存数据
    message = Message()
    message.name = "zhs1"
    message.email = "zhs1@126.com"
    message.address = "hebei"
    message.message = "hello word"
    message.save()

    return render(request, "message_form.html")

2、启动服务器，在浏览器刷新页面后会进行相应操作