Changing several group names for external identity provider (ldap)

1

Hi all
we’re trying to rename group names.

We didnt find a way to do that via indico api’s, so simply we would like to do an update on the indico db in the following tables

attachments.attachment_principals
attachments.folder_principals
categories.principals
events.contribution_principals
events.principals
events.session_principals
events.track_principals
events.settings_principals
indico.settings_principals
roombooking.blocking_principals
roombooking.room_principals

We did some tests and everything seems fine
Do you see any problem renaming the groups in this way?

Thanks
Nicola

2

Here’s an easier option via indico shell:

from indico.core.db.sqlalchemy.principals import PrincipalMixin, PrincipalPermissionsMixin, PrincipalType

models = [sc for sc in [*PrincipalMixin.__subclasses__(), *PrincipalPermissionsMixin.__subclasses__()]
          if hasattr(sc, 'query')]

for model in models:
    query = model.query.filter_by(type=PrincipalType.multipass_group, multipass_group_name='OLD-NAME')
    query.update({model.multipass_group_name: 'NEW-NAME'})

db.session.commit()
3

Thanks it works like a charm