Package sk.iway.iwcm.components.users.userdetail

Interface UserDetailsRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<UserDetailsEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<UserDetailsEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<UserDetailsEntity>, org.springframework.data.repository.PagingAndSortingRepository<UserDetailsEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<UserDetailsEntity>, org.springframework.data.repository.Repository<UserDetailsEntity,Long>

@Repository
public interface UserDetailsRepository
extends org.springframework.data.jpa.repository.JpaRepository<UserDetailsEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<UserDetailsEntity>

Method Summary

Modifier and Type	Method	Description
List<UserDetailsEntity>	findAllByAdmin(Boolean isAdmin)
org.springframework.data.domain.Page<UserDetailsEntity>	findAllByAdmin(Boolean admin, org.springframework.data.domain.Pageable pageable)
List<UserDetailsEntity>	findAllByEmailAndAdminTrueOrderByIdDesc(String email)
List<UserDetailsEntity>	findAllByEmailOrderByIdDesc(String email)
List<UserDetailsEntity>	findAllByIdIn(List<Long> ids)
UserDetailsEntity	findByEmail(String email)
List<UserDetailsEntity>	findByLoginAndAdminTrueOrderByIdDesc(String login)
List<UserDetailsEntity>	findByLoginOrderByIdDesc(String login)
String	getApiKeyByUserId(Long userId)
String	getMobileDeviceByUserId(Long userId)
String	getPasswordByUserId(Long userId)
String	getPasswordSaltByUserId(Long userId)
List<String>	getUserEmailsByUserGroupsIds(String groupId1, String groupId2, String groupId3, String groupId4)
List<Integer>	getUserIdsByUserGroupsIds(String groupId1, String groupId2, String groupId3, String groupId4)
void	updateEditableGroupsWritableFolders(String editableGroups, String writableFolders, Long userId)
void	updateMobileDeviceByUserId(Long userId, String mobileDevice)

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.jpa.repository.JpaSpecificationExecutor

count, findAll, findAll, findAll, findOne

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

findAll

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

count, exists, findAll, findBy, findOne

Method Details

findAllByAdmin

org.springframework.data.domain.Page<UserDetailsEntity> findAllByAdmin(Boolean admin,
 org.springframework.data.domain.Pageable pageable)

findAllByAdmin

List<UserDetailsEntity> findAllByAdmin(Boolean isAdmin)

getUserIdsByUserGroupsIds

@Query(value="SELECT user_id FROM users WHERE user_groups LIKE ?1 OR user_groups LIKE ?2 OR user_groups LIKE ?3 OR user_groups LIKE ?4",
       nativeQuery=true)
List<Integer> getUserIdsByUserGroupsIds(String groupId1,
 String groupId2,
 String groupId3,
 String groupId4)

getUserEmailsByUserGroupsIds

@Query(value="SELECT email FROM users WHERE user_groups LIKE ?1 OR user_groups LIKE ?2 OR user_groups LIKE ?3 OR user_groups LIKE ?4",
       nativeQuery=true)
List<String> getUserEmailsByUserGroupsIds(String groupId1,
 String groupId2,
 String groupId3,
 String groupId4)

getApiKeyByUserId

@Query(value="SELECT api_key FROM users WHERE user_id=?1",
       nativeQuery=true)
String getApiKeyByUserId(Long userId)

updateEditableGroupsWritableFolders

@Transactional
@Modifying
@Query("UPDATE UserDetailsEntity SET editableGroups = :editableGroups, writableFolders = :writableFolders WHERE id = :userId")
void updateEditableGroupsWritableFolders(@Param("editableGroups")
 String editableGroups,
 @Param("writableFolders")
 String writableFolders,
 @Param("userId")
 Long userId)

getMobileDeviceByUserId

@Query(value="SELECT mobile_device FROM users WHERE user_id=?1",
       nativeQuery=true)
String getMobileDeviceByUserId(Long userId)

getPasswordByUserId

@Query(value="SELECT password FROM users WHERE user_id=?1",
       nativeQuery=true)
String getPasswordByUserId(Long userId)

getPasswordSaltByUserId

@Query(value="SELECT password_salt FROM users WHERE user_id=?1",
       nativeQuery=true)
String getPasswordSaltByUserId(Long userId)

updateMobileDeviceByUserId

@Transactional
@Modifying
@Query(value="UPDATE users SET mobile_device = ?2 WHERE user_id = ?1",
       nativeQuery=true)
void updateMobileDeviceByUserId(Long userId,
 String mobileDevice)

findByEmail

UserDetailsEntity findByEmail(String email)

findAllByEmailOrderByIdDesc

List<UserDetailsEntity> findAllByEmailOrderByIdDesc(String email)

findByLoginOrderByIdDesc

List<UserDetailsEntity> findByLoginOrderByIdDesc(String login)

findAllByEmailAndAdminTrueOrderByIdDesc

List<UserDetailsEntity> findAllByEmailAndAdminTrueOrderByIdDesc(String email)

findByLoginAndAdminTrueOrderByIdDesc

List<UserDetailsEntity> findByLoginAndAdminTrueOrderByIdDesc(String login)

findAllByIdIn

@Query("SELECT u FROM UserDetailsEntity u WHERE u.id IN :ids")
List<UserDetailsEntity> findAllByIdIn(@Param("ids")
 List<Long> ids)