Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Person(models.Model):
- first_name = models.CharField(max_length=100, blank=True, default='')
- middle_name = models.CharField(max_length=100, blank=True, default='')
- last_name = models.CharField(max_length=100, blank=True, default='')
- full_name = models.CharField(max_length=255, blank=True, default='')
- degree = models.CharField(max_length=100, blank=True, default='')
- email = models.EmailField(blank=False, unique=True)
- class PersonNominationProfile(models.Model):
- person = models.ForeignKey('Person', null=False, blank=False, related_name='nomination_profile')
- person_type = models.ForeignKey('PersonType', default=None, null=True)
- status = models.ForeignKey(SpeakerStatus, related_name='status_nomination_profiles', blank=True, null=True, default=None)
- tier = models.ForeignKey('PersonTier', related_name='tier_nomination_profiles', default=None, null=True, blank=True)
- series = models.ForeignKey(Series, null=False, blank=False)
- year = models.IntegerField(null=True)
- class PersonCertification(models.Model):
- nomination_profile = models.OneToOneField('PersonNominationProfile',null=False, blank=False)
- background_check_sent_date = models.DateField(auto_now_add=False,null=True)
- debarment_check_completed_date = models.DateField(auto_now_add=False,null=True)
- license_check_completed_date = models.DateField(auto_now_add=False,null=True)
- all_speakers = Person.objects.filter(nomination_profile__person_type__name='Speaker')
- .values('id','nomination_profile__series_id', 'nomination_profile__series__name',
- 'last_name', 'first_name', 'middle_name', 'degree', 'email'))
- 'nomination_profile__personcertification__background_check_sent_date'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement