django orm插入一条_Django ORM (二) 增加操作

数据库表结构生成完毕后，可以使用工具连接上去

在 app01_author 表创建基础记录

在 app01_publisher 表创建基础记录

添加 data_oper 方法

在 urls.py 文件上添加

from app01 import views

urlpatterns = [

....

path('data_oper/', views.data_oper),

]

ORM 增加方法

create 方式一

在 views.py 文件上添加

from django.shortcuts import render, HttpResponse

from app01 import models

from app01.models import Book,Author

def data_oper(req):

Book.objects.create(

title="hahaha",

price=2,

publication_date="2019-05-16",

publisher_id=1,

)

return HttpResponse("Hello world")

create 方式二

在 views.py 文件上修改

from django.shortcuts import render, HttpResponse

from app01 import models

from app01.models import Book,Author

def data_oper(req):

dic = { "title":"K8S", "price":1, "publication_date":"2019-05-02", "publisher_id":1 }

Book.objects.create(**dic)

return HttpResponse("Hello world")

save 方式一

from django.shortcuts import render, HttpResponse

from app01 import models

from app01.models import Book,Author

# Create your views here.

def data_oper(req):

obj=Book(

title="Python",

price=99,

publication_date="2019-05-06",

publisher_id=1,

)

obj.save()

return HttpResponse("Hello world")

save 方式二

from django.shortcuts import render, HttpResponse

from app01 import models

from app01.models import Book,Author

# Create your views here.

def data_oper(req):

obj=Book()

obj.title="GO"

obj.price=90

obj. publication_date="2019-05-06"

obj.publisher_id=1

obj.save()

return HttpResponse("Hello world")

外键一对多的(ForeignKey)

在 models.py 中 Book 表下定义外键为

publisher = models.ForeignKey(Publisher,on_delete=models.CASCADE)

方法一

在 views.py 文件上修改

from django.shortcuts import render, HttpResponse

from app01 import models

from app01.models import Book,Author,Publisher

# Create your views here.

def data_oper(req):

pub_obj = Publisher.objects.get(id=1) # 取publish 表 id 为1 的值

dic = {"title": "Docker", "price": 88, "publication_date": "2019-05-05", "publisher": pub_obj}

Book.objects.create(**dic)

return HttpResponse("Hello world")

方法二

在 views.py 文件上修改

from django.shortcuts import render, HttpResponse

from app01 import models

from app01.models import Book,Author

def data_oper(req):

dic = { "title":"K8S", "price":1, "publication_date":"2019-05-02", "publisher_id":1 } # 直接指定 publisher 外键值了，这里要加 _id

Book.objects.create(**dic)

return HttpResponse("Hello world")

外键多对多的情况

正向查询

from django.shortcuts import render, HttpResponse

from app01 import models

from app01.models import Book,Author,Publisher

# Create your views here.

def data_oper(req):

book=models.Book.objects.filter(id=1)[0]

authors=models.Author.objects.filter(id__gt=2)

book.authors.add(*authors)

return HttpResponse("Hello world")

反向查询

from django.shortcuts import render, HttpResponse

from app01 import models

from app01.models import Book,Author,Publisher

# Create your views here.

def data_oper(req):

book = models.Book.objects.filter(id__gt=1)

authors = models.Author.objects.filter(id=1)[0]

authors.book_set.add(*book)

return HttpResponse("Hello world")

双下划线(__)之单表条件查询

# models.Book.objects.filter(id__lt=10,id__gt=1) # 获取id大于1 且 小于10的值

#

# models.Book.objects.filter(id__in=[11, 22, 33]) # 获取id等于11、22、33的数据

# models.Book.objects.exclude(id__in=[11, 22, 33]) # not in

#

# models.Book.objects.filter(title__contains="ven")

# models.Book.objects.filter(title__icontains="ven") # icontains大小写不敏感

#

# models.Book.objects.filter(id__range=[1, 2]) # 范围bettwen and