Package org.openiam.esb.repository

Interface DbIPGeoRepository

All Superinterfaces:

AbstractEntityRepository<DbIPGeoEntity,String>, org.springframework.data.repository.CrudRepository<DbIPGeoEntity,String>, DbIPGeoRepositoryCustom, org.springframework.data.jpa.repository.JpaRepository<DbIPGeoEntity,String>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<DbIPGeoEntity>, org.springframework.data.repository.PagingAndSortingRepository<DbIPGeoEntity,String>, org.springframework.data.repository.query.QueryByExampleExecutor<DbIPGeoEntity>, org.springframework.data.repository.Repository<DbIPGeoEntity,String>

@Repository
public interface DbIPGeoRepository
extends AbstractEntityRepository<DbIPGeoEntity,String>, DbIPGeoRepositoryCustom

This is repository for working with DbIPGeoEntity

Author:

Method Summary

Modifier and Type	Method	Description
List<DbIPGeoEntity>	findByIp(byte[] ip)

Methods inherited from interface org.openiam.esb.repository.AbstractEntityRepository

getPageable

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.DbIPGeoRepositoryCustom

find

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

findByIp

@Query("SELECT geo FROM DbIPGeoEntity geo WHERE geo.id.ipStart <= :ip AND geo.ipEnd >= :ip ORDER BY geo.id.ipStart DESC")
List<DbIPGeoEntity> findByIp(@Param("ip")
                             byte[] ip)