com.yugandhar.msp.auth

Interface AuthUserRoleAssocRepository

All Superinterfaces:

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

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

Method Summary

Modifier and Type	Method and Description
org.springframework.data.domain.Page<AuthUserRoleAssocDO>	findAllActiveByAuthRolesRegistryIdpk(java.lang.String authRolesRegistryIdpk, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<AuthUserRoleAssocDO>	findAllActiveByAuthUserRegistryIdpk(java.lang.String authUserRegistryIdpk, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<AuthUserRoleAssocDO>	findAllByAuthRolesRegistryIdpk(java.lang.String authRolesRegistryIdpk, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<AuthUserRoleAssocDO>	findAllByAuthUserRegistryIdpk(java.lang.String authUserRegistryIdpk, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<AuthUserRoleAssocDO>	findAllInActiveByAuthRolesRegistryIdpk(java.lang.String authRolesRegistryIdpk, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<AuthUserRoleAssocDO>	findAllInActiveByAuthUserRegistryIdpk(java.lang.String authUserRegistryIdpk, org.springframework.data.domain.Pageable pageable)
AuthUserRoleAssocDO	findByBusinessKeyActive(java.lang.String authRolesRegistryIdpk, java.lang.String authUserRegistryIdpk)
AuthUserRoleAssocDO	findByBusinessKeyAll(java.lang.String authRolesRegistryIdpk, java.lang.String authUserRegistryIdpk)
AuthUserRoleAssocDO	findByBusinessKeyInactive(java.lang.String authRolesRegistryIdpk, java.lang.String authUserRegistryIdpk)

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

findAllByAuthUserRegistryIdpk

@Query(value="select dobj from AuthUserRoleAssocDO dobj where authUserRegistryIdpk= ?1")
org.springframework.data.domain.Page<AuthUserRoleAssocDO> findAllByAuthUserRegistryIdpk(java.lang.String authUserRegistryIdpk,
                                                                                                                                                                                  org.springframework.data.domain.Pageable pageable)

findAllActiveByAuthUserRegistryIdpk

@Query(value="select dobj from AuthUserRoleAssocDO dobj where  authUserRegistryIdpk= ?1 and (dobj.deletedTs is null or dobj.deletedTs > CURRENT_TIMESTAMP)")
org.springframework.data.domain.Page<AuthUserRoleAssocDO> findAllActiveByAuthUserRegistryIdpk(java.lang.String authUserRegistryIdpk,
                                                                                                                                                                                                                                                            org.springframework.data.domain.Pageable pageable)

findAllInActiveByAuthUserRegistryIdpk

@Query(value="select dobj from AuthUserRoleAssocDO dobj where  authUserRegistryIdpk= ?1 and  dobj.deletedTs < CURRENT_TIMESTAMP")
org.springframework.data.domain.Page<AuthUserRoleAssocDO> findAllInActiveByAuthUserRegistryIdpk(java.lang.String authUserRegistryIdpk,
                                                                                                                                                                                                                                   org.springframework.data.domain.Pageable pageable)

findByBusinessKeyActive

@Query(value="select dobj from AuthUserRoleAssocDO dobj where dobj.authRolesRegistryIdpk = ?1 and dobj.authUserRegistryIdpk= ?2 and (dobj.deletedTs is null or dobj.deletedTs > CURRENT_TIMESTAMP) ")
AuthUserRoleAssocDO findByBusinessKeyActive(java.lang.String authRolesRegistryIdpk,
                                                                                                                                                                                                                                                   java.lang.String authUserRegistryIdpk)

findByBusinessKeyInactive

@Query(value="select dobj from AuthUserRoleAssocDO dobj where dobj.authRolesRegistryIdpk = ?1 and dobj.authUserRegistryIdpk= ?2 and dobj.deletedTs < CURRENT_TIMESTAMP ")
AuthUserRoleAssocDO findByBusinessKeyInactive(java.lang.String authRolesRegistryIdpk,
                                                                                                                                                                                                                         java.lang.String authUserRegistryIdpk)

findByBusinessKeyAll

@Query(value="select dobj from AuthUserRoleAssocDO dobj where dobj.authRolesRegistryIdpk = ?1 and dobj.authUserRegistryIdpk= ?2")
AuthUserRoleAssocDO findByBusinessKeyAll(java.lang.String authRolesRegistryIdpk,
                                                                                                                                                                            java.lang.String authUserRegistryIdpk)

findAllByAuthRolesRegistryIdpk

@Query(value="select dobj from AuthUserRoleAssocDO dobj where authRolesRegistryIdpk= ?1")
org.springframework.data.domain.Page<AuthUserRoleAssocDO> findAllByAuthRolesRegistryIdpk(java.lang.String authRolesRegistryIdpk,
                                                                                                                                                                                    org.springframework.data.domain.Pageable pageable)

findAllActiveByAuthRolesRegistryIdpk

@Query(value="select dobj from AuthUserRoleAssocDO dobj where  authRolesRegistryIdpk= ?1 and (dobj.deletedTs is null or dobj.deletedTs > CURRENT_TIMESTAMP)")
org.springframework.data.domain.Page<AuthUserRoleAssocDO> findAllActiveByAuthRolesRegistryIdpk(java.lang.String authRolesRegistryIdpk,
                                                                                                                                                                                                                                                              org.springframework.data.domain.Pageable pageable)

findAllInActiveByAuthRolesRegistryIdpk

@Query(value="select dobj from AuthUserRoleAssocDO dobj where  authRolesRegistryIdpk= ?1 and  dobj.deletedTs < CURRENT_TIMESTAMP")
org.springframework.data.domain.Page<AuthUserRoleAssocDO> findAllInActiveByAuthRolesRegistryIdpk(java.lang.String authRolesRegistryIdpk,
                                                                                                                                                                                                                                     org.springframework.data.domain.Pageable pageable)