/tests/regressiontests/aggregation_regress/models.py

https://code.google.com/p/mango-py/ · Python · 65 lines · 45 code · 19 blank · 1 comment · 0 complexity · d2f383136ff129842cbdff9959360575 MD5 · raw file

  1. # coding: utf-8
  2. from django.db import models
  3. class Author(models.Model):
  4. name = models.CharField(max_length=100)
  5. age = models.IntegerField()
  6. friends = models.ManyToManyField('self', blank=True)
  7. def __unicode__(self):
  8. return self.name
  9. class Publisher(models.Model):
  10. name = models.CharField(max_length=255)
  11. num_awards = models.IntegerField()
  12. def __unicode__(self):
  13. return self.name
  14. class Book(models.Model):
  15. isbn = models.CharField(max_length=9)
  16. name = models.CharField(max_length=255)
  17. pages = models.IntegerField()
  18. rating = models.FloatField()
  19. price = models.DecimalField(decimal_places=2, max_digits=6)
  20. authors = models.ManyToManyField(Author)
  21. contact = models.ForeignKey(Author, related_name='book_contact_set')
  22. publisher = models.ForeignKey(Publisher)
  23. pubdate = models.DateField()
  24. class Meta:
  25. ordering = ('name',)
  26. def __unicode__(self):
  27. return self.name
  28. class Store(models.Model):
  29. name = models.CharField(max_length=255)
  30. books = models.ManyToManyField(Book)
  31. original_opening = models.DateTimeField()
  32. friday_night_closing = models.TimeField()
  33. def __unicode__(self):
  34. return self.name
  35. class Entries(models.Model):
  36. EntryID = models.AutoField(primary_key=True, db_column='Entry ID')
  37. Entry = models.CharField(unique=True, max_length=50)
  38. Exclude = models.BooleanField()
  39. class Clues(models.Model):
  40. ID = models.AutoField(primary_key=True)
  41. EntryID = models.ForeignKey(Entries, verbose_name='Entry', db_column = 'Entry ID')
  42. Clue = models.CharField(max_length=150)
  43. class HardbackBook(Book):
  44. weight = models.FloatField()
  45. def __unicode__(self):
  46. return "%s (hardback): %s" % (self.name, self.weight)