Package org.jobrunr.storage.sql.common
Class JobTable
-
Constructor Summary
ConstructorDescriptionJobTable
(Connection connection, Dialect dialect, String tablePrefix, JobMapper jobMapper) -
Method Summary
Modifier and TypeMethodDescriptionlong
int
deleteJobsByStateAndUpdatedBefore
(StateName state, Instant updatedBefore) int
deletePermanently
(UUID... ids) boolean
exists
(JobDetails jobDetails, StateName... states) getDistinctJobSignatures
(StateName[] states) boolean
recurringJobExists
(String recurringJobId, StateName... states) selectJobById
(UUID id) selectJobsByState
(StateName state, Instant updatedBefore, PageRequest pageRequest) selectJobsByState
(StateName state, PageRequest pageRequest) selectJobsScheduledBefore
(Instant scheduledBefore, PageRequest pageRequest) withOrderLimitAndOffset
(String order, int limit, long offset) withScheduledAt
(Instant scheduledBefore) withUpdatedBefore
(Instant updatedBefore)
-
Constructor Details
-
JobTable
-
-
Method Details
-
withId
-
withState
-
withScheduledAt
-
withUpdatedBefore
-
save
- Throws:
SQLException
-
save
- Throws:
SQLException
-
selectJobById
-
countJobs
- Throws:
SQLException
-
selectJobsByState
-
selectJobsByState
-
selectJobsScheduledBefore
-
getDistinctJobSignatures
-
exists
- Throws:
SQLException
-
recurringJobExists
- Throws:
SQLException
-
deletePermanently
- Throws:
SQLException
-
deleteJobsByStateAndUpdatedBefore
public int deleteJobsByStateAndUpdatedBefore(StateName state, Instant updatedBefore) throws SQLException - Throws:
SQLException
-
withOrderLimitAndOffset
- Overrides:
withOrderLimitAndOffset
in classSql<Job>
-