Package mops.persistence
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.
-
-
-
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
-
-