Package edu.cnm.deepdive.teamassignments.model.dao

Interface UserRepository

All Superinterfaces:

CrudRepository<User,Long>, JpaRepository<User,Long>, PagingAndSortingRepository<User,Long>, QueryByExampleExecutor<User>, Repository<User,Long>

public interface UserRepository
extends JpaRepository<User,Long>

repository used for User class.

Method Summary

Modifier and Type	Method	Description
Iterable<User>	findAllByGroupsContainingAndTasksNotCompletedAndOverdue(Group group, boolean completed, Date cutoff)
Iterable<User>	findAllByGroupsNotEmptyOrderByDisplayNameAsc()
Iterable<User>	findAllUserInMyGroups(User user)
Iterable<User>	findAllUsersInMyOwnGroups(User owner)
Optional<User>	findFirstByOauthKey(String oauthKey)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, saveAll, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

Method Details

findFirstByOauthKey

Optional<User> findFirstByOauthKey(String oauthKey)

findAllByGroupsContainingAndTasksNotCompletedAndOverdue

@Query("select distinct u from User as u inner join u.groups as g inner join g.tasks as t where g = :group and t.completed = :completed and t.dueDate < :cutoff and t.user = u order by u.displayName")
Iterable<User> findAllByGroupsContainingAndTasksNotCompletedAndOverdue(Group group,
 boolean completed,
 Date cutoff)

findAllByGroupsNotEmptyOrderByDisplayNameAsc

Iterable<User> findAllByGroupsNotEmptyOrderByDisplayNameAsc()

findAllUsersInMyOwnGroups

@Query("select distinct u from User as u inner join u.groups as g where g.owner = :owner order by u.displayName")
Iterable<User> findAllUsersInMyOwnGroups(User owner)

findAllUserInMyGroups

@Query("select distinct u1 from User as u1 inner join u1.groups as g inner join g.users as u2 where u1 <> u2 and u1 = :user order by u1.displayName")
Iterable<User> findAllUserInMyGroups(User user)