@Repository public interface UserRepository extends org.springframework.data.jpa.repository.JpaRepository<User,java.lang.Integer>
| Modifier and Type | Method and Description |
|---|---|
java.util.List<User> |
findByActiveIsTrue() |
java.util.List<User> |
findByEmail(java.lang.String email) |
User |
findByEmailUnique(java.lang.String email) |
User |
findById(int id) |
java.util.List<User> |
findByIdIn(java.util.Set<java.lang.Integer> id) |
User |
findByLogin(java.lang.String login) |
User |
findByLoginAndActiveIsTrue(java.lang.String login) |
User |
findByLoginIgnoreCase(java.lang.String login) |
User |
findByPasswordResetId(java.lang.String resetId) |
java.lang.String |
findSessionId(int userId) |
java.util.List<User> |
findUsersWithRoleIds(java.lang.Integer... roleIds) |
java.util.List<User> |
searchActiveUsers(java.lang.String searchTerm) |
java.util.List<User> |
searchActiveUsers(java.lang.String searchTerm,
java.util.Set<java.lang.Integer> withRoles) |
java.util.List<User> |
searchUsers(java.lang.String searchTerm) |
java.util.List<User> |
searchUsers(java.lang.String searchTerm,
java.util.Set<java.lang.Integer> withRoles) |
void |
updateSessionId(int userId,
java.lang.String sessionId) |
deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAll, flush, getOne, save, saveAndFlushfindAllUser findByLogin(java.lang.String login)
User findByLoginAndActiveIsTrue(java.lang.String login)
User findByLoginIgnoreCase(java.lang.String login)
@Query(value="SELECT u FROM User u WHERE LOWER(u.email) = LOWER (?1)") java.util.List<User> findByEmail(java.lang.String email)
@Query(value="SELECT u FROM User u WHERE LOWER(u.email) = LOWER(?1)") User findByEmailUnique(java.lang.String email)
User findById(int id)
java.util.List<User> findByIdIn(java.util.Set<java.lang.Integer> id)
User findByPasswordResetId(java.lang.String resetId)
@Query(value="SELECT u.* FROM users u, user_roles_crossref u_roles WHERE u_roles.user_id = u.user_id AND (u_roles.role_id IN (:roleIds)) GROUP BY u.user_id",
nativeQuery=true)
java.util.List<User> findUsersWithRoleIds(@Param(value="roleIds")
java.lang.Integer... roleIds)
@Query(value="UPDATE User u SET u.sessionId = ?1 WHERE u.id = ?2")
void updateSessionId(int userId,
java.lang.String sessionId)
@Query(value="SELECT u.sessionId FROM User u WHERE u.id = ?1") java.lang.String findSessionId(int userId)
java.util.List<User> findByActiveIsTrue()
@Query(value="select u from User u where lower(u.login) like %?1% or lower(u.email) like %?1% or lower(u.firstName) like %?1% or lower(u.lastName) like %?1% or lower(u.title) like %?1% or lower(u.company) like %?1% group by u.id") java.util.List<User> searchUsers(java.lang.String searchTerm)
@Query(value="select u from User u join UserRoles ur on ur.user.id = u.id where (ur.role.id in ?2) and (lower(u.login) like %?1% or lower(u.email) like %?1% or lower(u.firstName) like %?1% or lower(u.lastName) like %?1% or lower(u.title) like %?1% or lower(u.company) like %?1%) group by u.id") java.util.List<User> searchUsers(java.lang.String searchTerm, java.util.Set<java.lang.Integer> withRoles)
@Query(value="select u from User u where u.active = true and (lower(u.login) like %?1% or lower(u.email) like %?1% or lower(u.firstName) like %?1% or lower(u.lastName) like %?1% or lower(u.title) like %?1% or lower(u.company) like %?1%) group by u.id") java.util.List<User> searchActiveUsers(java.lang.String searchTerm)
@Query(value="select u from User u, UserRoles ur where u.active = true and ur.user.id = u.id and (ur.role.id in ?2) and (lower(u.login) like %?1% or lower(u.email) like %?1% or lower(u.firstName) like %?1% or lower(u.lastName) like %?1% or lower(u.title) like %?1% or lower(u.company) like %?1%) group by u.id") java.util.List<User> searchActiveUsers(java.lang.String searchTerm, java.util.Set<java.lang.Integer> withRoles)