Package org.openiam.esb.repository

Interface FidoAuthenticatorRepository

All Superinterfaces:

AbstractEntityRepository<FidoAuthenticatorEntity,String>, AbstractKeyEntityCustomRepository<FidoAuthenticatorEntity,String>, AbstractKeyEntityRepository<FidoAuthenticatorEntity,String>, org.springframework.data.repository.CrudRepository<FidoAuthenticatorEntity,String>, FidoAuthenticatorRepositoryCustom, org.springframework.data.jpa.repository.JpaRepository<FidoAuthenticatorEntity,String>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<FidoAuthenticatorEntity>, org.springframework.data.repository.PagingAndSortingRepository<FidoAuthenticatorEntity,String>, org.springframework.data.repository.query.QueryByExampleExecutor<FidoAuthenticatorEntity>, org.springframework.data.repository.Repository<FidoAuthenticatorEntity,String>

@Repository
public interface FidoAuthenticatorRepository
extends AbstractKeyEntityRepository<FidoAuthenticatorEntity,String>, FidoAuthenticatorRepositoryCustom

This is repository for working with FIDO Authenticator Entity

Method Summary

Modifier and Type	Method	Description
int	countByCredentialId(byte[] credentialId)
void	deleteByCredentialId(byte[] credentialId)
List<FidoAuthenticatorEntity>	findAllByLogin(String login, String managedSysId)
List<FidoAuthenticatorEntity>	findByUserId(String userId)
FidoAuthenticatorEntity	findOneByCredentialId(byte[] credentialId)
void	updateCounterByCredentialId(byte[] credentialId, long counter)
void	updateNameByCredentialId(byte[] credentialId, String name)

Methods inherited from interface org.openiam.esb.repository.AbstractEntityRepository

getPageable

Methods inherited from interface org.openiam.esb.repository.custom.AbstractKeyEntityCustomRepository

findByIdIn

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, getReferenceById, saveAll, saveAllAndFlush, saveAndFlush

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

count, exists, 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 Detail

findOneByCredentialId

@Query("SELECT authenticator FROM FidoAuthenticatorEntity authenticator WHERE authenticator.credentialId = :credentialId")
FidoAuthenticatorEntity findOneByCredentialId(@Param("credentialId")
                                              byte[] credentialId)

findAllByLogin

@Query("SELECT authenticator FROM FidoAuthenticatorEntity authenticator WHERE authenticator.user.id IN (SELECT login.user.id FROM LoginEntity login WHERE login.user.status <> \'DEACTIVATED\' AND login.login=:login AND login.managedSysId=:managedSysId)")
List<FidoAuthenticatorEntity> findAllByLogin(@Param("login")
                                             String login,
                                             @Param("managedSysId")
                                             String managedSysId)

findByUserId

@Query("SELECT authenticator FROM FidoAuthenticatorEntity authenticator WHERE authenticator.user.id=:userId")
List<FidoAuthenticatorEntity> findByUserId(@Param("userId")
                                           String userId)

countByCredentialId

int countByCredentialId(@Param("credentialId")
                        byte[] credentialId)

deleteByCredentialId

void deleteByCredentialId(@Param("credentialId")
                          byte[] credentialId)

updateNameByCredentialId

@Modifying
@Query("UPDATE FidoAuthenticatorEntity authenticator SET authenticator.name = :name WHERE authenticator.credentialId = :credentialId")
void updateNameByCredentialId(@Param("credentialId")
                              byte[] credentialId,
                              @Param("name")
                              String name)

updateCounterByCredentialId

@Modifying
@Query("UPDATE FidoAuthenticatorEntity authenticator SET authenticator.counter = :counter WHERE authenticator.credentialId = :credentialId")
void updateCounterByCredentialId(@Param("credentialId")
                                 byte[] credentialId,
                                 @Param("counter")
                                 long counter)