Package de.dlr.proseo.model.dao

Interface MonExtServiceStateOperationMonthRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<MonExtServiceStateOperationMonth,Long>, org.springframework.data.jpa.repository.JpaRepository<MonExtServiceStateOperationMonth,Long>, org.springframework.data.repository.ListCrudRepository<MonExtServiceStateOperationMonth,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<MonExtServiceStateOperationMonth,Long>, org.springframework.data.repository.PagingAndSortingRepository<MonExtServiceStateOperationMonth,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<MonExtServiceStateOperationMonth>, org.springframework.data.repository.Repository<MonExtServiceStateOperationMonth,Long>
public interface MonExtServiceStateOperationMonthRepository extends org.springframework.data.jpa.repository.JpaRepository<MonExtServiceStateOperationMonth,Long>

  • Method Summary

    Modifier and Type
    Method
    Description
    List<MonExtServiceStateOperationMonth>
    findByDateTimeBetween(Instant timeFrom, Instant timeTo, long monExtServiceId)
    Get a list of entries
    Instant
    findLastDatetime()
    Get a latest datetime

    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, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

    Methods inherited from interface org.springframework.data.repository.ListCrudRepository

    findAll, findAllById, saveAll

    Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

    findAll

    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 Details

    • findLastDatetime

      @Query("select max(d.datetime) from MonExtServiceStateOperationMonth d") Instant findLastDatetime()
      Get a latest datetime
      Returns:
      the latest datetime

    • findByDateTimeBetween

      @Query("select p from MonExtServiceStateOperationMonth p where p.datetime >= ?1 and p.datetime < ?2 and p.monExtServiceId = ?3") List<MonExtServiceStateOperationMonth> findByDateTimeBetween(Instant timeFrom, Instant timeTo, long monExtServiceId)
      Get a list of entries
      Parameters:
      timeFrom - earliest time
      timeTo - latest time
      monExtServiceId - service id
      Returns:
      a list of services satisfying the search criteria