Package org.jobrunr.storage.sql.common

Class DefaultSqlStorageProvider

java.lang.Object

org.jobrunr.storage.AbstractStorageProvider

org.jobrunr.storage.sql.common.DefaultSqlStorageProvider

All Implemented Interfaces:

java.lang.AutoCloseable, SqlStorageProvider, StorageProvider

Direct Known Subclasses:

DB2StorageProvider, H2StorageProvider, MariaDbStorageProvider, OracleStorageProvider, PostgresStorageProvider, SqLiteStorageProvider, SQLServerStorageProvider

public class DefaultSqlStorageProvider
extends AbstractStorageProvider
implements SqlStorageProvider

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	DefaultSqlStorageProvider.DatabaseOptions

Field Summary

Fields

Modifier and Type	Field	Description
protected DefaultSqlStorageProvider.DatabaseOptions	databaseOptions
protected javax.sql.DataSource	dataSource
protected JobMapper	jobMapper

Constructor Summary

Constructors

Constructor	Description
DefaultSqlStorageProvider(javax.sql.DataSource dataSource)
DefaultSqlStorageProvider(javax.sql.DataSource dataSource, DefaultSqlStorageProvider.DatabaseOptions databaseOptions)

Method Summary

Modifier and Type	Method	Description
void	announceBackgroundJobServer(BackgroundJobServerStatus serverStatus)
protected BackgroundJobServerTable	backgroundJobServerTable()
java.lang.Long	countJobs(StateName state)
protected void	createDBIfNecessary()
int	deleteJobs(StateName state, java.time.Instant updatedBefore)
int	deletePermanently(java.util.UUID id)
int	deleteRecurringJob(java.lang.String id)
boolean	exists(JobDetails jobDetails, StateName... states)
java.util.List<BackgroundJobServerStatus>	getBackgroundJobServers()
protected DatabaseCreator	getDatabaseCreator()
Job	getJobById(java.util.UUID id)
Page<Job>	getJobPage(StateName state, PageRequest pageRequest)
java.util.List<Job>	getJobs(StateName state, java.time.Instant updatedBefore, PageRequest pageRequest)
java.util.List<Job>	getJobs(StateName state, PageRequest pageRequest)
JobStats	getJobStats()
java.util.List<RecurringJob>	getRecurringJobs()
java.util.List<Job>	getScheduledJobs(java.time.Instant scheduledBefore, PageRequest pageRequest)
protected JobTable	jobTable()
void	publishJobStatCounter(StateName state, int amount)
protected RecurringJobTable	recurringJobTable()
int	removeTimedOutBackgroundJobServers(java.time.Instant heartbeatOlderThan)
java.util.List<Job>	save(java.util.List<Job> jobs)
Job	save(Job jobToSave)
RecurringJob	saveRecurringJob(RecurringJob recurringJob)
void	setJobMapper(JobMapper jobMapper)
boolean	signalBackgroundJobServerAlive(BackgroundJobServerStatus serverStatus)
void	signalBackgroundJobServerStopped(BackgroundJobServerStatus serverStatus)

Methods inherited from class org.jobrunr.storage.AbstractStorageProvider

addJobStorageOnChangeListener, close, delete, notifyJobStatsOnChangeListeners, notifyOnChangeListenersIf, removeJobStorageOnChangeListener

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.jobrunr.storage.StorageProvider

addJobStorageOnChangeListener, close, delete, getJobById, removeJobStorageOnChangeListener

Field Detail

dataSource

protected final javax.sql.DataSource dataSource

databaseOptions

protected final DefaultSqlStorageProvider.DatabaseOptions databaseOptions

jobMapper

protected JobMapper jobMapper

Constructor Detail

DefaultSqlStorageProvider

public DefaultSqlStorageProvider(javax.sql.DataSource dataSource)

DefaultSqlStorageProvider

public DefaultSqlStorageProvider(javax.sql.DataSource dataSource,
                                 DefaultSqlStorageProvider.DatabaseOptions databaseOptions)

Method Detail

createDBIfNecessary

protected void createDBIfNecessary()

getDatabaseCreator

protected DatabaseCreator getDatabaseCreator()

setJobMapper

public void setJobMapper(JobMapper jobMapper)

Specified by:

setJobMapper in interface StorageProvider

announceBackgroundJobServer

public void announceBackgroundJobServer(BackgroundJobServerStatus serverStatus)

Specified by:

announceBackgroundJobServer in interface StorageProvider

signalBackgroundJobServerAlive

public boolean signalBackgroundJobServerAlive(BackgroundJobServerStatus serverStatus)

Specified by:

signalBackgroundJobServerAlive in interface StorageProvider

signalBackgroundJobServerStopped

public void signalBackgroundJobServerStopped(BackgroundJobServerStatus serverStatus)

Specified by:

signalBackgroundJobServerStopped in interface StorageProvider

getBackgroundJobServers

public java.util.List<BackgroundJobServerStatus> getBackgroundJobServers()

Specified by:

getBackgroundJobServers in interface StorageProvider

removeTimedOutBackgroundJobServers

public int removeTimedOutBackgroundJobServers(java.time.Instant heartbeatOlderThan)

Specified by:

removeTimedOutBackgroundJobServers in interface StorageProvider

getJobById

public Job getJobById(java.util.UUID id)

Specified by:

getJobById in interface StorageProvider

save

public Job save(Job jobToSave)

Specified by:

save in interface StorageProvider

deletePermanently

public int deletePermanently(java.util.UUID id)

Specified by:

deletePermanently in interface StorageProvider

save

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

Specified by:

save in interface StorageProvider

getJobs

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

Specified by:

getJobs in interface StorageProvider

getJobs

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

Specified by:

getJobs in interface StorageProvider

getScheduledJobs

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

Specified by:

getScheduledJobs in interface StorageProvider

countJobs

public java.lang.Long countJobs(StateName state)

Specified by:

countJobs in interface StorageProvider

getJobPage

public Page<Job> getJobPage(StateName state,
                            PageRequest pageRequest)

Specified by:

getJobPage in interface StorageProvider

deleteJobs

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

Specified by:

deleteJobs in interface StorageProvider

exists

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

Specified by:

exists in interface StorageProvider

saveRecurringJob

public RecurringJob saveRecurringJob(RecurringJob recurringJob)

Specified by:

saveRecurringJob in interface StorageProvider

getRecurringJobs

public java.util.List<RecurringJob> getRecurringJobs()

Specified by:

getRecurringJobs in interface StorageProvider

deleteRecurringJob

public int deleteRecurringJob(java.lang.String id)

Specified by:

deleteRecurringJob in interface StorageProvider

getJobStats

public JobStats getJobStats()

Specified by:

getJobStats in interface StorageProvider

publishJobStatCounter

public void publishJobStatCounter(StateName state,
                                  int amount)

Specified by:

publishJobStatCounter in interface StorageProvider

jobTable

protected JobTable jobTable()

recurringJobTable

protected RecurringJobTable recurringJobTable()

backgroundJobServerTable

protected BackgroundJobServerTable backgroundJobServerTable()