Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.70 KB | None | 0 0
  1. class Person(models.Model):
  2. first_name = models.CharField(max_length=100, blank=True, default='')
  3. middle_name = models.CharField(max_length=100, blank=True, default='')
  4. last_name = models.CharField(max_length=100, blank=True, default='')
  5. full_name = models.CharField(max_length=255, blank=True, default='')
  6. degree = models.CharField(max_length=100, blank=True, default='')
  7. email = models.EmailField(blank=False, unique=True)
  8.  
  9. class PersonNominationProfile(models.Model):
  10. person = models.ForeignKey('Person', null=False, blank=False, related_name='nomination_profile')
  11. person_type = models.ForeignKey('PersonType', default=None, null=True)
  12. status = models.ForeignKey(SpeakerStatus, related_name='status_nomination_profiles', blank=True, null=True, default=None)
  13. tier = models.ForeignKey('PersonTier', related_name='tier_nomination_profiles', default=None, null=True, blank=True)
  14. series = models.ForeignKey(Series, null=False, blank=False)
  15. year = models.IntegerField(null=True)
  16.  
  17. class PersonCertification(models.Model):
  18. nomination_profile = models.OneToOneField('PersonNominationProfile',null=False, blank=False)
  19. background_check_sent_date = models.DateField(auto_now_add=False,null=True)
  20. debarment_check_completed_date = models.DateField(auto_now_add=False,null=True)
  21. license_check_completed_date = models.DateField(auto_now_add=False,null=True)
  22.  
  23. all_speakers = Person.objects.filter(nomination_profile__person_type__name='Speaker')
  24. .values('id','nomination_profile__series_id', 'nomination_profile__series__name',
  25. 'last_name', 'first_name', 'middle_name', 'degree', 'email'))
  26.  
  27. 'nomination_profile__personcertification__background_check_sent_date'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement