Create backend logic to list all role collections

[jeff1evesque]

Based on our #3208, we need to adjust necessary back python logic, to incorporate the following:

List Role Collections: list all collections associated with the current role.

SELECT Collection.CollectionName
FROM Collection
LEFT JOIN PermissionCollection ON PermissionCollection.CollectionID = Collection.CollectionID
LEFT JOIN Account ON Account.RoleID = PermissionCollection.RoleID
LEFT JOIN Role ON Role.RoleTypeID = RoleType.RoleTypeID
WHERE RoleType.RoleType = 'role-1'

The above implementation will likely occur in the applications backend code.

query = '''\
        SELECT Collection.CollectionName
        FROM Collection
        LEFT JOIN PermissionCollection ON PermissionCollection.CollectionID = Collection.CollectionID
        LEFT JOIN Account ON Account.RoleID = PermissionCollection.RoleID
        LEFT JOIN Role ON Role.RoleTypeID = RoleType.RoleTypeID
        WHERE RoleType.RoleType = %s
        '''
args = (current_user)
cur.execute(query, args)