Package de.dlr.proseo.model.dao

Interface MonServiceStateOperationMonthRepository

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

  • Method Summary

    Modifier and Type
    Method
    Description
    List<MonServiceStateOperationMonth>
    findByDateTimeBetween(Instant timeFrom, Instant timeTo, long monServiceId)
    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 MonServiceStateOperationMonth d") Instant findLastDatetime()
      Get a latest datetime
      Returns:
      the latest datetime

    • findByDateTimeBetween

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