Pulling information from the postgres database

Administrators
1

Hello,
We are running Indico version 2.3.2 and have just over 8k events in our instance. The question about security for these events and any corresponding materials/contributions has come up and I’m wondering if there is an easy way to pull the following information from Indico via the back-end postgres database or the API:

  • print list of managers for every category
  • print permission mode setting for every category and event
  • best way to do a bulk change to the permission mode for every category in Indico (if we have to reset the permission mode globally to Protected)

Any help would be appreciated.

-Rafael

2

I would not recommend going straight to the database, but rather using indico shell. It’s basically a Python shell that has the Indico environment (DB access etc.) configured.

As a starting point for categories, you may be interested in this script: indico_email_insecure_cats.py · GitHub

3

Thanks for the response. Can you provide specific examples for pulling this information using indico shell ?

1 Like