C# Class BlueCollar.SqlServerRepository

Implements IRepository using SQL Server.

Inheritance: IRepository

Afficher le fichier Open project: ChadBurggraf/blue-collar

Méthodes publiques

Méthode	Description
BeginTransaction ( ) : IDbTransaction	Begins a transaction.
BeginTransaction ( IsolationLevel level ) : IDbTransaction	Begins a transaction.
ClearWorkingSignalPair ( long workerId, long workingId, IDbTransaction transaction ) : void	Clears signals for the given worker and working job if applicable.
CreateQueuedAndHistoryForSchedule ( long scheduleId, System.DateTime scheduleDate, IEnumerable queued, IEnumerable history, IDbTransaction transaction ) : int	Creates the queue and history records for the given schedule.
DeleteAll ( string applicationName, IDbTransaction transaction ) : void	Deletes all data in the repository.
DeleteHistory ( string applicationName, System.DateTime olderThan, IDbTransaction transaction ) : void	Deletes history older than the given date.
DeleteQueued ( long id, IDbTransaction transaction ) : void	Deletes the queued record with the given ID.
DeleteSchedule ( long id, IDbTransaction transaction ) : void	Deletes the schedule record with the given ID.
DeleteScheduledJob ( long id, IDbTransaction transaction ) : void	Deletes the scheduled job record with the given ID.
DeleteWorker ( long id, IDbTransaction transaction ) : void	Deletes the worker record with the given ID.
DeleteWorking ( long id, IDbTransaction transaction ) : void	Deletes the working record with the given ID.
Dispose ( ) : void	Disposes of resources used by this instance.
GetCounts ( string applicationName, IDbTransaction transaction ) : CountsRecord	Gets a set of counts for the given application.
GetHistoryDetails ( long id, IDbTransaction transaction ) : HistoryDetailsRecord	Gets a history details record.
GetHistoryList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList	Gets a list of history records.
GetQueuedDetails ( long id, IDbTransaction transaction ) : QueueDetailsRecord	Gets a queued details record.
GetQueuedList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList	Gets a list of queue records.
GetSchedule ( long id, IDbTransaction transaction ) : ScheduleRecord	Gets the schedule with the given ID, NOT including its related scheduled jobs.
GetScheduleDateExistsForSchedule ( long scheduleId, System.DateTime scheduleDate, IDbTransaction transaction ) : bool	Gets a value indicating whether data exists for the given schedule ID and calculated schedule date. If it does, this indicates that jobs have already been enqueued for the schedule and should not be enqueued again until the next calculated schedule date.
GetScheduleEnqueueingLock ( long scheduleId, System.DateTime forceIfOlderThan, IDbTransaction transaction ) : bool	Attempts to obtain the enqueueing lock for the given schedule ID.
GetScheduleList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList	Gets a list of schedule records.
GetScheduledJobList ( string applicationName, long id, string search, int limit, int offset, IDbTransaction transaction ) : ScheduledJobRecordList	Gets a schedule and its related scheduled jobs, filtered by the given list parameters.
GetSchedules ( string applicationName, IDbTransaction transaction ) : IEnumerable	Gets a collection of schedules and their related scheduled jobs for the given application name.
GetStatistics ( string applicationName, System.DateTime recentBeginDate, System.DateTime distantBeginDate, System.DateTime endDate, IDbTransaction transaction ) : StatisticsRecord	Gets a set of system statistics for the given application name and date ranges.
GetWorker ( long id, IDbTransaction transaction ) : WorkerRecord	Gets the worker record with the given ID.
GetWorkerList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList	Gets a list of worker records.
GetWorkers ( string applicationName, string machineAddress, string machineName, IDbTransaction transaction ) : IEnumerable	Gets the worker collection for the given machine.
GetWorking ( long id, IDbTransaction transaction ) : WorkingRecord	Gets the working record with the given ID.
GetWorkingDetails ( long id, IDbTransaction transaction ) : WorkingDetailsRecord	Gets a working details record.
GetWorkingForWorker ( long workerId, long excludingId, IDbTransaction transaction ) : IEnumerable	Gets a collection of working records that belong to the given worker ID.
GetWorkingList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList	Gets a list of working records.
GetWorkingSignals ( long workerId, long workingId, IDbTransaction transaction ) : SignalsRecord	Gets the current signals set for a worker and a working job, if applicable.
ReleaseScheduleEnqueueingLock ( long scheduleId, IDbTransaction transaction ) : void	Releases the enqueueing lock for the schedule with the given ID.
SignalWorkers ( string applicationName, WorkerSignal signal, IDbTransaction transaction ) : void	Signals all workers for the given application name.
SplitSqlCommands ( string sql ) : IList	Splits a string of SQL commands on "GO" to enable issuing them individually using ADO.
SqlServerRepository ( string connectionString ) : System	Initializes a new instance of the SqlServerRepository class.
UpdateSchedule ( ScheduleRecord record, IDbTransaction transaction ) : ScheduleRecord	Updates the given schedule.
UpdateScheduledJob ( ScheduledJobRecord record, IDbTransaction transaction ) : ScheduledJobRecord	Updates the given scheduled job.
UpdateScheduledJobOrder ( ScheduledJobOrderRecord record, IDbTransaction transaction ) : void	Updates the scheduled job's order number.
UpdateWorker ( WorkerRecord record, IDbTransaction transaction ) : WorkerRecord	Updates the given worker.
UpdateWorkerStatus ( long id, WorkerStatus status, IDbTransaction transaction ) : void	Updates the status of the worker with the given ID.
UpdateWorking ( WorkingRecord record, IDbTransaction transaction ) : WorkingRecord	Updates the given working record.

Méthodes protégées

Méthode	Description
Dispose ( bool disposing ) : void	Disposes of resources used by this instance.
EnsureSchema ( SqlConnection connection ) : void	Ensures the BlueCollar schema is installed on the given connection, installing it if necessary.

Private Methods

Méthode	Description
CreateCounts ( Dapper.SqlMapper multi ) : CountsRecord	Creates a new CountsRecord by reading from the given multi-mapped reader.
CreateHistory ( HistoryRecord record, IDbTransaction transaction ) : HistoryRecord
CreateHistoryStatusCounts ( Dapper.SqlMapper multi ) : HistoryStatusCountsRecord	Creates a new HistoryStatusCountsRecord by reading from the given multi-mapped reader.
CreateQueued ( QueueRecord record, IDbTransaction transaction ) : QueueRecord
CreateSchedule ( ScheduleRecord record, IDbTransaction transaction ) : ScheduleRecord
CreateScheduledJob ( ScheduledJobRecord record, IDbTransaction transaction ) : ScheduledJobRecord
CreateWorker ( WorkerRecord record, IDbTransaction transaction ) : WorkerRecord
CreateWorking ( WorkingRecord record, IDbTransaction transaction ) : WorkingRecord
GetQueued ( string applicationName, QueueNameFilters queueFilters, System.DateTime queuedBefore, IDbTransaction transaction ) : QueueRecord

Method Details

BeginTransaction() public méthode

Begins a transaction.

public BeginTransaction ( ) : IDbTransaction
Résultat	IDbTransaction

BeginTransaction() public méthode

Begins a transaction.

public BeginTransaction ( IsolationLevel level ) : IDbTransaction
level	IsolationLevel	The isolation level to use for the transaction.
Résultat	IDbTransaction

ClearWorkingSignalPair() public méthode

Clears signals for the given worker and working job if applicable.

public ClearWorkingSignalPair ( long workerId, long workingId, IDbTransaction transaction ) : void
workerId	long	The ID of the worker to clear the signal of.
workingId	long	The ID of the working job to clear the signal of, if applicable.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

CreateQueuedAndHistoryForSchedule() public méthode

Creates the queue and history records for the given schedule.

public CreateQueuedAndHistoryForSchedule ( long scheduleId, System.DateTime scheduleDate, IEnumerable queued, IEnumerable history, IDbTransaction transaction ) : int
scheduleId	long	The ID of the schedule records are being created for.
scheduleDate	System.DateTime	The schedule date records are being created for.
queued	IEnumerable	The queued records to create.
history	IEnumerable	The history records to create.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	int

DeleteAll() public méthode

Deletes all data in the repository.

public DeleteAll ( string applicationName, IDbTransaction transaction ) : void
applicationName	string	The name of the application to delete data for.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

DeleteHistory() public méthode

Deletes history older than the given date.

public DeleteHistory ( string applicationName, System.DateTime olderThan, IDbTransaction transaction ) : void
applicationName	string	The name of the application to delete data for.
olderThan	System.DateTime	The date to delete history older than.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

DeleteQueued() public méthode

Deletes the queued record with the given ID.

public DeleteQueued ( long id, IDbTransaction transaction ) : void
id	long	The ID of the queued record to delete.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

DeleteSchedule() public méthode

Deletes the schedule record with the given ID.

public DeleteSchedule ( long id, IDbTransaction transaction ) : void
id	long	The ID of the schedule to delete.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

DeleteScheduledJob() public méthode

Deletes the scheduled job record with the given ID.

public DeleteScheduledJob ( long id, IDbTransaction transaction ) : void
id	long	The ID of the scheduled job to delete.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

DeleteWorker() public méthode

Deletes the worker record with the given ID.

public DeleteWorker ( long id, IDbTransaction transaction ) : void
id	long	The ID of the worker to delete.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

DeleteWorking() public méthode

Deletes the working record with the given ID.

public DeleteWorking ( long id, IDbTransaction transaction ) : void
id	long	The ID of the working record to delete.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

Dispose() public méthode

Disposes of resources used by this instance.

public Dispose ( ) : void
Résultat	void

Dispose() protected méthode

Disposes of resources used by this instance.

protected Dispose ( bool disposing ) : void
disposing	bool	A value indicating whether to dispose of managed resources.
Résultat	void

EnsureSchema() protected static méthode

Ensures the BlueCollar schema is installed on the given connection, installing it if necessary.

protected static EnsureSchema ( SqlConnection connection ) : void
connection	System.Data.SqlClient.SqlConnection	The connection to ensure the BlueCollar schema for.
Résultat	void

GetCounts() public méthode

Gets a set of counts for the given application.

public GetCounts ( string applicationName, IDbTransaction transaction ) : CountsRecord
applicationName	string	The name of the application to get counts for.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	CountsRecord

GetHistoryDetails() public méthode

Gets a history details record.

public GetHistoryDetails ( long id, IDbTransaction transaction ) : HistoryDetailsRecord
id	long	The ID of the record to get.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	HistoryDetailsRecord

GetHistoryList() public méthode

Gets a list of history records.

public GetHistoryList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList
applicationName	string	The name of the application to get the history list for.
search	string	The search query to filter the collection with.
limit	int	The paging limit to use.
offset	int	The paging offset to use.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	RecordList

GetQueuedDetails() public méthode

Gets a queued details record.

public GetQueuedDetails ( long id, IDbTransaction transaction ) : QueueDetailsRecord
id	long	The ID of the record to get.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	QueueDetailsRecord

GetQueuedList() public méthode

Gets a list of queue records.

public GetQueuedList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList
applicationName	string	The name of the application to get the queue list for.
search	string	The search query to filter the collection with.
limit	int	The paging limit to use.
offset	int	The paging offset to use.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	RecordList

GetSchedule() public méthode

Gets the schedule with the given ID, NOT including its related scheduled jobs.

public GetSchedule ( long id, IDbTransaction transaction ) : ScheduleRecord
id	long	The ID of the schedule to get.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	ScheduleRecord

GetScheduleDateExistsForSchedule() public méthode

Gets a value indicating whether data exists for the given schedule ID and calculated schedule date. If it does, this indicates that jobs have already been enqueued for the schedule and should not be enqueued again until the next calculated schedule date.

public GetScheduleDateExistsForSchedule ( long scheduleId, System.DateTime scheduleDate, IDbTransaction transaction ) : bool
scheduleId	long	The ID of the schedule to check data for.
scheduleDate	System.DateTime	The calculated schedule date to check data for.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	bool

GetScheduleEnqueueingLock() public méthode

Attempts to obtain the enqueueing lock for the given schedule ID.

public GetScheduleEnqueueingLock ( long scheduleId, System.DateTime forceIfOlderThan, IDbTransaction transaction ) : bool
scheduleId	long	The ID of the schedule to obtain the schedule enqueueing lock for.
forceIfOlderThan	System.DateTime	A date to compare the enqueue lock's last updated date with. If /// the lock is older than the given date, then it will be forced and acquired by the caller.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	bool

GetScheduleList() public méthode

Gets a list of schedule records.

public GetScheduleList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList
applicationName	string	The name of the application to get the schedule list for.
search	string	The search query to filter the collection with.
limit	int	The paging limit to use.
offset	int	The paging offset to use.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	RecordList

GetScheduledJobList() public méthode

Gets a schedule and its related scheduled jobs, filtered by the given list parameters.

public GetScheduledJobList ( string applicationName, long id, string search, int limit, int offset, IDbTransaction transaction ) : ScheduledJobRecordList
applicationName	string	The name of the application to get the scheduled job list for.
id	long	The ID of the schedule to get.
search	string	The search query to filter the related job collection with.
limit	int	The paging limit to use.
offset	int	The paging offset to use.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	ScheduledJobRecordList

GetSchedules() public méthode

Gets a collection of schedules and their related scheduled jobs for the given application name.

public GetSchedules ( string applicationName, IDbTransaction transaction ) : IEnumerable
applicationName	string	The name of the application to get schedules for.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	IEnumerable

GetStatistics() public méthode

Gets a set of system statistics for the given application name and date ranges.

public GetStatistics ( string applicationName, System.DateTime recentBeginDate, System.DateTime distantBeginDate, System.DateTime endDate, IDbTransaction transaction ) : StatisticsRecord
applicationName	string	The name of the application to get system statistics for.
recentBeginDate	System.DateTime	The begin date of the recent period to get statistics for.
distantBeginDate	System.DateTime	The begin date of the distant period to get statistics for.
endDate	System.DateTime	The end date of the distant period to get statistics for.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	StatisticsRecord

GetWorker() public méthode

Gets the worker record with the given ID.

public GetWorker ( long id, IDbTransaction transaction ) : WorkerRecord
id	long	The ID of the worker record to get.
transaction	IDbTransaction	The transaction to use.
Résultat	WorkerRecord

GetWorkerList() public méthode

Gets a list of worker records.

public GetWorkerList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList
applicationName	string	The application name to get records for.
search	string	The search query to filter the collection with.
limit	int	The paging limit to use.
offset	int	The paging offset to use.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	RecordList

GetWorkers() public méthode

Gets the worker collection for the given machine.

public GetWorkers ( string applicationName, string machineAddress, string machineName, IDbTransaction transaction ) : IEnumerable
applicationName	string	The application name to get workers for.
machineAddress	string	The address of the machine to get workers for.
machineName	string	The name of the machine to get workers for.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	IEnumerable

GetWorking() public méthode

Gets the working record with the given ID.

public GetWorking ( long id, IDbTransaction transaction ) : WorkingRecord
id	long	The ID of the record to get.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	WorkingRecord

GetWorkingDetails() public méthode

Gets a working details record.

public GetWorkingDetails ( long id, IDbTransaction transaction ) : WorkingDetailsRecord
id	long	The ID of the record to get.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	WorkingDetailsRecord

GetWorkingForWorker() public méthode

Gets a collection of working records that belong to the given worker ID.

public GetWorkingForWorker ( long workerId, long excludingId, IDbTransaction transaction ) : IEnumerable
workerId	long	The ID of the worker to get working records for.
excludingId	long	The ID of the working record to exclude, if applicable.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	IEnumerable

GetWorkingList() public méthode

Gets a list of working records.

public GetWorkingList ( string applicationName, string search, int limit, int offset, IDbTransaction transaction ) : RecordList
applicationName	string	The application name to get records for.
search	string	The search query to filter the collection with.
limit	int	The paging limit to use.
offset	int	The paging offset to use.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	RecordList

GetWorkingSignals() public méthode

Gets the current signals set for a worker and a working job, if applicable.

public GetWorkingSignals ( long workerId, long workingId, IDbTransaction transaction ) : SignalsRecord
workerId	long	The ID of the worker to get a signal for.
workingId	long	The ID of the working job to get a signal for, if applicable.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	SignalsRecord

ReleaseScheduleEnqueueingLock() public méthode

Releases the enqueueing lock for the schedule with the given ID.

public ReleaseScheduleEnqueueingLock ( long scheduleId, IDbTransaction transaction ) : void
scheduleId	long	The ID of the schedule to release the enqueueing lock for.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

SignalWorkers() public méthode

Signals all workers for the given application name.

public SignalWorkers ( string applicationName, WorkerSignal signal, IDbTransaction transaction ) : void
applicationName	string	The application name to signal workers for.
signal	WorkerSignal	The signal to set.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

SplitSqlCommands() public static méthode

Splits a string of SQL commands on "GO" to enable issuing them individually using ADO.

public static SplitSqlCommands ( string sql ) : IList
sql	string	The SQL command set to split.
Résultat	IList

SqlServerRepository() public méthode

Initializes a new instance of the SqlServerRepository class.

public SqlServerRepository ( string connectionString ) : System
connectionString	string	The connection string to use when connecting to the database.
Résultat	System

UpdateSchedule() public méthode

Updates the given schedule.

public UpdateSchedule ( ScheduleRecord record, IDbTransaction transaction ) : ScheduleRecord
record	ScheduleRecord	The schedule record to update.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	ScheduleRecord

UpdateScheduledJob() public méthode

Updates the given scheduled job.

public UpdateScheduledJob ( ScheduledJobRecord record, IDbTransaction transaction ) : ScheduledJobRecord
record	ScheduledJobRecord	The scheduled job record to update.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	ScheduledJobRecord

UpdateScheduledJobOrder() public méthode

Updates the scheduled job's order number.

public UpdateScheduledJobOrder ( ScheduledJobOrderRecord record, IDbTransaction transaction ) : void
record	ScheduledJobOrderRecord	The scheduled job order record identifying the scheduled job to update.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

UpdateWorker() public méthode

Updates the given worker.

public UpdateWorker ( WorkerRecord record, IDbTransaction transaction ) : WorkerRecord
record	WorkerRecord	The worker record to update.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	WorkerRecord

UpdateWorkerStatus() public méthode

Updates the status of the worker with the given ID.

public UpdateWorkerStatus ( long id, WorkerStatus status, IDbTransaction transaction ) : void
id	long	The ID of the worker to update status for.
status	WorkerStatus	The status to update.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	void

UpdateWorking() public méthode

Updates the given working record.

public UpdateWorking ( WorkingRecord record, IDbTransaction transaction ) : WorkingRecord
record	WorkingRecord	The working record to update.
transaction	IDbTransaction	The transaction to use, if applicable.
Résultat	WorkingRecord