UserRepository

/**
 * Spring Data JPA repository for the User entity.
 */

public interface UserRepository extends EntityGraphJpaRepository<User, Long> {

    Optional<User> findOneByActivationKey(String activationKey);

    List<User> findAllByActivatedIsFalseAndCreatedDateBefore(ZonedDateTime dateTime);

    Optional<User> findOneByResetKey(String resetKey);

    Optional<User> findOneByEmail(String email);

    Optional<User> findOneByLogin(String login);

    @Query(value = "select distinct user from User user left join fetch user.authorities",
        countQuery = "select count(user) from User user")
    Page<User> findAllWithAuthorities(Pageable pageable);

    @Query("SELECT new com.evasyst.api.web.rest.vm.ManagedUserVM(user) FROM User user")
    Page<ManagedUserVM> findAllUsersPaginated(Pageable pageable);

    Integer countByOnline(Boolean online);

    Optional<User> findOneByUserProfile(UserProfile userProfile);

    List<User> findAllByTestData(Boolean testdata);


}