Package de.dlr.proseo.model.dao

Schnittstelle JobStepRepository

Alle Superschnittstellen:
org.springframework.data.repository.CrudRepository<JobStep,Long>, org.springframework.data.jpa.repository.JpaRepository<JobStep,Long>, org.springframework.data.repository.PagingAndSortingRepository<JobStep,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<JobStep>, org.springframework.data.repository.Repository<JobStep,Long>
@Transactional public interface JobStepRepository extends org.springframework.data.jpa.repository.JpaRepository<JobStep,Long>
Data Access Object for the JobStep class
Autor:
melchinger

  • Methodendetails

    • findAllByJobStepState

      List<JobStep> findAllByJobStepState(JobStep.JobStepState jobStepState)

    • findAllByProcessingFacilityAndJobStepStateIn

      @Query("select js from JobStep js where js.job.processingFacility.id = ?1 and js.jobStepState in ?2") List<JobStep> findAllByProcessingFacilityAndJobStepStateIn(long id, List<JobStep.JobStepState> jobStepStates)

    • findAllByProcessingFacilityAndJobStepStateInAndOrderBySensingStartTime

      @Query("select js from JobStep js where js.job.processingFacility.id = ?1 and js.jobStepState in ?2 order by js.job.startTime, js.id") List<JobStep> findAllByProcessingFacilityAndJobStepStateInAndOrderBySensingStartTime(long id, List<JobStep.JobStepState> jobStepStates)

    • findAllByProcessingFacilityAndJobStepStateInAndOrderBySubmissionTime

      @Query("select js from JobStep js where js.job.processingFacility.id = ?1 and js.jobStepState in ?2 order by js.job.processingOrder.submissionTime, js.id") List<JobStep> findAllByProcessingFacilityAndJobStepStateInAndOrderBySubmissionTime(long id, List<JobStep.JobStepState> jobStepStates)

    • findAllByJobStepStateAndMissionOrderByDate

      @Query("select js from JobStep js where js.jobStepState = ?1 and js.job.processingOrder.mission.code = ?2 order by js.processingCompletionTime desc") List<JobStep> findAllByJobStepStateAndMissionOrderByDate(JobStep.JobStepState jobStepState, String mission)

    • findAllByJobStepStateAndOrderIdByDate

      @Query("select js from JobStep js where js.jobStepState = ?1 and js.job.processingOrder.id = ?2 order by js.job.startTime, js.id") List<JobStep> findAllByJobStepStateAndOrderIdByDate(JobStep.JobStepState jobStepState, long orderId)

    • countJobStepNotFinishedByJobId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.id = ?1 AND js.jobStepState NOT IN (\'COMPLETED\', \'FAILED\')") int countJobStepNotFinishedByJobId(long id)

    • countJobStepNotFinishedByOrderId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.processingOrder.id = ?1 AND js.jobStepState NOT IN (\'COMPLETED\', \'FAILED\')") int countJobStepNotFinishedByOrderId(long id)

    • countJobStepByOrderId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.processingOrder.id = ?1") int countJobStepByOrderId(long id)

    • countJobStepCompletedByJobId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.id = ?1 AND js.jobStepState = \'COMPLETED\'") int countJobStepCompletedByJobId(long id)

    • countJobStepFailedByJobId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.id = ?1 AND js.jobStepState = \'FAILED\'") int countJobStepFailedByJobId(long id)

    • countJobStepRunningByJobId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.id = ?1 AND js.jobStepState = \'RUNNING\'") int countJobStepRunningByJobId(long id)

    • countJobStepCompletedByOrderId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.processingOrder.id = ?1 AND js.jobStepState = \'COMPLETED\'") int countJobStepCompletedByOrderId(long id)

    • countJobStepFailedByOrderId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.processingOrder.id = ?1 AND js.jobStepState = \'FAILED\'") int countJobStepFailedByOrderId(long id)

    • countJobStepRunningByOrderId

      @Query("SELECT COUNT(*) FROM JobStep js WHERE js.job.processingOrder.id = ?1 AND js.jobStepState = \'RUNNING\'") int countJobStepRunningByOrderId(long id)

    • countJobStepStatesByOrderId

      @Query("select js.jobStepState, count(*) from ProcessingOrder o join o.jobs j join j.jobSteps js where o.id = ?1 group by js.jobStepState") List<Object[]> countJobStepStatesByOrderId(long id)

    • findDistinctJobStepStatesByOrderId

      @Query("SELECT DISTINCT(js.jobStepState) FROM JobStep js WHERE js.job.processingOrder.id = ?1") List<String> findDistinctJobStepStatesByOrderId(long id)