Package de.dlr.proseo.model.dao

Schnittstelle JobRepository

Alle Superschnittstellen:

org.springframework.data.repository.CrudRepository<Job,Long>, org.springframework.data.jpa.repository.JpaRepository<Job,Long>, org.springframework.data.repository.PagingAndSortingRepository<Job,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<Job>, org.springframework.data.repository.Repository<Job,Long>

@Transactional
@Repository
public interface JobRepository
extends org.springframework.data.jpa.repository.JpaRepository<Job,Long>

Data Access Object for the Job class

Autor:

Dr. Thomas Bassler

Methodenübersicht

Modifizierer und Typ	Methode	Beschreibung
int	countAllByJobStateAndProcessingOrder(Job.JobState jobState, long orderId)
int	countJobFailedByProcessingOrderId(long id)
int	countJobNotFinishedByProcessingOrderId(long id)
int	countJobOnHoldByProcessingOrderId(long id)
List<Job>	findAllByJobState(Job.JobState jobState)
List<Job>	findAllByJobStateAndProcessingOrder(Job.JobState jobState, long orderId)	Veraltet.
List<Job>	findAllByProcessingOrder(long orderId)

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

findAllByJobState

@Query("select j from Job j where j.jobState = ?1")
List<Job> findAllByJobState(Job.JobState jobState)

findAllByProcessingOrder

@Query("select j from Job j where j.processingOrder.id = ?1")
List<Job> findAllByProcessingOrder(long orderId)

findAllByJobStateAndProcessingOrder

@Deprecated
@Query("select j from Job j where j.jobState = ?1 and j.processingOrder.id = ?2")
List<Job> findAllByJobStateAndProcessingOrder(Job.JobState jobState,
 long orderId)

Veraltet.

countAllByJobStateAndProcessingOrder

@Query("select count(*) from Job j where j.jobState = ?1 and j.processingOrder.id = ?2")
int countAllByJobStateAndProcessingOrder(Job.JobState jobState,
 long orderId)

countJobNotFinishedByProcessingOrderId

@Query("SELECT COUNT(*) FROM Job j WHERE j.processingOrder.id = ?1 AND  j.jobState NOT IN (\'CLOSED\', \'COMPLETED\', \'FAILED\')")
int countJobNotFinishedByProcessingOrderId(long id)

countJobFailedByProcessingOrderId

@Query("SELECT COUNT(*) FROM Job j WHERE j.processingOrder.id = ?1 AND  j.jobState = \'FAILED\'")
int countJobFailedByProcessingOrderId(long id)

countJobOnHoldByProcessingOrderId

@Query("SELECT COUNT(*) FROM Job j WHERE j.processingOrder.id = ?1 AND  j.jobState = \'ON_HOLD\'")
int countJobOnHoldByProcessingOrderId(long id)