orm模型增删查改

views.py:

from django.shortcuts import render
from .models import Book
from django.http import HttpResponse


def index(requests):
    #插入一条信息
    # book = Book(name='三国', author='jj', price=85)
    # book.save()

    #查询，根据主键进行查找
    # book = Book.objects.get(pk=1)
    # print(book)

    #根据其他条件进行查找
    # book = Book.objects.filter(author='刘慈欣').first()
    # print(Book.objects.filter(author='刘慈欣'))

    #删除数据
    # book = Book.objects.get(pk=3)
    # book.delete()

    #修改数据
    book = Book.objects.get(pk=2)
    book.price = 600
    book.save()

    return HttpResponse("done----")

settings.py中数据库配置，别忘了安装相应的app

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'orm_base_demo',
        'USER': 'kai',
        'PASSWORD': '88888',
        'PORT': '3306',
    }
}

models.py:

from django.db import models

# Create your models here.
class Book(models.Model):
    name = models.CharField(max_length=100, null=False)
    author = models.CharField(max_length=100, null=False)
    price = models.FloatField(default=0)

    def __str__(self):
        # <Book:(name,author,price)>
        return "{name},{author},{price}".format(name=self.name, author=self.author, price=self.price)