ORM 多表作业

项目路由控制器 app01.urls.py

from app01.views import *

urlpatterns = [
    path("addbook/",book_add),
    path("sqlinsert/",sql_insert),
    path("search/",book_search),
    re_path("edit/(d+)/$",book_edit),
    re_path("delete/(d+)/$",book_delete)
]

项目视图控制器 app01.view.py

from app01 import models

def book_add(request):
    if request.method=="POST":
        #如果递交方式为post,获取新增数据的内容 有些内容是id
        bk_name = request.POST.get("bk_name")
        bk_price = request.POST.get("bk_price")
        bk_pub_date = request.POST.get("bk_pub_date")
        publish = request.POST.get("publish_id")
        # getlist 是因为作者是多选项,我们如果用get只能获取一个值,但是应该获取的是一个列表
        author = request.POST.getlist("author_lists")

        #把数据都写入数据库
        bk = models.Book.objects.create(title=bk_name,price=bk_price,pub_date=bk_pub_date,publish_id=publish)
        bk.author.add(*author)
        return redirect("/my/addbook/")
        # return HttpResponse(bk_pub_date)
    pubs = models.Publish.objects.all()
    auths = models.Author.objects.all()
    return render(request,"book_add.html",{"pubs":pubs,"auths":auths})


def sql_insert(request):
    # 添加出版社数据
    pub_lists = ["浙江出版社","山东出版社","济南出版社","南京出版社","北京出版社","天津出版社","深圳出版社"]
    pub=[models.Publish.objects.create(name=i) for i in pub_lists]
    # 添加作者详情表
    auth_detail = models.Author_detail.objects.create(city="济南",add="济南区")
    auth_detail = models.Author_detail.objects.create(city="山东",add="山东区")
    auth_detail = models.Author_detail.objects.create(city="浙江",add="浙江区")
    auth_detail = models.Author_detail.objects.create(city="南京",add="南京区")
    auth_detail = models.Author_detail.objects.create(city="深圳",add="深圳区")
    auth_detail = models.Author_detail.objects.create(city="天津",add="天津区")
    auth_detail = models.Author_detail.objects.create(city="北京", add="北京区")
    #添加作者详情,先根据城市获取作者详情表的id,再添加到作者表中
    #让作者表中的auth_detail和详情ID产生关联
    city_lists = ["浙江 ","山东","济南","南京","天津","深圳","北京"]
    auth_name = ["alex","blex","clex","dlex","elex","flex","glex"]
    for idx,city in enumerate(city_lists):
        au_detail = models.Author_detail.objects.get(city=city)
        auth1 = models.Author.objects.create(name=auth_name[idx],age=19+idx,author_detail=au_detail)


    return HttpResponse("数据数据初始化添加完毕")

def book_search(request):
    bks = models.Book.objects.all()

    return render(request,"book_search.html",{"bks":bks})


def book_edit(request,idx):
    bk = models.Book.objects.get(pk = idx)
    publishs = models.Publish.objects.all()
    auths = models.Author.objects.all()
    if request.method=="POST":
        bk_name = request.POST.get("bk_name")
        bk_price = request.POST.get("bk_price")
        bk_pub_date = request.POST.get("bk_pub_date")
        publish = request.POST.get("publish")
        auths = request.POST.getlist("author_lists")
        models.Book.objects.filter(pk=idx).update(title=bk_name,price = bk_price,pub_date = bk_pub_date,publish_id = publish)
        # bk.author.clear()
        # bk.author.add(*auths)
        # set等于上面2步,先清除对象的关闭,再新建新的关系表
        bk.author.set(auths)


        return redirect("/my/search/")
        # author = bk.author.all()
        #
        # bk.update(title = bk_name)
    # print(bk.pub_date)
    return render(request,"book_edit.html",locals())


def book_delete(request,idx):

    bk = models.Book.objects.filter(pk=idx)
    bk.delete()

    return redirect("/my/search")

项目ORM模块 appo1.models.py

from django.db import models


# Create your models here.
class Book(models.Model):  # 意见
    id = models.AutoField(primary_key=True)
    title = models.CharField(max_length=32)
    price = models.DecimalField(max_digits=8, decimal_places=2)
    pub_date = models.DateField()
    publish = models.ForeignKey(to="Publish", to_field="pid", on_delete=models.CASCADE)
    author = models.ManyToManyField(to="Author")

    def __str__(self):
        return self.title


class Publish(models.Model):
    pid = models.AutoField(primary_key=True)
    name = models.CharField(max_length=32)


class Author(models.Model):
    aid = models.AutoField(primary_key=True)
    name = models.CharField(max_length=32)
    age = models.IntegerField()
    author_detail = models.OneToOneField(to="Author_detail", to_field="aid", on_delete=models.CASCADE)


class Author_detail(models.Model):  # 已建
    aid = models.AutoField(primary_key=True)
    add = models.CharField(max_length=32)
    city = models.CharField(max_length=32)

网页book_add.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Book_add</title>
    <link rel="stylesheet" href="/static/css/bootstrap.css">
</head>
<body>
<h2 class="text-center">书籍添加</h2>
<div class="container-fluid">
    <div class="row">
        <div class="col-md-4 col-lg-4 col-sm-3  col-md-offset-4 col-lg-offset-4 col-sm-offset-5">
            <a href="/my/search" class="btn btn-success">返回查询页面</a>
            <form action="" method="post">
                {% csrf_token %}
                <div class="form-group">
                    <label for="add_book">书名</label>
                    <input type="text" name="bk_name" id="add_book" class="form-control">
                </div>
                <div class="form-group">
                    <label for="price">价格</label>
                    <input type="text" name="bk_price" id="price" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pub_date">出版日期</label>
                    <input type="date" name="bk_pub_date" id="pub_date" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pub_date">出版社</label>
                    <select name="publish_id" id="" class="form-control">
                        {% for pub in pubs %}
                            <option value="{{ pub.pk }}">{{ pub.name }}</option>
                        {% endfor %}
                    </select>
                    
                </div>
                <div class="form-group">
                    <label for="author">作者</label>
                    <select name="author_lists" id="" class="form-control" multiple>
                        {% for auth in auths %}
                            <option value="{{ auth.pk }}">{{ auth.name }}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="form-group pull-right">
                    <input type="submit" class="btn btn-success" value="提交">
                </div>

            </form>
        </div>
    </div>

</div>

</body>
</html>

网页book_edit.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Book_add</title>
    <link rel="stylesheet" href="/static/css/bootstrap.css">
</head>
<body>
<h2 class="text-center">书籍添加</h2>
<div class="container-fluid">
    <div class="row">
        <div class="col-md-4 col-lg-4 col-sm-3  col-md-offset-4 col-lg-offset-4 col-sm-offset-5">
            <a href="/my/search" class="btn btn-success">返回查询页面</a>
            <form action="" method="post">
                {% csrf_token %}
                <div class="form-group">
                    <label for="add_book">书名</label>
                    <input type="text" name="bk_name" id="add_book" class="form-control">
                </div>
                <div class="form-group">
                    <label for="price">价格</label>
                    <input type="text" name="bk_price" id="price" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pub_date">出版日期</label>
                    <input type="date" name="bk_pub_date" id="pub_date" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pub_date">出版社</label>
                    <select name="publish_id" id="" class="form-control">
                        {% for pub in pubs %}
                            <option value="{{ pub.pk }}">{{ pub.name }}</option>
                        {% endfor %}
                    </select>
                    
                </div>
                <div class="form-group">
                    <label for="author">作者</label>
                    <select name="author_lists" id="" class="form-control" multiple>
                        {% for auth in auths %}
                            <option value="{{ auth.pk }}">{{ auth.name }}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="form-group pull-right">
                    <input type="submit" class="btn btn-success" value="提交">
                </div>

            </form>
        </div>
    </div>

</div>

</body>
</html>

网页book_search.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Book_serach</title>
    <link rel="stylesheet" href="/static/css/bootstrap.css">
</head>
<body>
<h2 class="text-center">书籍查询</h2>
<div class="container-fluid">
    <div class="row">

        <div class="col-lg-6 col-md-5 col-sm-4 col-lg-offset-3 col-md-offset-3">
            <a href="/my/addbook/" class="btn btn-primary">新增书籍</a>
            <table class="table table-bordered table-striped">
            <thead>
                <tr>
                    <th  class="text-center">编码</th>
                    <th  class="text-center">书籍名称</th>
                    <th  class="text-center">出版日期</th>
                    <th  class="text-center">价格</th>
                    <th  class="text-center">出版社</th>
                    <th  class="text-center">作者</th>
                    <th  class="text-center">编辑操作</th>
                    <th  class="text-center">删除操作</th>
                </tr>
                </thead>
            <tbody>
{#bks是Book对象,里面的价格 书本名字可以直接通过属性获得,但是他的出版社需要通过正向查询的表名+字段获取  也就是bk.publiish.name#}
                    {% for bk in bks %}
                        <tr>
                        <td>{{ forloop.counter }}</td>
                        <td>{{bk.title}}</td>
                        <td>{{bk.pub_date|date:"Y-m-d"}}</td>
                        <td>{{bk.price}}</td>
                        <td>{{bk.publish.name}}</td>
                        <td>
{#先通过单个bk对象获取到author字段的所有数据  也就是bk.author.all  这里all不用加大括号 因为作者和书籍是多对多关系,所以bk.author.all 获取的不是一个值,而是多个值组成的queryset,还需要再次遍历提取作者表中的name字段#}
                            {% for each_bk_author_name in bk.author.all %}
{#这里实现的效果是作者和作者之间用逗号隔开,但是最后一个作者不需要加逗号,用forloop.last判断是否是最后一个循环,如果是不加逗号,否则模板语法后面加个逗号#}
                                {% if forloop.last %}
                                <span>{{each_bk_author_name.name}}</span>
                                    {% else %}
                                 <span>{{each_bk_author_name.name}},</span>
                                {% endif %}
                            {% endfor %}
                        </td>
                        <td><a href="/my/edit/{{ bk.pk }}/" class="btn btn-info">编辑操作</a></td>
                        <td><a href="/my/delete/{{ bk.pk }}/" class="btn btn-danger">删除操作</a></td>
                        </tr>
                    {% endfor %}
                </tbody>

            </table>
        </div>
    </div>
</div>
</body>
</html>