C# Class R.Scheduler.Persistance.PostgreStore

PostgreSQL implementation of IPersistanceStore

Inheritance: IPersistanceStore

Show file Open project: R-Suite/R.Scheduler Class Usage Examples

Public Methods

Method	Description
GetCalendarId ( string name ) : System.Guid	Get calendar id mapped to specified name
GetCalendarName ( System.Guid id ) : string	Get calendar name mapped to specified id
GetErroredJobs ( int count ) : IEnumerable	Get count of most recently failed jobs
GetExecutedJobs ( int count ) : IEnumerable	Get count of most recently executed jobs
GetJobId ( JobKey jobKey ) : System.Guid	Get JobId mapped to specified job key
GetJobKey ( System.Guid id ) : JobKey	Get JobKey mapped to specified id
GetTriggerId ( TriggerKey triggerKey ) : System.Guid	Get TriggerId mapped to specified trigger key
GetTriggerKey ( System.Guid id ) : TriggerKey	Get TriggerKey mapped to specified id
InsertAuditLog ( AuditLog log ) : void	Insert AuditLog. Each entry is read-only.
PostgreStore ( string connectionString ) : System
RemoveCalendarIdMap ( string name ) : void	Delete Calendar id mapping
RemoveJobKeyIdMap ( string jobName, string jobGroup ) : void	Delete JobKey id mapping
RemoveTriggerKeyIdMap ( string triggerName, string triggerGroup ) : void	Delete TriggerKey id mapping
UpsertCalendarIdMap ( string name ) : System.Guid	Insert calendar name and return a new id. If calendar name already exists, do nothing and return existing id.
UpsertJobKeyIdMap ( string jobName, string jobGroup, System.Guid jobId = null ) : System.Guid	Insert JobKey and return new (or provided) id. Return existing id if job key laready exists.
UpsertTriggerKeyIdMap ( string triggerName, string triggerGroup ) : System.Guid	Insert trigger key and return a new trigger id. If trigger key already exists, do nothing and return existing trigger id.

Private Methods

Method	Description
GetAuditLogs ( string sql ) : IEnumerable

Method Details

GetCalendarId() public method

Get calendar id mapped to specified name

public GetCalendarId ( string name ) : System.Guid
name	string
return	System.Guid

GetCalendarName() public method

Get calendar name mapped to specified id

public GetCalendarName ( System.Guid id ) : string
id	System.Guid
return	string

GetErroredJobs() public method

Get count of most recently failed jobs

public GetErroredJobs ( int count ) : IEnumerable
count	int
return	IEnumerable

GetExecutedJobs() public method

Get count of most recently executed jobs

public GetExecutedJobs ( int count ) : IEnumerable
count	int
return	IEnumerable

GetJobId() public method

Get JobId mapped to specified job key

public GetJobId ( JobKey jobKey ) : System.Guid
jobKey	JobKey
return	System.Guid

GetJobKey() public method

Get JobKey mapped to specified id

public GetJobKey ( System.Guid id ) : JobKey
id	System.Guid
return	JobKey

GetTriggerId() public method

Get TriggerId mapped to specified trigger key

public GetTriggerId ( TriggerKey triggerKey ) : System.Guid
triggerKey	TriggerKey
return	System.Guid

GetTriggerKey() public method

Get TriggerKey mapped to specified id

public GetTriggerKey ( System.Guid id ) : TriggerKey
id	System.Guid
return	TriggerKey

InsertAuditLog() public method

Insert AuditLog. Each entry is read-only.

public InsertAuditLog ( AuditLog log ) : void
log	R.Scheduler.Interfaces.AuditLog
return	void

PostgreStore() public method

public PostgreStore ( string connectionString ) : System
connectionString	string
return	System

RemoveCalendarIdMap() public method

Delete Calendar id mapping

public RemoveCalendarIdMap ( string name ) : void
name	string
return	void

RemoveJobKeyIdMap() public method

Delete JobKey id mapping

public RemoveJobKeyIdMap ( string jobName, string jobGroup ) : void
jobName	string
jobGroup	string
return	void

RemoveTriggerKeyIdMap() public method

Delete TriggerKey id mapping

public RemoveTriggerKeyIdMap ( string triggerName, string triggerGroup ) : void
triggerName	string
triggerGroup	string
return	void

UpsertCalendarIdMap() public method

Insert calendar name and return a new id. If calendar name already exists, do nothing and return existing id.

public UpsertCalendarIdMap ( string name ) : System.Guid
name	string
return	System.Guid

UpsertJobKeyIdMap() public method

Insert JobKey and return new (or provided) id. Return existing id if job key laready exists.

public UpsertJobKeyIdMap ( string jobName, string jobGroup, System.Guid jobId = null ) : System.Guid
jobName	string
jobGroup	string
jobId	System.Guid
return	System.Guid

UpsertTriggerKeyIdMap() public method

Insert trigger key and return a new trigger id. If trigger key already exists, do nothing and return existing trigger id.

public UpsertTriggerKeyIdMap ( string triggerName, string triggerGroup ) : System.Guid
triggerName	string
triggerGroup	string
return	System.Guid