query

# models.py
class Member(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE, null=True, blank=True)
    member_url = models.CharField(editable=False, default=uuid.uuid4, max_length=150)
    member_summary = RichTextField(blank=True)
    member_first_name = models.CharField(max_length=100, help_text="Your first name")
    member_last_name = models.CharField(max_length=100, help_text="Your first name")


class MemberEducation(models.Model):
    user = models.ForeignKey(Member, on_delete=models.CASCADE, blank=True, null=True)

    # gua perlu dapetin 3 field ini, yang latestnya... 
    member_degree_name = models.CharField(choices=EDUCATION_TYPE, max_length=50)
    member_school_name = models.CharField(blank=False, max_length=100)
    member_major_name = models.CharField(blank=True, null=True, max_length=100)


# model ini dipake buat informasi event nya...
class Graduation(models.Model):
    graduation_name = models.CharField(max_length=100, help_text='Title/Name')
    graduation_url = models.CharField(editable=False, default=uuid.uuid4, max_length=150)


# model ini dipake buat nyimpen relasinya. karena 1 event bisa punya banyak members.
class GraduationQueue(models.Model):
    member_graduation = models.ForeignKey(Member, on_delete=models.CASCADE)
    graduation_choice = models.ForeignKey(Graduation, on_delete=models.CASCADE)
    

# views.py    
# posisinya sekarang gua lagi di model `Graduation` detail, karena di setiap graduation detail ini punya banyak member...
# dan setiap member ini punya jurusan masing2... 
@login_required(login_url=reverse_lazy('login'))
def graduation_details(request, graduation_url):
    graduate = get_object_or_404(Graduation, graduation_url=graduation_url)
    members = GraduationQueue.objects.filter(graduation_choice=graduate)
    
    
    
# gua posisinya sekarang lagi di model