Interface GroupRepository

  • All Superinterfaces:
    org.springframework.data.repository.CrudRepository<Group,​java.lang.Long>, org.springframework.data.repository.Repository<Group,​java.lang.Long>

    @Repository
    @AggregateBuilder
    public interface GroupRepository
    extends org.springframework.data.repository.CrudRepository<Group,​java.lang.Long>
    Database connection for groups.
    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      java.util.Optional<Group> findByGroupId​(java.util.UUID groupId)
      Find group by its uuid.
      java.util.List<Group> findByUser​(java.lang.String name)
      Get all groups where a given user is a member.
      • Methods inherited from interface org.springframework.data.repository.CrudRepository

        count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findAll, findAllById, findById, save, saveAll
    • Method Detail

      • findByGroupId

        @Query("SELECT * FROM group_table WHERE group_id =:groupId")
        java.util.Optional<Group> findByGroupId​(@Param("groupId")
                                                java.util.UUID groupId)
        Find group by its uuid.
        Parameters:
        groupId - group id
        Returns:
        optional group
      • findByUser

        @Query("SELECT * FROM group_table INNER JOIN group_member ON group_table.id = group_member.group_id WHERE group_member.name = :name")
        java.util.List<Group> findByUser​(@Param("name")
                                         java.lang.String name)
        Get all groups where a given user is a member.
        Parameters:
        name - user name
        Returns:
        list of groups