Package org.jobrunr.storage.sql.common

Class JobTable

java.lang.Object

org.jobrunr.storage.sql.common.db.Sql<Job>

org.jobrunr.storage.sql.common.JobTable

public class JobTable
extends Sql<Job>

Constructor Summary

Constructors

Constructor	Description
JobTable(javax.sql.DataSource dataSource, JobMapper jobMapper)

Method Summary

Modifier and Type	Method	Description
long	countJobs(StateName state)
int	deleteJobsByStateAndUpdatedBefore(StateName state, java.time.Instant updatedBefore)
int	deletePermanently(java.util.UUID... ids)
boolean	exists(JobDetails jobDetails, StateName... states)
java.util.Set<java.lang.String>	getDistinctJobSignatures(StateName[] states)
boolean	recurringJobExists(java.lang.String recurringJobId, StateName... states)
java.util.List<Job>	save(java.util.List<Job> jobs)
Job	save(Job jobToSave)
java.util.Optional<Job>	selectJobById(java.util.UUID id)
java.util.List<Job>	selectJobsByState(StateName state, java.time.Instant updatedBefore, PageRequest pageRequest)
java.util.List<Job>	selectJobsByState(StateName state, PageRequest pageRequest)
java.util.List<Job>	selectJobsScheduledBefore(java.time.Instant scheduledBefore, PageRequest pageRequest)
JobTable	withId(java.util.UUID id)
JobTable	withOrderLimitAndOffset(java.lang.String order, int limit, long offset)
JobTable	withScheduledAt(java.time.Instant scheduledBefore)
JobTable	withState(StateName state)
JobTable	withUpdatedBefore(java.time.Instant updatedBefore)

Methods inherited from class org.jobrunr.storage.sql.common.db.Sql

delete, delete, execute, forType, insert, insert, insert, insertAll, select, selectCount, selectExists, update, update, update, update, updateAll, using, with, with, with, withoutType, withVersion

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JobTable

public JobTable(javax.sql.DataSource dataSource,
                JobMapper jobMapper)

Method Detail

withId

public JobTable withId(java.util.UUID id)

withState

public JobTable withState(StateName state)

withScheduledAt

public JobTable withScheduledAt(java.time.Instant scheduledBefore)

withUpdatedBefore

public JobTable withUpdatedBefore(java.time.Instant updatedBefore)

save

public Job save(Job jobToSave)

save

public java.util.List<Job> save(java.util.List<Job> jobs)

selectJobById

public java.util.Optional<Job> selectJobById(java.util.UUID id)

countJobs

public long countJobs(StateName state)

selectJobsByState

public java.util.List<Job> selectJobsByState(StateName state,
                                             PageRequest pageRequest)

selectJobsByState

public java.util.List<Job> selectJobsByState(StateName state,
                                             java.time.Instant updatedBefore,
                                             PageRequest pageRequest)

selectJobsScheduledBefore

public java.util.List<Job> selectJobsScheduledBefore(java.time.Instant scheduledBefore,
                                                     PageRequest pageRequest)

getDistinctJobSignatures

public java.util.Set<java.lang.String> getDistinctJobSignatures(StateName[] states)

exists

public boolean exists(JobDetails jobDetails,
                      StateName... states)

recurringJobExists

public boolean recurringJobExists(java.lang.String recurringJobId,
                                  StateName... states)

deletePermanently

public int deletePermanently(java.util.UUID... ids)

deleteJobsByStateAndUpdatedBefore

public int deleteJobsByStateAndUpdatedBefore(StateName state,
                                             java.time.Instant updatedBefore)

withOrderLimitAndOffset

public JobTable withOrderLimitAndOffset(java.lang.String order,
                                        int limit,
                                        long offset)

Overrides:

withOrderLimitAndOffset in class Sql<Job>