com.tomasteubner.wlan_portal.backend.db

Interface PrincipalRepository

All Superinterfaces:

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

public interface PrincipalRepository
extends org.springframework.data.jpa.repository.JpaRepository<Principal,Long>

Method Summary

Modifier and Type	Method and Description
int	countBySiteIdAndValidatedBy(long siteId, Admin admin)
int	countFiltered(long siteId, boolean voucher, String loginFilter, String nameFilter)
Optional<Principal>	findBySiteAndVoucherAndLoginName(Site site, boolean voucher, String loginName)
List<Principal>	findFiltered(long siteId, boolean voucher, String loginFilter, String nameFilter, org.springframework.data.domain.Pageable pageable)
Optional<Long>	findIdBySiteIdAndVoucherAndLoginName(long siteId, boolean voucher, String loginName)

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

findBySiteAndVoucherAndLoginName

Optional<Principal> findBySiteAndVoucherAndLoginName(Site site,
                                                     boolean voucher,
                                                     String loginName)

findIdBySiteIdAndVoucherAndLoginName

@Query(value="select p.id from Principal p where p.site.id = ?1 and p.voucher = ?2 and p.loginName = ?3")
Optional<Long> findIdBySiteIdAndVoucherAndLoginName(long siteId,
                                                                                                                                                              boolean voucher,
                                                                                                                                                              String loginName)

countFiltered

@Query(value="select count(p) from Principal p where p.site.id = ?1 and p.voucher = ?2 and (p.loginName like ?3% or p.fullName like %?4%)")
int countFiltered(long siteId,
                                                                                                                                                              boolean voucher,
                                                                                                                                                              String loginFilter,
                                                                                                                                                              String nameFilter)

findFiltered

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

countBySiteIdAndValidatedBy

int countBySiteIdAndValidatedBy(long siteId,
                                Admin admin)