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))
