Package org.apache.syncope.core.persistence.jpa.dao.repo

Interface GroupRepo

All Superinterfaces:
AnyDAO<Group>, AnyRepoExt<Group>, DAO<Group>, GroupDAO, GroupRepoExt, org.springframework.data.repository.PagingAndSortingRepository<JPAGroup,String>, org.springframework.data.repository.Repository<JPAGroup,String>
public interface GroupRepo extends org.springframework.data.repository.PagingAndSortingRepository<JPAGroup,String>, GroupRepoExt, GroupDAO

  • Method Details

    • findKey

      @Query("SELECT e.id FROM #{#entityName} e WHERE e.name = :name") Optional<String> findKey(@Param("name") String name)
      Specified by:
      findKey in interface GroupDAO

    • findKeysByNamePattern

      @Query("SELECT e.id FROM #{#entityName} e WHERE LOWER(e.name) LIKE :pattern") List<String> findKeysByNamePattern(@Param("pattern") String pattern)
      Specified by:
      findKeysByNamePattern in interface GroupDAO

    • findByKeys

      @Query("SELECT e FROM #{#entityName} e WHERE e.id IN (:keys)") List<Group> findByKeys(@Param("keys") List<String> keys)
      Specified by:
      findByKeys in interface AnyDAO<Group>

    • findOwnedByGroup

      @Query("SELECT e FROM #{#entityName} e WHERE e.groupOwner.id = :groupKey") List<Group> findOwnedByGroup(@Param("groupKey") String groupKey)
      Specified by:
      findOwnedByGroup in interface GroupDAO

    • findAMembers

      @Query("SELECT DISTINCT e.leftEnd.id FROM JPAAMembership e WHERE e.rightEnd.id = :groupKey") List<String> findAMembers(@Param("groupKey") String groupKey)
      Specified by:
      findAMembers in interface GroupDAO

    • findUMembers

      @Query("SELECT DISTINCT e.leftEnd.id FROM JPAUMembership e WHERE e.rightEnd.id = :groupKey") List<String> findUMembers(@Param("groupKey") String groupKey)
      Specified by:
      findUMembers in interface GroupDAO

    • countAMembers

      @Query("SELECT COUNT(DISTINCT e.leftEnd.id) FROM JPAAMembership e WHERE e.rightEnd.id = :groupKey") long countAMembers(@Param("groupKey") String groupKey)
      Specified by:
      countAMembers in interface GroupDAO

    • countUMembers

      @Query("SELECT COUNT(DISTINCT e.leftEnd.id) FROM JPAUMembership e WHERE e.rightEnd.id = :groupKey") long countUMembers(@Param("groupKey") String groupKey)
      Specified by:
      countUMembers in interface GroupDAO