用户账户模块
accounts\models.py
from django.db import models
class User(models.Model):
""" 用户的基础信息表 """
username = models.CharField('用户名',max_length=64)
nickname = models.CharField('昵称',max_length=32)
password = models.CharField('密码',max_length=255)
avatar = models.ImageField('用户头像', upload_to='avatar', null=True, blank=True)
integral = models.IntegerField('用户积分',default=0)
level = models.SmallIntegerField('用户级别')
class Meta:
db_table = 'accounts_user'
class UserProfile(models.Model):
SEX_CHOICES = (
(1,'男'),
(0,'女'),
)
user = models.OneToOneField(User)
real_name = models.CharField('真实姓名', max_length=32)
email = models.EmailField('电子邮箱', max_length=128,null=True, blank=True)
is_email_valid = models.BooleanField('邮箱是否已经验证', default=False)
phone_no = models.CharField('手机号码', max_length=20, null=True, blank=True)
is_phone_valid = models.BooleanField('是否已经验证', default=False)
sex = models.SmallIntegerField('性别', default=1, choices=SEX_CHOICES)
age = models.SmallIntegerField('年龄',default=0)
created_at = models.DateTimeField('创建时间', auto_now_add=True)
updated_at = models.DateTimeField('修改时间',auto_now=True)
class Meta:
db_table = 'accounts_user_profile'
class UserAdderss(models.Model):
""" 用户的地址信息 """
user = models.ForeignKey(User,related_name='user_adderss')
province = models.CharField('省份',max_length=32)
city = models.CharField('市区',max_length=32)
area = models.CharField('区域', max_length=32)
town = models.CharField('街道', max_length=32, null=True, blank=True)
address = models.CharField('详细地址',max_length=64)
username = models.CharField('收件人',max_length=32)
phone = models.CharField('收件人的电话',max_length=32)
is_default = models.BooleanField('是否为默认地址',default=False)
is_valid = models.BooleanField('是否有效',default=True)
created_at = models.DateTimeField('创建时间', auto_now_add=True)
updated_at = models.DateTimeField('修改时间', auto_now=True)
class Meta:
db_table = 'accounts_user_address'
ordering = ['is_default', '-updated_at']
class LoginRecord(models.Model):
""" 用户的登录历史 """
user = models.ForeignKey(User)
username = models.CharField('登录的账号', max_length=64)
ip = models.CharField('IP', max_length=32)
address = models.CharField('地址', max_length=32,null=True,blank=True)
source = models.CharField('登录的来源', max_length=32)
created_at = models.DateTimeField('登录的时间')
class Meta:
db_table = 'accounts_login_record'
class PasswdChangeLog(models.Model):
""" 用户的密码修改历史 """
pass
同步到数据库
python manage.py check # 检查有无代码错误
python manage.py makemigrations #同步到数据库
python manage.py migrate
商品的基本信息
商品模块mall\models.py
import uuid
from django.db import models
# Create your models here.
from utils import constants
class Product(models.Model):
""" 商品 """
uid = models.UUIDField('商品ID',default=uuid.uuid4,editable=False)
name = models.CharField('商品名称', max_length=128)
desc = models.CharField('简单描述',max_length=256,null=True,blank=True)
content = models.TextField('商品描述')
type = models.SmallIntegerField('商品类型',
choices=constants.PRODUCT_TYPES_CHOICES,
default=constants.PRODUCT_TYPE_ACTUAL)
price = models.IntegerField('兑换价格(积分)')
origin_price = models.FloatField('原价')
image = models.ImageField('主图',upload_to='product')
buy_link = models.CharField('购买链接', max_length=256,null=True,blank=True)
reorder = models.SmallIntegerField('排序',default=0)
status = models.SmallIntegerField('商品状态',default=constants.PRODUCT_STATUS_OFF,
choices=constants.PRODUCT_STATUS_CHOICES)
sku_count = models.IntegerField('库存',default=0)
remain_count = models.IntegerField('剩余库存',default=0)
view_count = models.IntegerField('浏览次数',default=0)
score = models.FloatField('商品的评分',default=10.0)
is_valid = models.BooleanField('是否有效', default=True)
created_at = models.DateTimeField('创建时间', auto_now_add=True)
updated_at = models.DateTimeField('修改时间', auto_now=True)
class Meta:
db_table = 'mall_product'
ordering = ['-reorder']
utils\constants.py
# 系统模块-轮播图配置
SLIDER_TYPE_INDEX = 11
SLIDER_TYPES_CHOICES = (
(SLIDER_TYPE_INDEX, '首页'),
)
# 系统模块-新闻通知
NEWS_TYPE_NEW = 11
NEWS_TYPE_NOTICE = 12
NEWS_TYPE_CHOICES = (
(NEWS_TYPE_NEW,'新闻'),
(NEWS_TYPE_NOTICE,'通知'),
)
# 商品的类型
PRODUCT_TYPE_ACTUAL = 11
PRODUCT_TYPE_VIRTUAL = 12
PRODUCT_TYPES_CHOICES = (
(PRODUCT_TYPE_ACTUAL, '实物商品'),
(PRODUCT_TYPE_VIRTUAL, '虚拟商品'),
)
# 商品的状态
PRODUCT_STATUS_SELL = 11
PRODUCT_STATUS_LOST = 12
PRODUCT_STATUS_OFF = 13
PRODUCT_STATUS_CHOICES = (
(PRODUCT_STATUS_SELL,'销售中'),
(PRODUCT_STATUS_LOST,'已售完'),
(PRODUCT_STATUS_OFF,'已下架'),
)
商品分类
mall\models.py
class Tag(models.Model):
""" 商品的标签 """
uid = models.UUIDField('标签ID',default=uuid.uuid4, editable=False)
img = models.ImageField('主图',upload_to='tags',null=True,blank=True)
code = models.CharField('编码',max_length=32,null=True,blank=True)
name = models.CharField('名称', max_length=128)
reorder = models.SmallIntegerField('排序', default=0)
is_valid = models.BooleanField('是否有效', default=True)
created_at = models.DateTimeField('创建时间', auto_now_add=True)
updated_at = models.DateTimeField('修改时间', auto_now=True)
class Meta:
db_table = 'mall_tag'
class Classify(models.Model):
""" 商品的分类 """
uid = models.UUIDField('分类ID',default=uuid.uuid4, editable=False)
parent = models.ForeignKey('self',related_name='children')
img = models.ImageField('分类主图',upload_to='classify')
code = models.CharField('编码',max_length=32,null=True,blank=True)
name = models.CharField('名称', max_length=128)
desc = models.CharField('描述', max_length=64, null=True, blank=True)
reorder = models.SmallIntegerField('排序', default=0)
is_valid = models.BooleanField('是否有效', default=True)
created_at = models.DateTimeField('创建时间', auto_now_add=True)
updated_at = models.DateTimeField('修改时间', auto_now=True)
class Meta:
db_table = 'mall_classify'
让商品关联标签和分类
class Product(models.Model):
""" 商品 """
uid = models.UUIDField('商品ID',default=uuid.uuid4,editable=False)
name = models.CharField('商品名称', max_length=128)
desc = models.CharField('简单描述',max_length=256,null=True,blank=True)
content = models.TextField('商品描述')
type = models.SmallIntegerField('商品类型',
choices=constants.PRODUCT_TYPES_CHOICES,
default=constants.PRODUCT_TYPE_ACTUAL)
price = models.IntegerField('兑换价格(积分)')
origin_price = models.FloatField('原价')
image = models.ImageField('主图',upload_to='product')
buy_link = models.CharField('购买链接', max_length=256,null=True,blank=True)
reorder = models.SmallIntegerField('排序',default=0)
status = models.SmallIntegerField('商品状态',default=constants.PRODUCT_STATUS_OFF,
choices=constants.PRODUCT_STATUS_CHOICES)
sku_count = models.IntegerField('库存',default=0)
remain_count = models.IntegerField('剩余库存',default=0)
view_count = models.IntegerField('浏览次数',default=0)
score = models.FloatField('商品的评分',default=10.0)
is_valid = models.BooleanField('是否有效', default=True)
created_at = models.DateTimeField('创建时间', auto_now_add=True)
updated_at = models.DateTimeField('修改时间', auto_now=True)
tags = models.ManyToManyField(Tag, verbose_name='标签',
related_name='tags')
classes = models.ManyToManyField(Classify, verbose_name='分类',
related_name='tags')
class Meta:
db_table = 'mall_product'
ordering = ['-reorder']
定义图片模型
system\models.py
class ImageFile(models.Model):
""" 图片表 """
# 201902/xxx
img = models.ImageField('图片',upload_to='%Y%m/images/')
summary = models.CharField('图片名称',max_length=200)
# 复合关联
content_type = models.ForeignKey(ContentType)
object_id = models.PositiveIntegerField()
content_object = GenericForeignKey('content_type','object_id')
is_valid = models.BooleanField('是否删除', default=True)
created_at = models.DateTimeField('创建时间', auto_now_add=True)
updated_at = models.DateTimeField('最后修改时间', auto_now=True)
class Meta:
db_table = 'system_images'
商品关联图片
class Product(models.Model):
""" 商品 """
uid = models.UUIDField('商品ID',default=uuid.uuid4,editable=False)
name = models.CharField('商品名称', max_length=128)
desc = models.CharField('简单描述',max_length=256,null=True,blank=True)
content = models.TextField('商品描述')
type = models.SmallIntegerField('商品类型',
choices=constants.PRODUCT_TYPES_CHOICES,
default=constants.PRODUCT_TYPE_ACTUAL)
price = models.IntegerField('兑换价格(积分)')
origin_price = models.FloatField('原价')
image = models.ImageField('主图',upload_to='product')
buy_link = models.CharField('购买链接', max_length=256,null=True,blank=True)
reorder = models.SmallIntegerField('排序'