python - Retrieving objects from many-to-many column and placing into new table -

python - Retrieving objects from many-to-many column and placing into new table -

i have event table holds 2 types of attendees: students , staff. how go retrieving in pupil column(many-to-many) , placing them own table?

class event(models.model): ... students = models.manytomanyfield(studentprofile, null=true, blank=true) staff = models.manytomanyfield(staffprofile, null=true, blank=true) ...

new table: ?

class studentattendees(models.model): profile = models.manytomanyfield(studentprofile, through='event') event = models.foreignkey(event) created = models.datetimefield(auto_now_add=true)

returns:

django.core.management.base.commanderror: 1 or more models did not validate: profiles.studentattendees: 'profile' manually-defined m2m relation through model event, not have foreign keys studentprofile , studentattendees

thanks help in advance.

something might work:

for some_event in event.objects.all(): student_attendees_object = studentattendees.objects.create(event=some_event) pupil in some_event.students_set.all(): student_attendees_objects.profile.add(student)

i don't know you're trying accomplish, if need info on pupil attendees, might wanna intermediate table through parameter. check out documentation on this.

python django django-models many-to-many