django项目实战笔记（二）

用户账户模块

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('排序'