com.tomasteubner.wlan_portal.backend.db

Interface NotificationRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<RegistrationNotification,String>, org.springframework.data.jpa.repository.JpaRepository<RegistrationNotification,String>, org.springframework.data.repository.PagingAndSortingRepository<RegistrationNotification,String>, org.springframework.data.repository.query.QueryByExampleExecutor<RegistrationNotification>, org.springframework.data.repository.Repository<RegistrationNotification,String>

public interface NotificationRepository
extends org.springframework.data.jpa.repository.JpaRepository<RegistrationNotification,String>

Method Summary

Modifier and Type	Method and Description
int	countFiltered(long siteId, String idFilter, String loginFilter, String nameFilter)
Optional<RegistrationNotification>	findByNotificationId(String regId)
Optional<RegistrationNotification>	findByPrincipal(Principal principal)
List<RegistrationNotification>	findFiltered(long siteId, String idFilter, String loginFilter, String nameFilter, org.springframework.data.domain.Pageable pageable)

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

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAll, flush, getOne, save, saveAndFlush

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

findAll

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

count, delete, delete, delete, deleteAll, exists, findOne, save

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

count, exists, findAll, findOne

Method Detail

findByPrincipal

Optional<RegistrationNotification> findByPrincipal(Principal principal)

findFiltered

@Query(value="select reg from RegistrationNotification reg where reg.principal.site.id = ?1 and (reg.notificationId like ?2% or reg.principal.loginName like ?3% or reg.principal.fullName like %?4%)")
List<RegistrationNotification> findFiltered(long siteId,
                                                                                                                                                                                                                                                    String idFilter,
                                                                                                                                                                                                                                                    String loginFilter,
                                                                                                                                                                                                                                                    String nameFilter,
                                                                                                                                                                                                                                                    org.springframework.data.domain.Pageable pageable)

countFiltered

@Query(value="select count(reg) from RegistrationNotification reg where reg.principal.site.id = ?1 and (reg.notificationId like ?2% or reg.principal.loginName like ?3% or reg.principal.fullName like %?4%)")
int countFiltered(long siteId,
                                                                                                                                                                                                                                 String idFilter,
                                                                                                                                                                                                                                 String loginFilter,
                                                                                                                                                                                                                                 String nameFilter)

findByNotificationId

Optional<RegistrationNotification> findByNotificationId(String regId)