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
@Repository
public interface JobStepRepository
extends org.springframework.data.jpa.repository.JpaRepository<JobStep,Long>

Data Access Object for the JobStep class

Autor:

melchinger

Methodenübersicht

Modifizierer und Typ	Methode	Beschreibung
int	countJobStepByOrderId(long id)
int	countJobStepCompletedByJobId(long id)
int	countJobStepCompletedByOrderId(long id)
int	countJobStepFailedByJobId(long id)
int	countJobStepFailedByOrderId(long id)
int	countJobStepNotFinishedByJobId(long id)
int	countJobStepNotFinishedByOrderId(long id)
int	countJobStepRunningByJobId(long id)
int	countJobStepRunningByOrderId(long id)
List<Object[]>	countJobStepStatesByOrderId(long id)
List<JobStep>	findAllByJobStepState(JobStep.JobStepState jobStepState)
List<JobStep>	findAllByJobStepStateAndMissionOrderByDate(JobStep.JobStepState jobStepState, String mission)
List<JobStep>	findAllByJobStepStateAndOrderIdByDate(JobStep.JobStepState jobStepState, long orderId)
List<JobStep>	findAllByProcessingFacilityAndJobStepStateIn(long id, List<JobStep.JobStepState> jobStepStates)
List<JobStep>	findAllByProcessingFacilityAndJobStepStateInAndOrderBySensingStartTime(long id, List<JobStep.JobStepState> jobStepStates)
List<JobStep>	findAllByProcessingFacilityAndJobStepStateInAndOrderBySubmissionTime(long id, List<JobStep.JobStepState> jobStepStates)
List<String>	findDistinctJobStepStatesByOrderId(long id)

Von Schnittstelle geerbte Methoden org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

Von Schnittstelle geerbte Methoden org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

Von Schnittstelle geerbte Methoden org.springframework.data.repository.PagingAndSortingRepository

findAll

Von Schnittstelle geerbte Methoden org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

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)