Class PostgreSQLDelegate

Namespace

Quartz.Impl.AdoJobStore

Assembly

Quartz.dll

This is a driver delegate for the PostgreSQL ADO.NET driver.

public class PostgreSQLDelegate : StdAdoDelegate, IDriverDelegate, IDbAccessor

Inheritance

object

StdAdoDelegate

PostgreSQLDelegate

Implements

IDriverDelegate

IDbAccessor

Inherited Members

StdAdoDelegate.InsertCalendar(ConnectionAndTransactionHolder, string, ICalendar, CancellationToken)

StdAdoDelegate.UpdateCalendar(ConnectionAndTransactionHolder, string, ICalendar, CancellationToken)

StdAdoDelegate.CalendarExists(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.SelectCalendar(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.CalendarIsReferenced(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.DeleteCalendar(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.DbProvider

StdAdoDelegate.SchedulerName

StdAdoDelegate.Initialize(DriverDelegateContext)

StdAdoDelegate.AddDefaultTriggerPersistenceDelegates()

StdAdoDelegate.CanUseProperties

StdAdoDelegate.ClearData(ConnectionAndTransactionHolder, CancellationToken)

StdAdoDelegate.GetDbBooleanValue(bool)

StdAdoDelegate.GetBooleanFromDbValue(object)

StdAdoDelegate.GetDbDateTimeValue(DateTimeOffset?)

StdAdoDelegate.GetDateTimeFromDbValue(object)

StdAdoDelegate.GetDbTimeSpanValue(TimeSpan?)

StdAdoDelegate.GetTimeSpanFromDbValue(object)

StdAdoDelegate.SelectJobKeysInGroup(ConnectionAndTransactionHolder, GroupMatcher<JobKey>, CancellationToken)

StdAdoDelegate.MatchGroup<T>(GroupMatcher<T>, string, string)

StdAdoDelegate.IsMatcherEquals<T>(StringMatcher<T>)

StdAdoDelegate.ToSqlEqualsClause<T>(StringMatcher<T>)

StdAdoDelegate.ToSqlLikeClause<T>(StringMatcher<T>)

StdAdoDelegate.ToSqlLikeClause(StringOperator, string)

StdAdoDelegate.AdditionalLikeWildcards

StdAdoDelegate.EscapeSqlLikeWildcards(string)

StdAdoDelegate.EscapeSqlLikeWildcards(string, string)

StdAdoDelegate.ReplaceTablePrefix(string)

StdAdoDelegate.SerializeObject(object)

StdAdoDelegate.GetKeyOfNonSerializableValue(JobDataMap)

StdAdoDelegate.ConvertFromProperty(NameValueCollection)

StdAdoDelegate.ConvertToProperty(IDictionary<string, object>)

StdAdoDelegate.GetObjectFromBlob<T>(DbDataReader, int, CancellationToken)

StdAdoDelegate.ReadBytesFromBlob(DbDataReader, int, CancellationToken)

StdAdoDelegate.PrepareCommand(ConnectionAndTransactionHolder, string)

StdAdoDelegate.AddCommandParameter(DbCommand, string, object, Enum, int?)

StdAdoDelegate.ValidateSchema(ConnectionAndTransactionHolder, CancellationToken)

StdAdoDelegate.CreateSchema(ConnectionAndTransactionHolder, CancellationToken)

StdAdoDelegate.UpdateJobDetail(ConnectionAndTransactionHolder, IJobDetail, CancellationToken)

StdAdoDelegate.SelectTriggerKeysForJob(ConnectionAndTransactionHolder, JobKey, CancellationToken)

StdAdoDelegate.SelectTriggerKeysForJob(ConnectionAndTransactionHolder, JobKey, StoredTriggerState, CancellationToken)

StdAdoDelegate.SelectTriggerKeysForJobs(ConnectionAndTransactionHolder, IReadOnlyCollection<JobKey>, CancellationToken)

StdAdoDelegate.DeleteJobDetail(ConnectionAndTransactionHolder, JobKey, CancellationToken)

StdAdoDelegate.JobExists(ConnectionAndTransactionHolder, JobKey, CancellationToken)

StdAdoDelegate.UpdateJobData(ConnectionAndTransactionHolder, IJobDetail, CancellationToken)

StdAdoDelegate.SelectJobDetail(ConnectionAndTransactionHolder, JobKey, ITypeLoader, CancellationToken)

StdAdoDelegate.SelectJobDetails(ConnectionAndTransactionHolder, IReadOnlyCollection<JobKey>, ITypeLoader, CancellationToken)

StdAdoDelegate.SelectJobForTrigger(ConnectionAndTransactionHolder, TriggerKey, ITypeLoader, bool, CancellationToken)

StdAdoDelegate.SerializeJobData(JobDataMap)

StdAdoDelegate.GetJobDataFromBlob<T>(DbDataReader, int, CancellationToken)

StdAdoDelegate.InsertJobDetail(ConnectionAndTransactionHolder, IJobDetail, CancellationToken)

StdAdoDelegate.InsertPausedJobGroup(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.DeletePausedJobGroup(ConnectionAndTransactionHolder, GroupMatcher<JobKey>, CancellationToken)

StdAdoDelegate.IsJobGroupPaused(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.SelectPausedJobGroups(ConnectionAndTransactionHolder, IReadOnlyCollection<string>, CancellationToken)

StdAdoDelegate.InsertPausedJobGroups(ConnectionAndTransactionHolder, IReadOnlyCollection<string>, CancellationToken)

StdAdoDelegate.ApplyPaging(string, bool)

StdAdoDelegate.AddPagingParameters(DbCommand, int, int, bool)

StdAdoDelegate.SelectJobHeaders(ConnectionAndTransactionHolder, JobQuery, CancellationToken)

StdAdoDelegate.SelectTriggerHeaders(ConnectionAndTransactionHolder, TriggerQuery, CancellationToken)

StdAdoDelegate.SelectJobGroups(ConnectionAndTransactionHolder, JobGroupQuery, CancellationToken)

StdAdoDelegate.SelectTriggerGroups(ConnectionAndTransactionHolder, TriggerGroupQuery, CancellationToken)

StdAdoDelegate.SelectCalendarNames(ConnectionAndTransactionHolder, CalendarQuery, CancellationToken)

StdAdoDelegate.SelectFireInstances(ConnectionAndTransactionHolder, FireInstanceQuery, CancellationToken)

StdAdoDelegate.InsertSchedulerState(ConnectionAndTransactionHolder, string, DateTimeOffset, TimeSpan, CancellationToken)

StdAdoDelegate.DeleteSchedulerState(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.UpdateSchedulerState(ConnectionAndTransactionHolder, string, DateTimeOffset, CancellationToken)

StdAdoDelegate.SelectSchedulerStateRecords(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.UpdateTriggerStatesFromOtherStates(ConnectionAndTransactionHolder, StoredTriggerState, IReadOnlyCollection<StoredTriggerState>, CancellationToken)

StdAdoDelegate.SelectTriggersInState(ConnectionAndTransactionHolder, StoredTriggerState, CancellationToken)

StdAdoDelegate.SelectTriggerKeysInState(ConnectionAndTransactionHolder, IReadOnlyCollection<TriggerKey>, StoredTriggerState, CancellationToken)

StdAdoDelegate.GetSelectMisfiredTriggersToRecoverSql(int)

StdAdoDelegate.CountMisfiredTriggersInState(ConnectionAndTransactionHolder, StoredTriggerState, DateTimeOffset, CancellationToken)

StdAdoDelegate.SelectTriggersForRecoveringJobs(ConnectionAndTransactionHolder, CancellationToken)

StdAdoDelegate.DeleteFiredTriggers(ConnectionAndTransactionHolder, FiredTriggerQuery, CancellationToken)

StdAdoDelegate.IsJobCurrentlyExecuting(ConnectionAndTransactionHolder, JobKey, CancellationToken)

StdAdoDelegate.InsertTrigger(ConnectionAndTransactionHolder, IOperableTrigger, StoredTriggerState, IJobDetail, CancellationToken)

StdAdoDelegate.InsertBlobTrigger(ConnectionAndTransactionHolder, IOperableTrigger, CancellationToken)

StdAdoDelegate.UpdateTrigger(ConnectionAndTransactionHolder, IOperableTrigger, StoredTriggerState, IJobDetail, CancellationToken)

StdAdoDelegate.UpdateBlobTrigger(ConnectionAndTransactionHolder, IOperableTrigger, CancellationToken)

StdAdoDelegate.UpdateTriggerState(ConnectionAndTransactionHolder, TriggerKey, StoredTriggerState, CancellationToken)

StdAdoDelegate.UpdateTriggerStateFromOtherStates(ConnectionAndTransactionHolder, TriggerKey, StoredTriggerState, IReadOnlyCollection<StoredTriggerState>, CancellationToken)

StdAdoDelegate.UpdateTriggerStatesFromOtherStates(ConnectionAndTransactionHolder, IReadOnlyCollection<TriggerKey>, StoredTriggerState, IReadOnlyCollection<StoredTriggerState>, CancellationToken)

StdAdoDelegate.UpdateTriggerGroupStateFromOtherStates(ConnectionAndTransactionHolder, GroupMatcher<TriggerKey>, StoredTriggerState, IReadOnlyCollection<StoredTriggerState>, CancellationToken)

StdAdoDelegate.UpdateTriggerStateFromOtherState(ConnectionAndTransactionHolder, TriggerKey, StoredTriggerState, StoredTriggerState, CancellationToken)

StdAdoDelegate.UpdateTriggerStateFromOtherStateWithNextFireTime(ConnectionAndTransactionHolder, TriggerKey, StoredTriggerState, StoredTriggerState, DateTimeOffset, CancellationToken)

StdAdoDelegate.UpdateTriggerGroupStateFromOtherState(ConnectionAndTransactionHolder, GroupMatcher<TriggerKey>, StoredTriggerState, StoredTriggerState, CancellationToken)

StdAdoDelegate.UpdateTriggerStatesForJob(ConnectionAndTransactionHolder, JobKey, StoredTriggerState, CancellationToken)

StdAdoDelegate.UpdateTriggerStatesForJobFromOtherState(ConnectionAndTransactionHolder, JobKey, StoredTriggerState, StoredTriggerState, CancellationToken)

StdAdoDelegate.UpdateTriggerStatesForJobsFromOtherState(ConnectionAndTransactionHolder, IReadOnlyCollection<JobKey>, StoredTriggerState, StoredTriggerState, CancellationToken)

StdAdoDelegate.UpdateTriggerStatesForJobFromOtherState(ConnectionAndTransactionHolder, JobKey, IReadOnlyList<TriggerStateTransition>, CancellationToken)

StdAdoDelegate.ApplyTriggerFired(ConnectionAndTransactionHolder, TriggerFiredUpdate, CancellationToken)

StdAdoDelegate.DeleteBlobTrigger(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.DeleteTrigger(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.DeleteTriggerExtension(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.SelectTrigger(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.SelectTriggerJobDataMap(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.SelectTriggerState(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.SelectTriggerStateWithExecuting(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.SelectTriggerHeader(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.SelectStoredTriggerHeaders(ConnectionAndTransactionHolder, IReadOnlyCollection<TriggerKey>, CancellationToken)

StdAdoDelegate.SelectTriggerGroupNames(ConnectionAndTransactionHolder, GroupMatcher<TriggerKey>, CancellationToken)

StdAdoDelegate.SelectTriggerKeysInGroup(ConnectionAndTransactionHolder, GroupMatcher<TriggerKey>, CancellationToken)

StdAdoDelegate.InsertPausedTriggerGroup(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.DeletePausedTriggerGroup(ConnectionAndTransactionHolder, GroupMatcher<TriggerKey>, CancellationToken)

StdAdoDelegate.IsTriggerGroupPaused(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.GetSelectNextTriggerToAcquireSql(TriggerAcquisitionSqlShape)

StdAdoDelegate.FiltersAcquisitionJobTypeExclusions

StdAdoDelegate.AddPreferredNodeParameters(DbCommand, DateTimeOffset)

StdAdoDelegate.UpdateTriggerPreferredNodeConditional(ConnectionAndTransactionHolder, TriggerKey, PreferredNodeTransition, CancellationToken)

StdAdoDelegate.RepinTriggersFromDeadNode(ConnectionAndTransactionHolder, string, string, CancellationToken)

StdAdoDelegate.GetCountMisfiredTriggersInStateSql()

StdAdoDelegate.SelectTriggersToAcquire(ConnectionAndTransactionHolder, TriggerAcquisitionCriteria, CancellationToken)

StdAdoDelegate.SelectExecutionGroupsInFlight(ConnectionAndTransactionHolder, CancellationToken)

StdAdoDelegate.InsertFiredTrigger(ConnectionAndTransactionHolder, IOperableTrigger, StoredTriggerState, IJobDetail, CancellationToken)

StdAdoDelegate.InsertFiredTriggers(ConnectionAndTransactionHolder, IReadOnlyList<IOperableTrigger>, StoredTriggerState, IJobDetail, CancellationToken)

StdAdoDelegate.SelectFiredTriggerRecords(ConnectionAndTransactionHolder, FiredTriggerQuery, CancellationToken)

StdAdoDelegate.SelectFiredTriggerInstanceNames(ConnectionAndTransactionHolder, CancellationToken)

StdAdoDelegate.DeleteFiredTrigger(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.DeleteFiredTriggers(ConnectionAndTransactionHolder, IReadOnlyCollection<string>, CancellationToken)

StdAdoDelegate.AddTriggerPersistenceDelegate(ITriggerPersistenceDelegate)

StdAdoDelegate.FindTriggerPersistenceDelegate(IOperableTrigger)

StdAdoDelegate.FindTriggerPersistenceDelegate(string)

StdAdoDelegate.TriggerExists(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.CountTriggersForJob(ConnectionAndTransactionHolder, JobKey, CancellationToken)

StdAdoDelegate.SelectTriggersForJob(ConnectionAndTransactionHolder, JobKey, CancellationToken)

StdAdoDelegate.SelectTriggersForCalendar(ConnectionAndTransactionHolder, string, CancellationToken)

StdAdoDelegate.UpdateMisfireOriginalFireTime(ConnectionAndTransactionHolder, TriggerKey, DateTimeOffset?, CancellationToken)

StdAdoDelegate.ClearMisfireOriginalFireTime(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.UpdateMisfiredTrigger(ConnectionAndTransactionHolder, IOperableTrigger, StoredTriggerState, DateTimeOffset?, CancellationToken)

StdAdoDelegate.UpdateTriggerForRetry(ConnectionAndTransactionHolder, IOperableTrigger, StoredTriggerState, CancellationToken)

StdAdoDelegate.ClearTriggerRetryAttempt(ConnectionAndTransactionHolder, TriggerKey, CancellationToken)

StdAdoDelegate.SelectMisfiredTriggersToRecover(ConnectionAndTransactionHolder, StoredTriggerState, DateTimeOffset, int, CancellationToken)

StdAdoDelegate.SelectTriggers(ConnectionAndTransactionHolder, IReadOnlyCollection<TriggerKey>, CancellationToken)

StdAdoDelegate.UpdateMisfiredTriggers(ConnectionAndTransactionHolder, IReadOnlyList<MisfiredTriggerUpdate>, CancellationToken)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Properties

SchemaResourceName

The embedded script that creates this dialect's schema, or null when this delegate has none.

protected override string? SchemaResourceName { get; }

Property Value

string

Remarks

Null on StdAdoDelegate itself, because there is no dialect-neutral DDL: the six shipped delegates each name their own script, and a delegate written outside Quartz names one or leaves provisioning unavailable. Overriding it is the whole of what a delegate has to do to support CreateIfMissing.

The name is a manifest resource name, looked for in the assembly of the delegate's own type and then in each assembly up its base chain. So a delegate of somebody else's can embed a script of its own beside itself, and one that subclasses a shipped dialect delegate to change a statement or two inherits that dialect's script rather than having to carry a copy.

Methods

GetRowLimit(int)

PostgreSQL limits rows with a trailing LIMIT n.

protected override SqlRowLimit GetRowLimit(int count)

Parameters

count int

Returns

SqlRowLimit