Apollo snippet to updated submissions to use the same location as their participants

update_locations_on_submissions.py

from apollo.models import Event, Submission, Form

event_name = ''
form_name = ''

ev = Event.query.filter(Event.name==event_name).first()
form = Form.query.filter(Form.name==form_name).first()
to_fix = 0

for sb in Submission.query.filter(Submission.form==form, Submission.event==ev, Submission.submission_type=="O"):
    if sb.location != sb.participant.location:
        to_fix += 1

print("{} submission(s) to update...".format(to_fix))

for sb in Submission.query.filter(Submission.form==form, Submission.event==ev, Submission.submission_type=="O"):
    if sb.location != sb.participant.location:
        sb.location = sb.participant.location
        sb.master.location = sb.participant.location
        sb.master.save()
        sb.save()