Package org.openiam.esb.repository

Interface DbIPStatusRepository

All Superinterfaces:

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

@Repository
public interface DbIPStatusRepository
extends AbstractEntityRepository<DbIpGeoStatusEntity,String>

This is repository for working with DbIPStatusEntity

Author:

Method Summary

Modifier and Type	Method	Description
DbIpGeoStatusEntity	findFirstByStartUpload()
DbIpGeoStatusEntity	findFirstByStatusAndStartUpload(String status)

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

findFirstByStartUpload

@Query("SELECT geo FROM DbIpGeoStatusEntity geo ORDER BY startUpload desc")
DbIpGeoStatusEntity findFirstByStartUpload()

findFirstByStatusAndStartUpload

@Query("SELECT geoStatus FROM DbIpGeoStatusEntity geoStatus WHERE geoStatus.uploadStatus=:status ORDER BY startUpload DESC")
DbIpGeoStatusEntity findFirstByStatusAndStartUpload(@Param("status")
                                                    String status)