models.py 2.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
  1. from django.db import models
  2. try:
  3. from PIL import Image
  4. except ImportError:
  5. Image = None
  6. class CaseTestModel(models.Model):
  7. integer = models.IntegerField()
  8. integer2 = models.IntegerField(null=True)
  9. string = models.CharField(max_length=100, default='')
  10. big_integer = models.BigIntegerField(null=True)
  11. binary = models.BinaryField(default=b'')
  12. boolean = models.BooleanField(default=False)
  13. date = models.DateField(null=True, db_column='date_field')
  14. date_time = models.DateTimeField(null=True)
  15. decimal = models.DecimalField(max_digits=2, decimal_places=1, null=True, db_column='decimal_field')
  16. duration = models.DurationField(null=True)
  17. email = models.EmailField(default='')
  18. file = models.FileField(null=True, db_column='file_field')
  19. file_path = models.FilePathField(null=True)
  20. float = models.FloatField(null=True, db_column='float_field')
  21. if Image:
  22. image = models.ImageField(null=True)
  23. generic_ip_address = models.GenericIPAddressField(null=True)
  24. null_boolean = models.BooleanField(null=True)
  25. null_boolean_old = models.NullBooleanField()
  26. positive_integer = models.PositiveIntegerField(null=True)
  27. positive_small_integer = models.PositiveSmallIntegerField(null=True)
  28. positive_big_integer = models.PositiveSmallIntegerField(null=True)
  29. slug = models.SlugField(default='')
  30. small_integer = models.SmallIntegerField(null=True)
  31. text = models.TextField(default='')
  32. time = models.TimeField(null=True, db_column='time_field')
  33. url = models.URLField(default='')
  34. uuid = models.UUIDField(null=True)
  35. fk = models.ForeignKey('self', models.CASCADE, null=True)
  36. def __str__(self):
  37. return "%i, %s" % (self.integer, self.string)
  38. class O2OCaseTestModel(models.Model):
  39. o2o = models.OneToOneField(CaseTestModel, models.CASCADE, related_name='o2o_rel')
  40. integer = models.IntegerField()
  41. def __str__(self):
  42. return "%i, %s" % (self.id, self.o2o)
  43. class FKCaseTestModel(models.Model):
  44. fk = models.ForeignKey(CaseTestModel, models.CASCADE, related_name='fk_rel')
  45. integer = models.IntegerField()
  46. def __str__(self):
  47. return "%i, %s" % (self.id, self.fk)
  48. class Client(models.Model):
  49. REGULAR = 'R'
  50. GOLD = 'G'
  51. PLATINUM = 'P'
  52. ACCOUNT_TYPE_CHOICES = (
  53. (REGULAR, 'Regular'),
  54. (GOLD, 'Gold'),
  55. (PLATINUM, 'Platinum'),
  56. )
  57. name = models.CharField(max_length=50)
  58. registered_on = models.DateField()
  59. account_type = models.CharField(
  60. max_length=1,
  61. choices=ACCOUNT_TYPE_CHOICES,
  62. default=REGULAR,
  63. )
  64. def __str__(self):
  65. return self.name