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(Connection connection, Dialect dialect, String tablePrefix, JobMapper jobMapper)

Method Summary

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

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

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

Methods inherited from class java.lang.Object

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

Constructor Details

JobTable

public JobTable(Connection connection,
 Dialect dialect,
 String tablePrefix,
 JobMapper jobMapper)

Method Details

withId

public JobTable withId(UUID id)

withState

public JobTable withState(StateName state)

withScheduledAt

public JobTable withScheduledAt(Instant scheduledBefore)

withUpdatedBefore

public JobTable withUpdatedBefore(Instant updatedBefore)

save

public Job save(Job jobToSave)
         throws SQLException

Throws:

SQLException

save

public List<Job> save(List<Job> jobs)
               throws SQLException

Throws:

SQLException

selectJobById

public Optional<Job> selectJobById(UUID id)

countJobs

public long countJobs(StateName state)
               throws SQLException

Throws:

SQLException

selectJobsByState

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

selectJobsByState

public List<Job> selectJobsByState(StateName state,
 Instant updatedBefore,
 PageRequest pageRequest)

selectJobsScheduledBefore

public List<Job> selectJobsScheduledBefore(Instant scheduledBefore,
 PageRequest pageRequest)

getDistinctJobSignatures

public Set<String> getDistinctJobSignatures(StateName[] states)

exists

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

Throws:

SQLException

recurringJobExists

public boolean recurringJobExists(String recurringJobId,
 StateName... states)
                           throws SQLException

Throws:

SQLException

deletePermanently

public int deletePermanently(UUID... ids)
                      throws SQLException

Throws:

SQLException

deleteJobsByStateAndUpdatedBefore

public int deleteJobsByStateAndUpdatedBefore(StateName state,
 Instant updatedBefore)
                                      throws SQLException

Throws:

SQLException

withOrderLimitAndOffset

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

Overrides:

withOrderLimitAndOffset in class Sql<Job>