com.yugandhar.msp.auth

Interface AuthUserRegistryRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<AuthUserRegistryDO,java.lang.Long>, org.springframework.data.jpa.repository.JpaRepository<AuthUserRegistryDO,java.lang.Long>, org.springframework.data.repository.PagingAndSortingRepository<AuthUserRegistryDO,java.lang.Long>, org.springframework.data.repository.query.QueryByExampleExecutor<AuthUserRegistryDO>, org.springframework.data.repository.Repository<AuthUserRegistryDO,java.lang.Long>

public interface AuthUserRegistryRepository
extends org.springframework.data.jpa.repository.JpaRepository<AuthUserRegistryDO,java.lang.Long>

Method Summary

Modifier and Type	Method and Description
AuthUserRegistryDO	findByBusinessKeyActive(java.lang.String userName)
AuthUserRegistryDO	findByBusinessKeyAll(java.lang.String userName)
AuthUserRegistryDO	findByBusinessKeyInactive(java.lang.String userName)

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

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

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

findAll

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

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

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

count, exists, findAll, findOne

Method Detail

findByBusinessKeyActive

@Query(value="select dobj from AuthUserRegistryDO dobj where upper(dobj.userName) = upper(?1) and (dobj.deletedTs is null or dobj.deletedTs > CURRENT_TIMESTAMP) ")
AuthUserRegistryDO findByBusinessKeyActive(java.lang.String userName)

findByBusinessKeyInactive

@Query(value="select dobj from AuthUserRegistryDO dobj where upper(dobj.userName) = upper(?1) and dobj.deletedTs < CURRENT_TIMESTAMP ")
AuthUserRegistryDO findByBusinessKeyInactive(java.lang.String userName)

findByBusinessKeyAll

@Query(value="select dobj from AuthUserRegistryDO dobj where upper(dobj.userName) = upper(?1) ")
AuthUserRegistryDO findByBusinessKeyAll(java.lang.String userName)