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.models.principals import EventPrincipal
events = EventPrincipal.replace_email_with_user(user, 'event')
if events:
num = len(events)
flash(ngettext("You have been granted manager/submission privileges for an event.",
"You have been granted manager/submission privileges for {} events.", num).format(num), 'info')
def test_convert_email_principals_merge(db, create_event, create_user):
event = create_event()
user = create_user(123, email='*****@*****.**')
principal = EmailPrincipal('*****@*****.**')
entry1 = event.update_principal(user, full_access=True, roles={'foo', 'foobar'})
entry2 = event.update_principal(principal, read_access=True, roles={'foo', 'bar'})
# different emails for now -> nothing updated
assert not EventPrincipal.replace_email_with_user(user, 'event_new')
assert set(event.acl_entries) == {entry1, entry2}
user.secondary_emails.add(principal.email)
assert EventPrincipal.replace_email_with_user(user, 'event_new') == {event}
assert len(event.acl_entries) == 1
entry = list(event.acl_entries)[0]
assert entry.full_access
assert entry.read_access
assert set(entry.roles) == {'foo', 'bar', 'foobar'}
def _convert_email_principals(user, **kwargs):
from indico.modules.events.models.principals import EventPrincipal
events = EventPrincipal.replace_email_with_user(user, 'event')
if events:
num = len(events)
flash(ngettext("You have been granted manager/submission privileges for an event.",
"You have been granted manager/submission privileges for {} events.", num).format(num), 'info')
def test_convert_email_principals(db, create_event, create_user, dummy_user):
event = create_event()
user = create_user(123, email='*****@*****.**')
principal = EmailPrincipal('*****@*****.**')
other_entry = event.update_principal(dummy_user, full_access=True, roles={'foo', 'foobar'})
entry = event.update_principal(principal, read_access=True, roles={'foo', 'bar'})
other_entry_data = other_entry.current_data
entry_data = entry.current_data
# different emails for now -> nothing updated
assert not EventPrincipal.replace_email_with_user(user, 'event_new')
assert set(event.acl_entries) == {entry, other_entry}
user.secondary_emails.add(principal.email)
assert EventPrincipal.replace_email_with_user(user, 'event_new') == {event}
assert set(event.acl_entries) == {entry, other_entry}
assert all(x.type == PrincipalType.user for x in event.acl_entries)
db.session.expire(other_entry)
db.session.expire(entry)
assert entry.current_data == entry_data
assert other_entry.current_data == other_entry_data