com.tomasteubner.wlan_portal.backend.db

Interface AdminRepository

All Superinterfaces:

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

public interface AdminRepository
extends org.springframework.data.jpa.repository.JpaRepository<Admin,Long>

Method Summary

Modifier and Type	Method and Description
int	countFiltered(Long adminSiteId, String loginFilter, String nameFilter)
List<Admin>	findBySite(Site site)
List<Admin>	findBySiteAndDoNotify(Site site, boolean doNotify)
List<Admin>	findBySiteAndLoginNameIgnoreCase(Site site, String loginName)
List<Admin>	findFiltered(Long adminSiteId, String loginFilter, String nameFilter, org.springframework.data.domain.Pageable pageable)
List<Admin>	findIdBySiteIdAndLoginNameIgnoreCase(long siteId, 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

findBySite

List<Admin> findBySite(Site site)

findBySiteAndLoginNameIgnoreCase

List<Admin> findBySiteAndLoginNameIgnoreCase(Site site,
                                             String loginName)

findBySiteAndDoNotify

List<Admin> findBySiteAndDoNotify(Site site,
                                  boolean doNotify)

countFiltered

@Query(value="select count(a) from Admin a where a.site.id = ?1 and (a.loginName like ?2% or a.fullName like %?3%)")
int countFiltered(Long adminSiteId,
                                                                                                                                       String loginFilter,
                                                                                                                                       String nameFilter)

findFiltered

@Query(value="select a from Admin a where a.site.id = ?1 and (a.loginName like ?2% or a.fullName like %?3%)")
List<Admin> findFiltered(Long adminSiteId,
                                                                                                                                       String loginFilter,
                                                                                                                                       String nameFilter,
                                                                                                                                       org.springframework.data.domain.Pageable pageable)

findIdBySiteIdAndLoginNameIgnoreCase

List<Admin> findIdBySiteIdAndLoginNameIgnoreCase(long siteId,
                                                 String loginName)