from django.shortcuts import render
from .models import Book
from django.http import HttpResponse
def index(resquest):
# 1、使用ORM 添加数据
# book = Book(name='西游记',author='吴承恩',pirce='100')
# book.save()
# 2、查询
# 2.1、根据主键查询
# book = Book.objects.get(pk=1)
# print(book) # <Book:(三国演义,罗贯中,200.0)>
# 2.2、根据其它条件进行查询
# book = Book.objects.get(name='西游记')
# print(book) # <Book:(西游记,吴承恩,100.0)>
# 3、删除
# book = Book.objects.get(pk=1)
# book.delete()
# 4、修改
book = Book.objects.get(pk=2)
book.pirce = 200
book.save()
return HttpResponse("成功")
Book中的models.py文件
from django.db import models
class Book(models.Model):
name = models.CharField(max_length=100,null=False)
author = models.CharField(max_length=100,null=False)
pirce = models.FloatField(default=0)
# 自定义打印print
def __str__(self):
return "<Book:({name},{author},{price})>".format(name=self.name,
author=self.author,price=self.pirce)
# 1、使用makemigrations生成迁移脚本文件
# python manage.py makemigrations
# 2、使用migrate将新生成的脚本文件映射到数据库中
# python manage,py migrate