com.yugandhar.msp.auth

Interface AuthUserroleAccesscontrolRepository

All Superinterfaces:

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

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

Method Summary

Modifier and Type	Method and Description
org.springframework.data.domain.Page<AuthUserroleAccesscontrolDO>	findAllActiveAuthUserroleAccesscontrolByRegistryIdpk(java.lang.String profileType, java.lang.String authUserRoleRegistryIdpk, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<AuthUserroleAccesscontrolDO>	findAllInActiveAuthUserroleAccesscontrolByRegistryIdpk(java.lang.String profileType, java.lang.String authUserRoleRegistryIdpk, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<AuthUserroleAccesscontrolDO>	findAuthUserroleAccesscontrolByRegistryIdpk(java.lang.String profileType, java.lang.String authUserRoleRegistryIdpk, org.springframework.data.domain.Pageable pageable)
AuthUserroleAccesscontrolDO	findByBusinessKeyActive(java.lang.String profileType, java.lang.String authUserRoleRegistryIdpk, java.lang.String configTxnRegistryIdpk)
AuthUserroleAccesscontrolDO	findByBusinessKeyAll(java.lang.String profileType, java.lang.String authUserRoleRegistryIdpk, java.lang.String configTxnRegistryIdpk)
AuthUserroleAccesscontrolDO	findByBusinessKeyInactive(java.lang.String profileType, java.lang.String authUserRoleRegistryIdpk, java.lang.String configTxnRegistryIdpk)

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

findAllActiveAuthUserroleAccesscontrolByRegistryIdpk

@Query(value="select dobj from AuthUserroleAccesscontrolDO dobj where upper(dobj.profileType) = upper(?1) and authUserRoleRegistryIdpk= ?2 ")
org.springframework.data.domain.Page<AuthUserroleAccesscontrolDO> findAllActiveAuthUserroleAccesscontrolByRegistryIdpk(java.lang.String profileType,
                                                                                                                                                                                                                                                                      java.lang.String authUserRoleRegistryIdpk,
                                                                                                                                                                                                                                                                      org.springframework.data.domain.Pageable pageable)

findAllInActiveAuthUserroleAccesscontrolByRegistryIdpk

@Query(value="select dobj from AuthUserroleAccesscontrolDO dobj where  upper(dobj.profileType) = upper(?1) and authUserRoleRegistryIdpk= ?2 and (dobj.deletedTs is null or dobj.deletedTs > CURRENT_TIMESTAMP)")
org.springframework.data.domain.Page<AuthUserroleAccesscontrolDO> findAllInActiveAuthUserroleAccesscontrolByRegistryIdpk(java.lang.String profileType,
                                                                                                                                                                                                                                                                                                                                           java.lang.String authUserRoleRegistryIdpk,
                                                                                                                                                                                                                                                                                                                                           org.springframework.data.domain.Pageable pageable)

findAuthUserroleAccesscontrolByRegistryIdpk

@Query(value="select dobj from AuthUserroleAccesscontrolDO dobj where  upper(dobj.profileType) = upper(?1) and authUserRoleRegistryIdpk= ?2 and  dobj.deletedTs < CURRENT_TIMESTAMP")
org.springframework.data.domain.Page<AuthUserroleAccesscontrolDO> findAuthUserroleAccesscontrolByRegistryIdpk(java.lang.String profileType,
                                                                                                                                                                                                                                                                                                     java.lang.String authUserRoleRegistryIdpk,
                                                                                                                                                                                                                                                                                                     org.springframework.data.domain.Pageable pageable)

findByBusinessKeyActive

@Query(value="select dobj from AuthUserroleAccesscontrolDO dobj where upper(dobj.profileType) = (?1) and dobj.authUserRoleRegistryIdpk= ?2 and dobj.configTxnRegistryIdpk= ?3 and (dobj.deletedTs is null or dobj.deletedTs > CURRENT_TIMESTAMP) ")
AuthUserroleAccesscontrolDO findByBusinessKeyActive(java.lang.String profileType,
                                                                                                                                                                                                                                                                                                         java.lang.String authUserRoleRegistryIdpk,
                                                                                                                                                                                                                                                                                                         java.lang.String configTxnRegistryIdpk)

findByBusinessKeyInactive

@Query(value="select dobj from AuthUserroleAccesscontrolDO dobj where upper(dobj.profileType) = (?1) and dobj.authUserRoleRegistryIdpk= ?2 and dobj.configTxnRegistryIdpk= ?3 and dobj.deletedTs < CURRENT_TIMESTAMP ")
AuthUserroleAccesscontrolDO findByBusinessKeyInactive(java.lang.String profileType,
                                                                                                                                                                                                                                                                               java.lang.String authUserRoleRegistryIdpk,
                                                                                                                                                                                                                                                                               java.lang.String configTxnRegistryIdpk)

findByBusinessKeyAll

@Query(value="select dobj from AuthUserroleAccesscontrolDO dobj where upper(dobj.profileType) = (?1) and dobj.authUserRoleRegistryIdpk= ?2 and dobj.configTxnRegistryIdpk= ?3")
AuthUserroleAccesscontrolDO findByBusinessKeyAll(java.lang.String profileType,
                                                                                                                                                                                                                                  java.lang.String authUserRoleRegistryIdpk,
                                                                                                                                                                                                                                  java.lang.String configTxnRegistryIdpk)