def list_by_group(self): """ Returns a list of tuples (Permission, Group), only returns rows where permissions are used by a group. """ return DBSession.query(Permission, Group).join(Group.permissions)
def get_permissions(self): """ Returns a list of Permissions for this user based on their Groups. """ group_ids = [group.id for group in self.groups] return DBSession.query(Permission).join(Group.permissions).filter(Group.id.in_(group_ids))