Interface LoginRepository

    • Method Detail

      • findByUserId

        @Query("select l from LoginEntity l JOIN l.user u where u.id = :userId")
        List<LoginEntity> findByUserId​(@Param("userId")
                                       String userId)
        replace public List findUser(String userId) from DAO
        Parameters:
        userId -
        Returns:
      • findSimplifiedByUserId

        @Query("SELECT new org.openiam.esb.core.auth.model.LoginAuthenticationInformation(l.password, l.user.id, l.id) FROM LoginEntity l WHERE l.user.id=:userId")
        List<LoginAuthenticationInformation> findSimplifiedByUserId​(@Param("userId")
                                                                    String userId)
      • findAllSimplified

        @Query("SELECT new org.openiam.esb.core.auth.model.LoginAuthenticationInformation(l.password, l.user.id, l.id) FROM LoginEntity l")
        List<LoginAuthenticationInformation> findAllSimplified()
      • bulkResetPasswordChangeCount

        @Modifying
        @Query("UPDATE LoginEntity l SET l.passwordChangeCount = 0 WHERE l.passwordChangeCount <> 0")
        int bulkResetPasswordChangeCount()
      • updatePassword

        @Modifying
        @Query("UPDATE LoginEntity l SET l.password=:password WHERE l.id=:id")
        void updatePassword​(@Param("id")
                            String id,
                            @Param("password")
                            String password)
      • findLockedUsers

        @Query("select l from LoginEntity l where l.lockMarker= \'LOCKED\' and l.lastAuthAttempt >=:startTime")
        List<LoginEntity> findLockedUsers​(@Param("startTime")
                                          Date startTime)
        Parameters:
        startTime -
        Returns:
      • findFirstByPswdResetToken

        @Query("select l from LoginEntity l where l.pswdResetToken= :pswdResetToken")
        LoginEntity findFirstByPswdResetToken​(@Param("pswdResetToken")
                                              String token)
        replace public LoginEntity findByPasswordResetToken(String token) from DAO
        Parameters:
        token -
        Returns:
      • findFirstByLowerCaseLoginAndManagedSysId

        @Query("select l from LoginEntity l where l.lowerCaseLogin = :login and l.managedSysId=:managedSysId")
        LoginEntity findFirstByLowerCaseLoginAndManagedSysId​(@Param("login")
                                                             String login,
                                                             @Param("managedSysId")
                                                             String managedSysId)
        replace public LoginEntity getRecord(final String login, final String managedSysId) from DAO
        Parameters:
        login -
        managedSysId -
        Returns:
      • findByUserIdInAndManagedSysId

        @Query("select l from LoginEntity l JOIN l.user u where u.id IN (:userIds) AND l.managedSysId = :defaultManagedSysId")
        List<LoginEntity> findByUserIdInAndManagedSysId​(@Param("userIds")
                                                        List<String> userIds,
                                                        @Param("defaultManagedSysId")
                                                        String defaultManagedSysId)
        replace public List findByUserIds(List userIds, String managedSysId) from DAO
        Parameters:
        userIds -
        defaultManagedSysId -
        Returns:
      • getRecord

        @Deprecated
        default LoginEntity getRecord​(String login,
                                      String managedSysId)
        Deprecated.
        Use findFirstByLowerCaseLoginAndManagedSysId
        Parameters:
        login -
        managedSysId -
        Returns: