class ImageFile(models.StandaloneModel):
filedata = models.FileField(upload_to='images/')
checksum = models.CharField(max_length=100)
checksumtype = models.CharField(max_length=10)
class Meta:
db_table = 'release_imagefile'
def __unicode__(self):
return os.path.basename(self.filedata.file.name)
class MailGroup(models.StandaloneModel):
name = models.CharField(max_length=20, unique=True)
status = models.CharField(max_length=1) # This is same as version status
type = models.CharField(max_length=5) # TO/BCC/CC
project = models.ManyToManyField(Project)
class Meta:
db_table = 'release_mailgroup'
def __unicode__(self):
return self.name
class Version(models.StandaloneModel):
name = models.CharField(max_length=30)
project = models.ForeignKey(Project)
filename = models.OneToOneField(ImageFile)
status = models.CharField(max_length=1, default='N')
releasename = models.CharField(max_length=30, blank=True, null=True)
class Meta:
db_table = 'release_version'
def __unicode__(self):
return self.name
class Changelog(models.StandaloneModel):
key = models.CharField(max_length=200, unique=True)
author = models.CharField(max_length=100)
author_mail = models.EmailField()
date = models.DateTimeField()
subject = models.CharField(max_length=200)
content = models.TextField()
version = models.ManyToManyField(Version, blank=True, null=True)
class Meta:
db_table = 'release_changelog'
def __unicode__(self):
return self.key
class TestDomain(models.StandaloneModel):
id = models.IntegerField(primary_key=True)
name = models.CharField(max_length=600)
order = models.IntegerField()
class Meta:
db_table = u'testcase_testdomain'
class Project(models.StandaloneModel):
name = models.CharField(max_length=20, unique=True)
class Meta:
db_table = 'release_project'
def __unicode__(self):
return self.name
class MyModel(models.StandaloneModel):
col1 = models.CharField(max_length=1000)
col2 = models.IntegerField()
col3 = models.BooleanField()
def __unicode__(self):
return self.col1
class TestFunction(models.StandaloneModel):
id = models.IntegerField(primary_key=True)
name = models.CharField(max_length=600)
domain = models.ForeignKey(TestDomain)
order = models.IntegerField()
class Meta:
db_table = u'testcase_testfunction'
class TestItem(models.StandaloneModel):
id = models.IntegerField(primary_key=True)
name = models.CharField(max_length=600)
function = models.ForeignKey(TestFunction)
is_autotest = models.IntegerField()
order = models.IntegerField()
class Meta:
db_table = u'testcase_testitem'
class MailUser(models.StandaloneModel):
name = models.CharField(max_length=20, unique=True)
email = models.EmailField(unique=True)
groups = models.ManyToManyField(MailGroup)
class Meta:
db_table = 'release_mailuser'
def __unicode__(self):
return self.name
class TestResult(models.StandaloneModel):
id = models.IntegerField(primary_key=True)
version = models.ForeignKey(Version)
result = models.FileField(upload_to='result/')
result_log = models.FileField(upload_to='result/')
result_manual = models.FileField(upload_to='result/',
blank=True,
null=True)
client = models.CharField(max_length=50)
create_date = models.DateTimeField(auto_now_add=True)
modify_date = models.DateTimeField(auto_now=True)
test_item = models.IntegerField()
test_pass = models.IntegerField()
test_failed = models.IntegerField()
class Meta:
db_table = u'testcase_testresult'
class MyOtherModel(models.StandaloneModel):
col1 = models.CharField(max_length=100)
col2 = models.ForeignKey("standalone.MyModel")
class Plugin(models.StandaloneModel):
#plugin_name = models.CharField(max_length=250)
plugin_id = models.BigIntegerField(max_length=250, primary_key=True)
plugin_file_name = models.CharField(max_length=255)
family = models.ForeignKey(Families)
class Families(models.StandaloneModel):
family_name = models.CharField(max_length=250, primary_key=True)
