contenttypes 是Django内置的一个应用，可以追踪项目中所有app和model的对应关系，并记录在ContentType表中。
models.py文件的表结构写好后，通过makemigrations和migrate两条命令迁移数据后，在数据库中会自动生成一个django_content_type表：
每当我们创建了新的model并执行数据库迁移后，ContentType表中就会自动新增一条记录。比如我在应用api的models.py中创建表class Electrics(models.Model): pass。从数据库查看ContentType表，显示如下：
ContentType GenericRelation GenericForeignKey示例
#!/usr/bin/python3
# -*- coding:utf-8 -*-
# __author__ = '__Jack__'
from __future__ import unicode_literals
import uuid
from collections import Counter
from django.conf import settings
from django.contrib.contenttypes.models import ContentType
from django.contrib.contenttypes.fields import GenericRelation, GenericForeignKey
from django.db import models
from slugify import slugify
from markdownx.models import MarkdownxField
from taggit.managers import TaggableManager
from markdownx.utils import markdownify
class Vote(models.Model):
"""使用Django中的ContentType, 同时关联用户对问题和回答的投票
投票
"""
uuid_id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
user = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='qa_vote',
on_delete=models.CASCADE, verbose_name='用户')
value = models.BooleanField(default=True, verbose_name='赞同或反对') # True赞同，False反对
# GenericForeignKey设置
content_type = models.ForeignKey(ContentType, related_name='votes_on', on_delete=models.CASCADE)
object_id = models.CharField(max_length=255)
vote = GenericForeignKey('content_type', 'object_id') # 等同于GenericForeignKey()
created_at = models.DateTimeField(auto_now_add=True, verbose_name='创建时间')
updated_at = models.DateTimeField(auto_now=True, verbose_name='更新时间')
class Meta:
verbose_name = '投票'
verbose_name_plural = verbose_name
unique_together = ('user', 'content_type', 'object_id') # 联合唯一键
# SQL优化
index_together = ('content_type', 'object_id') # 联合唯一索引
class QuestionQuerySet(models.query.QuerySet):
"""自定义QuerySet，提高模型类的可用性"""
def get_answered(self):
"""已有答案的问题"""
return self.filter(has_answer=True).select_related('user')
def get_unanswered(self):
"""未被的回答的问题"""
return self.filter(has_answer=False).select_related('user')
def get_counted_tags(self):
"""统计所有问题标签的数量(大于0的)"""
tag_dict = {}
for obj in self.all():
for tag in obj.tags.names():
if tag not in tag_dict:
tag_dict[tag] = 1
else:
tag_dict[tag] += 1
return tag_dict.items()
class Question(models.Model):
'''问题'''
STATUS = (("O", "Open"), ("C", "Close"), ("D", "Draft"))
user = models.ForeignKey(settings.AUTH_USER_MODEL, related_name="q_author",
on_delete=models.CASCADE, verbose_name='提问者', default=1)
title = models.CharField(max_length=255, unique=True, verbose_name='标题')
slug = models.SlugField(max_length=80, null=True, blank=True, verbose_name='(URL)别名')
status = models.CharField(max_length=1, choices=STATUS, default='O',
verbose_name='问题状态')
content = MarkdownxField(verbose_name='内容')
tags = TaggableManager(help_text='多个标签使用,(英文)隔开', verbose_name='标签')
has_answer = models.BooleanField(default=False, verbose_name="接受回答") # 是否有接受的回答
votes = GenericRelation(Vote, verbose_name='投票情况') # 通过GenericRelation关联到Vote表，不是实际的字段
created_at = models.DateTimeField(db_index=True, auto_now_add=True, verbose_name='创建时间')
updated_at = models.DateTimeField(auto_now=True, verbose_name='更新时间')
objects = QuestionQuerySet.as_manager()
class Meta:
verbose_name = '问题'
verbose_name_plural = verbose_name
ordering = ("-created_at",)
def save(self, *args, **kwargs):
if not self.slug:
self.slug = slugify(self.title)
super(Question, self).save(*args, **kwargs)
def __str__(self):
return self.title
def get_markdown(self):
return markdownify(self.content)
def total_votes(self):
"""得票数"""
dic = Counter(self.votes.values_list('value', flat=True)) # Counter赞同票多少，反对票少数
return dic[True] - dic[False]
def get_answers(self):
"""获取所有的回答"""
return Answer.objects.filter(question=self).select_related('user', 'question') # self作为参数，当前的问题有多少个回答
def count_answers(self):
"""回答的数量"""
return self.get_answers().count()
def get_upvoters(self):
"""赞同的用户"""
return [vote.user for vote in self.votes.filter(value=True).select_related('user').prefetch_related('vote')]
def get_downvoters(self):
"""反对的用户"""
return [vote.user for vote in self.votes.filter(value=False).select_related('user').prefetch_related('vote')]
class Answer(models.Model):
'''回答'''
uuid_id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
user = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='a_author', on_delete=models.CASCADE,
verbose_name='回答者')
question = models.ForeignKey(Question, on_delete=models.CASCADE, verbose_name='问题')
content = MarkdownxField(verbose_name='内容')
is_answer = models.BooleanField(default=False, verbose_name='回答是否被接受')
votes = GenericRelation(Vote, verbose_name='投票情况')
created_at = models.DateTimeField(db_index=True, auto_now_add=True, verbose_name='创建时间')
updated_at = models.DateTimeField(auto_now=True, verbose_name='更新时间')
class Meta:
ordering = ('-is_answer', '-created_at') # 多字段排序
verbose_name = '回答'
verbose_name_plural = verbose_name
def __str__(self):
return self.content
def get_markdown(self):
return markdownify(self.content)
def total_votes(self):
"""得票数"""
dic = Counter(self.votes.values_list('value', flat=True)) # Counter赞同票多少，反对票少数
return dic[True] - dic[False]
def get_upvoters(self):
"""赞同的用户"""
return [vote.user for vote in self.votes.filter(value=True).select_related('user').prefetch_related('vote')]
def get_downvoters(self):
"""反对的用户"""
return [vote.user for vote in self.votes.filter(value=False).select_related('user').prefetch_related('vote')]
def accept_answer(self):
"""接受回答"""
# 当一个问题有多个回答的时候，只能采纳一个回答，其它回答一律置为未接受
answer_set = Answer.objects.filter(question=self.question) # 查询当前问题的所有回答
answer_set.update(is_answer=False) # 一律置为未接受
# 接受当前回答并保存
self.is_answer = True
self.save()
# 该问题已有被接受的回答，保存
self.question.has_answer = True
self.question.save()
# 1.需要返回查询集的逻辑写在QuerySetModel中
# 2.模型类中数据库处理的逻辑写在Models中
# 3.业务相关逻辑的处理写在Views中