Django模型/数据库设计用于子类
好吧,我不太擅长描述。这里有一个关系图。
在Django中,我创建了我的模型,如下所示:
from django.db import models
from datetime import datetime
class Survey(models.Model):
name = models.CharField(max_length=100)
pub_date = models.DateTimeField('date published',default=datetime.now)
def __unicode__(self):
return self.name
# This model should be abstracted by a more specific model
class Section(models.Model):
survey = models.ForeignKey(Survey)
name = models.CharField(max_length=100)
def __unicode__(self):
return self.name
# Models for supporting the 'ratings' mode
class RatingSection(Section):
pass
class RatingQuestion(models.Model):
section = models.ForeignKey(RatingSection)
name = models.CharField(max_length=255)
def __unicode__(self):
return self.name
class RatingAnswer(models.Model):
section = models.ForeignKey(RatingSection)
name = models.CharField(max_length=60)
def __unicode__(self):
return self.name
class RatingVotes(models.Model):
question = models.ForeignKey(RatingQuestion)
answer = models.ForeignKey(RatingAnswer)
votes = models.PositiveIntegerField(default=0)
def __unicode__(self):
return self.votes + self.answer.name + ' votes for ' + self.question.name
# Models for supporting the 'multichoice' mode
class MultiChoiceSection(Section):
can_select_multiple = models.BooleanField()
class MultiChoiceQuestion(models.Model):
section = models.ForeignKey(MultiChoiceSection)
name = models.CharField(max_length=255)
def __unicode__(self):
return self.name
class MultiChoiceAnswer(models.Model):
section = models.ForeignKey(MultiChoiceSection)
name = models.CharField(max_length=60)
votes = models.PositiveIntegerField(default=0)
def __unicode__(self):
return self.name
问题是我几乎可以肯定这样做不是正确的方式,即使是这样,我也不知道怎么让Django的管理区域显示一个选项,让用户选择他们想要的子类型部分。
那么,构建这种模型的最佳方式是什么呢?
1 个回答
0
你可以有一个叫做“section”的类,里面有一个属性叫做 type
,这个属性可以是“rating”(评分)或者“multiplechoice”(多选)——在管理界面中会显示为一个下拉框。
不过我觉得你应该看看Django提供的创建抽象模型的功能:http://docs.djangoproject.com/en/dev/topics/db/models/#id6
class Section(models.Model):
survey = models.ForeignKey(Survey)
name = models.CharField(max_length=100)
class Meta:
abstract = True # no db table created for this model
def __unicode__(self):
return self.name
class RatingSection(Section):
pass
class MultiChoiceSection(Section):
can_select_multiple = models.BooleanField()