Package org.openiam.esb.repository

Interface EmailAddressRepository

All Superinterfaces:

AbstractEntityRepository<EmailAddressEntity,String>, AbstractKeyEntityCustomRepository<EmailAddressEntity,String>, AbstractKeyEntityRepository<EmailAddressEntity,String>, AbstractKeyNameEntityCustomRepository<EmailAddressEntity,String>, AbstractKeyNameEntityRepository<EmailAddressEntity,String>, AbstractMetadataTypeRepository<EmailAddressEntity,String>, AbstractMetadataTypeRepositoryCustom<EmailAddressEntity,String>, org.springframework.data.repository.CrudRepository<EmailAddressEntity,String>, EmailAddressRepositoryCustom, FindBeansRepositoryCustom<EmailAddressEntity,EmailSearchBean>, org.springframework.data.jpa.repository.JpaRepository<EmailAddressEntity,String>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<EmailAddressEntity>, org.springframework.data.repository.PagingAndSortingRepository<EmailAddressEntity,String>, org.springframework.data.repository.query.QueryByExampleExecutor<EmailAddressEntity>, org.springframework.data.repository.Repository<EmailAddressEntity,String>

@Repository
public interface EmailAddressRepository
extends AbstractMetadataTypeRepository<EmailAddressEntity,String>, EmailAddressRepositoryCustom

This is repository for working with EmailAddressEntity

Author:

Sanchir Kartiev

Method Summary

Modifier and Type	Method	Description
int	countDuplicateEmails(Collection<String> emailAddress)
int	countDuplicateEmails(Collection<String> emailAddress, String currentUserId)
List<EmailAddressEntity>	findByEmailAddressIn(Set<String> emailAddresses)

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.openiam.esb.repository.custom.FindBeansRepositoryCustom

count, find, find, find, getByExample, getByExample, isValidSearchBean

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

countDuplicateEmails

@Query("SELECT count(x.id) FROM EmailAddressEntity x WHERE LOWER(x.emailAddress) IN(:emailAddress) AND x.parent.id!=:userId")
int countDuplicateEmails(@Param("emailAddress")
                         Collection<String> emailAddress,
                         @Param("userId")
                         String currentUserId)

countDuplicateEmails

@Query("SELECT count(x.id) FROM EmailAddressEntity x WHERE LOWER(x.emailAddress) IN(:emailAddress)")
int countDuplicateEmails(@Param("emailAddress")
                         Collection<String> emailAddress)

findByEmailAddressIn

List<EmailAddressEntity> findByEmailAddressIn(Set<String> emailAddresses)