SQL Functions

sql_functions.get_assistants_as_dicts(assistants)

Converts a list of assistant objects to a list of dictionaries containing assistant IDs and names.

• Parameters: assistants (list) – A list of assistant objects.
• Returns: A list of dictionaries where each dictionary represents an assistant with Id and Name keys.
• Return type: list of dict

sql_functions.get_roles_as_dicts(roles)

Converts a list of role objects to a list of dictionaries containing role IDs and names.

• Parameters: roles (list) – A list of role objects.
• Returns: A list of dictionaries where each dictionary represents a role with Id and Name keys.
• Return type: list of dict