天天生鲜—创建数据库

一、分析需求&＃xff0c;得到表之间的关联

说明&＃xff1a;创建数据库之前应该有一个需求分析的过程&＃xff0c;这个过程主要是依据需求方的需求文档&＃xff0c;进行分析&＃xff0c;需要什么功能&＃xff0c;实现这些功能需要哪些表&＃xff0c;表与表之间的关联如何&＃xff0c;以及实现一些功能时需要用到哪些技术&＃xff0c;都需要在这个步骤分析清楚。

二、依据表的分析&＃xff0c;创建数据库&＃xff0c;表

1、创建基类base_model
在项目目录下创建python文件夹db—>创建python文件base_model.py——>创建基类&＃xff0c;代码如下&＃xff1a;

from django.db import modelsclass BaseModel(models.Model):"""创建一个数据库的基类&＃xff0c;"""create_time &＃61; models.DateTimeField(auto_now_add&＃61;True, verbose_name&＃61;&＃39;创建时间&＃39;)modify_time &＃61; models.DateTimeField(auto_now&＃61;True, verbose_name&＃61;&＃39;修改时间&＃39;)is_delete &＃61; models.BooleanField(default&＃61;True, verbose_name&＃61;&＃39;删除标记&＃39;)class Meta:abstract &＃61; True # 说明这是一个抽象类的模型。

2、user应用下创建User表&＃xff0c;直接继承django自导的abstractUser类。

from django.contrib.auth.models import AbstractUser
from db.base_model import BaseModel
from django.db import modelsclass User(AbstractUser, BaseModel):"""这里是直接使用django自带的user类"""class Meta:db_table &＃61; &＃39;df_user&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;用户&＃39;class AddressManager(models.Manager):&＃39;&＃39;&＃39;地址模型管理器类&＃39;&＃39;&＃39;# 1.改变原有查询的结果集:all()# 2.封装方法:用户操作模型类对应的数据表(增删改查)def get_default_address(self, user):&＃39;&＃39;&＃39;获取用户默认收货地址&＃39;&＃39;&＃39;# self.model:获取self对象所在的模型类try:address &＃61; self.get(user&＃61;user, is_default&＃61;True) # models.Managerexcept self.model.DoesNotExist:# 不存在默认收货地址address &＃61; Nonereturn addressclass Address(BaseModel):&＃39;&＃39;&＃39;地址模型类&＃39;&＃39;&＃39;user &＃61; models.ForeignKey(&＃39;User&＃39;, verbose_name&＃61;&＃39;所属账户&＃39;, on_delete&＃61;models.CASCADE)receiver &＃61; models.CharField(max_length&＃61;20, verbose_name&＃61;&＃39;收件人&＃39;)addr &＃61; models.CharField(max_length&＃61;256, verbose_name&＃61;&＃39;收件地址&＃39;)zip_code &＃61; models.CharField(max_length&＃61;6, null&＃61;True, verbose_name&＃61;&＃39;邮政编码&＃39;)phone &＃61; models.CharField(max_length&＃61;11, verbose_name&＃61;&＃39;联系电话&＃39;)is_default &＃61; models.BooleanField(default&＃61;False, verbose_name&＃61;&＃39;是否默认&＃39;)# 自定义一个模型管理器对象objects &＃61; AddressManager()class Meta:db_table &＃61; &＃39;df_address&＃39;verbose_name &＃61; &＃39;地址&＃39;verbose_name_plural &＃61; verbose_name


3、order应用下创建订单信息表&＃xff0c;订单商品表&＃xff0c;继承Basemodel&＃xff0c;·

from db.base_model import BaseModel
from django.db import models# 这个是订单相关的表&＃xff1a;订单信息表&＃xff0c;订单的商品表class OrderInfo(BaseModel):"""订单信息表"""PAY_METHODS_CHOICE &＃61; ((1, &＃39;货到付款&＃39;),(2, &＃39;微信支付&＃39;),(3, &＃39;支付宝&＃39;),(4, &＃39;银联支付&＃39;))ORDER_STATUS_CHOICE &＃61; ((1, &＃39;待支付&＃39;),(2, &＃39;待发货&＃39;),(3, &＃39;待收货&＃39;),(4, &＃39;待评价&＃39;),(5, &＃39;已完成&＃39;))order_id &＃61; models.IntegerField(primary_key&＃61;True, verbose_name&＃61;&＃39;订单id&＃39;)address &＃61; models.ForeignKey(&＃39;user.Address&＃39;, on_delete&＃61;models.CASCADE, verbose_name&＃61;&＃39;地址id&＃39;)user &＃61; models.ForeignKey(&＃39;user.User&＃39;, on_delete&＃61;models.CASCADE, verbose_name&＃61;&＃39;用户id&＃39;)pay_method &＃61; models.CharField(max_length&＃61;32, choices&＃61;PAY_METHODS_CHOICE, default&＃61;1, verbose_name&＃61;&＃39;支付方式&＃39;)total_count &＃61; models.IntegerField(verbose_name&＃61;&＃39;总的数目&＃39;)total_price &＃61; models.DecimalField(max_digits&＃61;128, decimal_places&＃61;0,verbose_name&＃61;&＃39;总的金额&＃39;) # max_digits:数字允许的最大位数&＃xff1b;decimal_places:小数的最大位数trans_price &＃61; models.DecimalField(max_digits&＃61;128, decimal_places&＃61;0, verbose_name&＃61;&＃39;运费&＃39;)order_status &＃61; models.CharField(max_length&＃61;32, choices&＃61;ORDER_STATUS_CHOICE, default&＃61;1, verbose_name&＃61;&＃39;订单状态&＃39;)trade_no &＃61; models.IntegerField(verbose_name&＃61;&＃39;支付编号&＃39;)class Meta:db_table &＃61; &＃39;df_order_info&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;订单&＃39;class OrderGoods(BaseModel):order &＃61; models.ForeignKey(&＃39;OrderInfo&＃39;, verbose_name&＃61;&＃39;订单&＃39;, on_delete&＃61;models.CASCADE)sku &＃61; models.ForeignKey(&＃39;goods.GoodsSKU&＃39;, verbose_name&＃61;&＃39;商品SKU&＃39;, on_delete&＃61;models.CASCADE)count &＃61; models.IntegerField(default&＃61;1, verbose_name&＃61;&＃39;商品数目&＃39;)price &＃61; models.DecimalField(max_digits&＃61;12, decimal_places&＃61;2, verbose_name&＃61;&＃39;商品价格&＃39;)comment &＃61; models.CharField(max_length&＃61;256, default&＃61;&＃39;&＃39;, verbose_name&＃61;&＃39;评论&＃39;)class Meta:db_table &＃61; &＃39;df_order_goods&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;订单商品&＃39;

4、goods应用下创建商品类型表&＃xff0c;商品SKU表&＃xff0c;商品SPU表&＃xff0c;商品图片表&＃xff0c;首页轮播商品表&＃xff0c;首页分类商品展示表&＃xff0c;首页促销活动表&＃xff0c;继承Basemodel数据库基类。

from django.db import models
from tinymce.models import HTMLField
from db.base_model import BaseModelclass GoodsType(BaseModel):"""商品模型类"""name &＃61; models.CharField(max_length&＃61;32, verbose_name&＃61;&＃39;种类名称&＃39;)logo &＃61; models.CharField(max_length&＃61;32, verbose_name&＃61;&＃39;标识&＃39;)image &＃61; models.ImageField(upload_to&＃61;&＃39;type&＃39;, verbose_name&＃61;&＃39;商品类型图片&＃39;)class Meta:db_table &＃61; &＃39;df_goods_type&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;商品种类&＃39;class GoodsSKU(BaseModel):"""商品SKU表"""STATUS_CHOICE &＃61; ((0, &＃39;下线&＃39;), (1, &＃39;上线&＃39;))type &＃61; models.ForeignKey(&＃39;GoodsType&＃39;, verbose_name&＃61;&＃39;商品种类&＃39;,on_delete&＃61;models.CASCADE)goods &＃61; models.ForeignKey(&＃39;Goods&＃39;, verbose_name&＃61;&＃39;商品名称&＃39;,on_delete&＃61;models.CASCADE)name &＃61; models.CharField(max_length&＃61;20, verbose_name&＃61;&＃39;商品名称&＃39;)desc &＃61; models.CharField(max_length&＃61;256, verbose_name&＃61;&＃39;商品简介&＃39;)price &＃61; models.DecimalField(max_digits&＃61;32,decimal_places&＃61;0, verbose_name&＃61;&＃39;商品价格&＃39;)unite &＃61; models.IntegerField(verbose_name&＃61;&＃39;商品单位&＃39;)image &＃61; models.ImageField(upload_to&＃61;&＃39;goods&＃39;, verbose_name&＃61;&＃39;商品图片&＃39;)stock &＃61; models.IntegerField(verbose_name&＃61;&＃39;商品库存&＃39;)sales &＃61; models.IntegerField(default&＃61;0, verbose_name&＃61;&＃39;商品销量&＃39;)status &＃61; models.CharField(max_length&＃61;32,default&＃61;1, choices&＃61;STATUS_CHOICE, verbose_name&＃61;&＃39;商品状态&＃39;)class Meta:db_table &＃61; &＃39;df_goods_sku&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;商品&＃39;class Goods(BaseModel):"""商品SPU模型"""name &＃61; models.CharField(max_length&＃61;56, verbose_name&＃61;&＃39;商品名称&＃39;)detail &＃61; HTMLField(blank&＃61;True, verbose_name&＃61;&＃39;商品详情&＃39;)class Meta:db_table &＃61; &＃39;df_goods&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;商品SKU&＃39;class GoodsImage(BaseModel):"""商品图片"""sku &＃61; models.ForeignKey(&＃39;GoodsSKU&＃39;, verbose_name&＃61;&＃39;商品&＃39;,on_delete&＃61;models.CASCADE)image &＃61; models.ImageField(upload_to&＃61;&＃39;goods&＃39;, verbose_name&＃61;&＃39;图片路径&＃39;)class Meta:db_table &＃61; &＃39;df_goods_image&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;商品图片&＃39;class IndexGoodsBanner(BaseModel):"""首页轮播商品展示"""sku &＃61; models.ForeignKey(&＃39;GoodsSKU&＃39;,on_delete&＃61;models.CASCADE)image &＃61; models.ImageField(upload_to&＃61;&＃39;banner&＃39;, verbose_name&＃61;&＃39;图片&＃39;)index &＃61; models.SmallIntegerField(default&＃61;0, verbose_name&＃61;&＃39;展示顺序&＃39;)class Meta:db_table &＃61; &＃39;df_index_banner&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;首页轮播商品&＃39;class IndexTypeGoodsBanner(BaseModel):"""首页分类商品展示模型"""DISPLAY_TYPE_CHOICE &＃61; ((0, &＃39;标题&＃39;), (1, &＃39;图片&＃39;))type &＃61; models.ForeignKey(&＃39;GoodsType&＃39;, verbose_name&＃61;&＃39;商品类型&＃39;,on_delete&＃61;models.CASCADE)sku &＃61; models.ForeignKey(&＃39;GoodsSKU&＃39;, verbose_name&＃61;&＃39;商品SKU&＃39;,on_delete&＃61;models.CASCADE)display_type &＃61; models.CharField(max_length&＃61;56,default&＃61;1, choices&＃61;DISPLAY_TYPE_CHOICE, verbose_name&＃61;&＃39;展示类型&＃39;)index &＃61; models.SmallIntegerField(default&＃61;0, verbose_name&＃61;&＃39;展示顺序&＃39;) # 1,2,3,4class Meta:db_table &＃61; &＃39;df_index_type_goods&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;主页分类展示商品&＃39;class IndexPromotionBanner(BaseModel):"""首页促销活动模型"""name &＃61; models.CharField(max_length&＃61;32, verbose_name&＃61;&＃39;活动名称&＃39;)url &＃61; models.URLField(max_length&＃61;256, verbose_name&＃61;&＃39;活动链接&＃39;)image &＃61; models.ImageField(upload_to&＃61;&＃39;banner&＃39;, verbose_name&＃61;&＃39;活动图片&＃39;)index &＃61; models.SmallIntegerField(default&＃61;0, verbose_name&＃61;&＃39;展示顺序&＃39;)class Meta:db_table &＃61; &＃39;df_index_promotion&＃39;verbose_name_plural &＃61; verbose_name &＃61; &＃39;主页促销活动&＃39;

5、cart 应用下&＃xff0c;无需创建模型

自此&＃xff0c;模型来创建完成

三、 数据库迁移

*说明&＃xff1a;*这里使用的数据库是sqllite&＃xff0c;所以就直接迁移就好&＃xff0c;
我运用的事django自带的认证系统&＃xff0c;所以在setting.py 配置文件中要加入

AUTH_USER_MODEL &＃61; &＃39;user.User&＃39;


1、生成模型&＃xff1a;python manage.py make migrations
2、迁移指令&＃xff1a;python manage.py migrate

迁移成功