com.tomasteubner.wlan_portal.backend.db

Interface DeviceRepository

All Superinterfaces:

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

public interface DeviceRepository
extends org.springframework.data.jpa.repository.JpaRepository<Device,Long>

Author:

teubnerto

Method Summary

Modifier and Type	Method and Description
int	countFilteredByMac(long adminSiteId, String mac)
int	countFilteredByUser(long adminSiteId, boolean voucher, String ownerName)
int	countFilteredByUserAndMac(long adminSiteId, boolean voucher, String ownerName, String mac)
List<Device>	findAllByPrincipalSiteId(long siteId)
List<Device>	findFilteredByMac(Long adminSiteId, String mac, org.springframework.data.domain.Pageable pageable)
List<Device>	findFilteredByUser(Long adminSiteId, boolean voucher, String ownerName, org.springframework.data.domain.Pageable pageable)
List<Device>	findFilteredByUserAndMac(Long adminSiteId, boolean voucher, String ownerName, String mac, 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

countFilteredByUser

@Query(value="select count(d) from Device d where d.principal.site.id = ?1 and d.principal.voucher = ?2 and d.principal.loginName = ?3")
int countFilteredByUser(long adminSiteId,
                                                                                                                                                                 boolean voucher,
                                                                                                                                                                 String ownerName)

countFilteredByMac

@Query(value="select count(d) from Device d where d.principal.site.id = ?1 and d.macAddress = ?2")
int countFilteredByMac(long adminSiteId,
                                                                                                                          String mac)

countFilteredByUserAndMac

@Query(value="select count(d) from Device d where d.principal.site.id = ?1 and d.macAddress = ?4 and d.principal.voucher = ?2 and d.principal.loginName = ?3")
int countFilteredByUserAndMac(long adminSiteId,
                                                                                                                                                                                             boolean voucher,
                                                                                                                                                                                             String ownerName,
                                                                                                                                                                                             String mac)

findFilteredByUser

@Query(value="select d from Device d where d.principal.site.id = ?1 and d.principal.voucher = ?2 and d.principal.loginName = ?3")
List<Device> findFilteredByUser(Long adminSiteId,
                                                                                                                                                                  boolean voucher,
                                                                                                                                                                  String ownerName,
                                                                                                                                                                  org.springframework.data.domain.Pageable pageable)

findFilteredByMac

@Query(value="select d from Device d where d.principal.site.id = ?1 and d.macAddress = ?2")
List<Device> findFilteredByMac(Long adminSiteId,
                                                                                                                           String mac,
                                                                                                                           org.springframework.data.domain.Pageable pageable)

findFilteredByUserAndMac

@Query(value="select d from Device d where d.principal.site.id = ?1 and d.macAddress = ?4 and d.principal.voucher = ?2 and d.principal.loginName = ?3")
List<Device> findFilteredByUserAndMac(Long adminSiteId,
                                                                                                                                                                                              boolean voucher,
                                                                                                                                                                                              String ownerName,
                                                                                                                                                                                              String mac,
                                                                                                                                                                                              org.springframework.data.domain.Pageable pageable)

findAllByPrincipalSiteId

List<Device> findAllByPrincipalSiteId(long siteId)