def _associate_users_by_email(self, event): # link objects to users by email where possible # event principals emails = [p.email for p in EventPrincipal.query.with_parent(event).filter_by(type=PrincipalType.email)] for user in User.query.filter(~User.is_deleted, User.all_emails.in_(emails)): EventPrincipal.replace_email_with_user(user, 'event') # session principals query = (SessionPrincipal.query .filter(SessionPrincipal.session.has(Session.event == event), SessionPrincipal.type == PrincipalType.email)) emails = [p.email for p in query] for user in User.query.filter(~User.is_deleted, User.all_emails.in_(emails)): SessionPrincipal.replace_email_with_user(user, 'session') # contribution principals query = (ContributionPrincipal.query .filter(ContributionPrincipal.contribution.has(Contribution.event == event), ContributionPrincipal.type == PrincipalType.email)) emails = [p.email for p in query] for user in User.query.filter(~User.is_deleted, User.all_emails.in_(emails)): ContributionPrincipal.replace_email_with_user(user, 'contribution') # event persons query = EventPerson.query.with_parent(event).filter(EventPerson.user_id.is_(None), EventPerson.email != '') for person in query: person.user = get_user_by_email(person.email) # registrations for registration in Registration.query.with_parent(event).filter(Registration.user_id.is_(None)): registration.user = get_user_by_email(registration.email)
def _convert_email_principals(user, **kwargs): from indico.modules.events.contributions.models.principals import ContributionPrincipal contributions = ContributionPrincipal.replace_email_with_user(user, 'contribution') if contributions: num = len(contributions) flash(ngettext("You have been granted manager/submission privileges for a contribution.", "You have been granted manager/submission privileges for {} contributions.", num).format(num), 'info')