This is meant to be an abstract base class for most, if not all, IDriverDelegate
implementations. Subclasses should override only those methods that need
special handling for the DBMS driver in question.
Inheritance Hierarchy
Quartz.Impl.AdoJobStoreAdoConstants
Quartz.Impl.AdoJobStoreStdAdoConstants
Quartz.Impl.AdoJobStoreStdAdoDelegate
More...
Namespace: Quartz.Impl.AdoJobStore
Assembly: Quartz (in Quartz.dll) Version: 3.0.0
Syntax
C#
public class StdAdoDelegate : StdAdoConstants, IDriverDelegate, IDbAccessor
The StdAdoDelegate type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | StdAdoDelegate | Initializes a new instance of the StdAdoDelegate class |
Properties
| Name | Description | |
|---|---|---|
 | CanUseProperties | |
| DbProvider | |
| SchedulerNameLiteral |
Methods
| Name | Description | |
|---|---|---|
| AddCommandParameter | |
 | AddDefaultTriggerPersistenceDelegates | |
| AddTriggerPersistenceDelegate | |
| CalendarExists |
Check whether or not a calendar exists.
|
| CalendarIsReferenced |
Check whether or not a calendar is referenced by any triggers.
|
| ClearData | |
| ConvertFromProperty |
Convert the JobDataMap into a list of properties.
|
| ConvertToProperty |
Convert the JobDataMap into a list of properties.
|
| CountMisfiredTriggersInState |
Get the number of triggers in the given state that have
misfired - according to the given timestamp.
|
| DeleteAllPausedTriggerGroups |
Deletes all paused trigger groups.
|
| DeleteBlobTrigger |
Delete the cron trigger data for a trigger.
|
| DeleteCalendar |
Delete a calendar.
|
| DeleteFiredTrigger |
Delete a fired trigger.
|
| DeleteFiredTriggers(ConnectionAndTransactionHolder, CancellationToken) |
Delete all fired triggers.
|
| DeleteFiredTriggers(ConnectionAndTransactionHolder, String, CancellationToken) |
Delete all fired triggers of the given instance.
|
| DeleteJobDetail |
Delete the job detail record for the given job.
|
| DeletePausedTriggerGroup(ConnectionAndTransactionHolder, GroupMatcherTriggerKey, CancellationToken) | |
| DeletePausedTriggerGroup(ConnectionAndTransactionHolder, String, CancellationToken) |
Deletes the paused trigger group.
|
| DeleteSchedulerState |
Deletes the state of the scheduler.
|
| DeleteTrigger |
Delete the base trigger data for a trigger.
|
| DeleteTriggerExtension | |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| FindTriggerPersistenceDelegate(String) | |
| FindTriggerPersistenceDelegate(IOperableTrigger) | |
| GetBooleanFromDbValue |
Gets the boolean value from db presentation. Subclasses can overwrite this behaviour.
|
| GetDateTimeFromDbValue |
Gets the date/time value from db presentation. Subclasses can overwrite this behaviour.
|
| GetDbBooleanValue |
Gets the db presentation for boolean value. Subclasses can overwrite this behaviour.
|
| GetDbDateTimeValue |
Gets the db presentation for date/time value. Subclasses can overwrite this behaviour.
|
| GetDbTimeSpanValue |
Gets the db presentation for time span value. Subclasses can overwrite this behaviour.
|
| GetHashCode | Serves as the default hash function. (Inherited from Object.) |
| GetJobDataFromBlobT |
This method should be overridden by any delegate subclasses that need
special handling for BLOBs for job details.
|
| GetKeyOfNonSerializableValue | |
| GetObjectFromBlobT |
This method should be overridden by any delegate subclasses that need
special handling for BLOBs. The default implementation uses standard
ADO.NET operations.
|
| GetSelectNextMisfiredTriggersInStateToAcquireSql | |
| GetSelectNextTriggerToAcquireSql | |
| GetStorableJobTypeName | |
| GetTimeSpanFromDbValue |
Gets the time span value from db presentation. Subclasses can overwrite this behaviour.
|
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| HasMisfiredTriggersInState(ConnectionAndTransactionHolder, String, DateTimeOffset, CancellationToken) |
Get the names of all of the triggers in the given state that have
misfired - according to the given timestamp.
|
| HasMisfiredTriggersInState(ConnectionAndTransactionHolder, String, DateTimeOffset, Int32, ICollectionTriggerKey, CancellationToken) |
Get the names of all of the triggers in the given state that have
misfired - according to the given timestamp. No more than count will
be returned.
|
| Initialize |
Initializes the driver delegate.
|
| InsertBlobTrigger |
Insert the blob trigger data.
|
| InsertCalendar |
Insert a new calendar.
|
| InsertFiredTrigger |
Insert a fired trigger.
|
| InsertJobDetail |
Insert the job detail record.
|
| InsertPausedTriggerGroup |
Inserts the paused trigger group.
|
| InsertSchedulerState |
Inserts the state of the scheduler.
|
| InsertTrigger |
Insert the base trigger data.
|
| IsExistingTriggerGroup |
Determines whether given trigger group already exists.
|
| IsJobStateful |
Check whether or not the given job is stateful.
|
| IsMatcherEqualsT | |
| IsTriggerGroupPaused |
Determines whether the specified trigger group is paused.
|
| JobExists |
Check whether or not the given job exists.
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| PrepareCommand | |
| ReadBytesFromBlob | |
| ReplaceTablePrefix |
Replace the table prefix in a query by replacing any occurrences of
"{0}" with the table prefix.
|
| SelectCalendar |
Select a calendar.
|
| SelectCalendars |
Select all of the stored calendars.
|
| SelectFiredTriggerInstanceNames |
Select the distinct instance names of all fired-trigger records.
|
| SelectFiredTriggerRecords |
Select the states of all fired-trigger records for a given trigger, or
trigger group if trigger name is .
|
| SelectFiredTriggerRecordsByJob |
Select the states of all fired-trigger records for a given job, or job
group if job name is .
|
| SelectInstancesFiredTriggerRecords |
Select the states of all fired-trigger records for a given scheduler
instance.
|
| SelectJobDetail |
Select the JobDetail object for a given job name / group name.
|
| SelectJobExecutionCount |
Selects the job execution count.
|
| SelectJobForTrigger(ConnectionAndTransactionHolder, TriggerKey, ITypeLoadHelper, CancellationToken) | |
| SelectJobForTrigger(ConnectionAndTransactionHolder, TriggerKey, ITypeLoadHelper, Boolean, CancellationToken) | |
| SelectJobGroups |
Select all of the job group names that are stored.
|
| SelectJobsInGroup |
Select all of the jobs contained in a given group.
|
| SelectMisfiredTriggers |
Get the names of all of the triggers that have misfired.
|
| SelectMisfiredTriggersInGroupInState |
Get the names of all of the triggers in the given group and state that
have misfired.
|
| SelectNumCalendars |
Select the total number of calendars stored.
|
| SelectNumJobs |
Select the total number of jobs stored.
|
| SelectNumTriggers |
Select the total number of triggers stored.
|
| SelectNumTriggersForJob |
Select the number of triggers associated with a given job.
|
| SelectPausedTriggerGroups |
Selects the paused trigger groups.
|
| SelectSchedulerStateRecords |
A List of all current SchedulerStateRecords.
If instanceId is not null, then only the record for the identified instance will be returned. |
| SelectTrigger |
Select a trigger.
|
| SelectTriggerForFireTime |
Select the trigger that will be fired at the given fire time.
|
| SelectTriggerGroups(ConnectionAndTransactionHolder, CancellationToken) |
Select all of the trigger group names that are stored.
|
| SelectTriggerGroups(ConnectionAndTransactionHolder, GroupMatcherTriggerKey, CancellationToken) | |
| SelectTriggerJobDataMap |
Select a trigger's JobDataMap.
|
| SelectTriggerNamesForJob |
Get the names of all of the triggers associated with the given job.
|
| SelectTriggersForCalendar |
Select the triggers for a calendar
|
| SelectTriggersForJob |
Select the triggers for a job
|
| SelectTriggersForRecoveringJobs |
Select all of the triggers for jobs that are requesting recovery. The
returned trigger objects will have unique "recoverXXX" trigger names and
will be in the DefaultRecoveryGroup
trigger group.
|
| SelectTriggersInGroup |
Select all of the triggers contained in a given group.
|
| SelectTriggersInState |
Select all of the triggers in a given state.
|
| SelectTriggerState |
Select a trigger's state value.
|
| SelectTriggerStatus |
Select a trigger status (state and next fire time).
|
| SelectTriggerToAcquire |
Select the next trigger which will fire to fire between the two given timestamps
in ascending order of fire time, and then descending by priority.
|
| SerializeJobData |
Remove the transient data from and then create a serialized MemoryStream
version of a JobDataMap and returns the underlying bytes.
|
| SerializeObject |
Create a serialized byte[] version of an Object.
|
| ToSqlEqualsClauseT | |
| ToSqlLikeClauseT | |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| TriggerExists |
Check whether or not a trigger exists.
|
| UpdateBlobTrigger |
Update the blob trigger data.
|
| UpdateCalendar |
Update a calendar.
|
| UpdateFiredTrigger | Update a fired trigger. |
| UpdateJobData |
Update the job data map for the given job.
|
| UpdateJobDetail |
Update the job detail record.
|
| UpdateSchedulerState |
Updates the state of the scheduler.
|
| UpdateTrigger |
Update the base trigger data.
|
| UpdateTriggerGroupStateFromOtherState |
Update all of the triggers of the given group to the given new state, if
they are in the given old state.
|
| UpdateTriggerGroupStateFromOtherStates |
Update all triggers in the given group to the given new state, if they
are in one of the given old states.
|
| UpdateTriggerState |
Update the state for a given trigger.
|
| UpdateTriggerStateFromOtherState |
Update the given trigger to the given new state, if it is in the given
old state.
|
| UpdateTriggerStateFromOtherStates |
Update the given trigger to the given new state, if it is one of the
given old states.
|
| UpdateTriggerStatesForJob |
Update the states of all triggers associated with the given job.
|
| UpdateTriggerStatesForJobFromOtherState |
Updates the state of the trigger states for job from other.
|
| UpdateTriggerStatesFromOtherStates |
Insert the job detail record.
|
See Also
Reference
Inheritance Hierarchy
Quartz.Impl.AdoJobStoreAdoConstants
Quartz.Impl.AdoJobStoreStdAdoConstants
Quartz.Impl.AdoJobStoreStdAdoDelegate
Quartz.Impl.AdoJobStoreFirebirdDelegate
Quartz.Impl.AdoJobStoreMySQLDelegate
Quartz.Impl.AdoJobStoreOracleDelegate
Quartz.Impl.AdoJobStorePostgreSQLDelegate
Quartz.Impl.AdoJobStoreSQLiteDelegate
Quartz.Impl.AdoJobStoreSqlServerDelegate