com.yugandhar.msp.auth

Interface AuthRolesRegistryRepository

All Superinterfaces:

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

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

Method Summary

Modifier and Type	Method and Description
AuthRolesRegistryDO	findByBusinessKeyActive(java.lang.String roleName)
AuthRolesRegistryDO	findByBusinessKeyAll(java.lang.String roleName)
AuthRolesRegistryDO	findByBusinessKeyInactive(java.lang.String roleName)

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 AuthRolesRegistryDO dobj where upper(dobj.roleName) = upper(?1) and (dobj.deletedTs is null or dobj.deletedTs > CURRENT_TIMESTAMP) ")
AuthRolesRegistryDO findByBusinessKeyActive(java.lang.String roleName)

findByBusinessKeyInactive

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

findByBusinessKeyAll

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