- for wtem_contact in Contact.objects.filter(form_tag = 'wtem'):
- for student in wtem_contact.body['student']:
- if not Submission.objects.filter(email = student['email']).exists():
- args = dict()
- for attr in ['first_name', 'last_name', 'email']:
- args[attr] = student[attr]
- args['contact'] = wtem_contact
- Submission.create(**args)
- new += 1
- else:
- skipped += 1
+ emails = list(Submission.objects.values_list('email', flat=True))
+ for confirmation in Confirmation.objects.exclude(email__in=emails):
+ args = {}
+ for attr in ['first_name', 'last_name', 'email', 'contact']:
+ args[attr] = getattr(confirmation, attr)
+ Submission.create(**args)
+ new += 1