public void RemoveFromQueue_ReallyDeletesTheJobFromTheQueue()
{
UseConnection(connection =>
{
// Arrange
var id = CreateJobQueueRecord(connection, _options, "1", "default");
var processingJob = new FirebirdFetchedJob(connection, _options, id, "1", "default");
// Act
processingJob.RemoveFromQueue();
// Assert
var count = connection.Query <long>(string.Format(@"SELECT COUNT(*) FROM ""{0}.JOBQUEUE""", _options.Prefix)).Single();
Assert.Equal(0, count);
});
}
public void RemoveFromQueue_DoesNotDelete_UnrelatedJobs()
{
UseConnection(connection =>
{
// Arrange
CreateJobQueueRecord(connection, _options, "1", "default");
CreateJobQueueRecord(connection, _options, "1", "critical");
CreateJobQueueRecord(connection, _options, "2", "default");
var fetchedJob = new FirebirdFetchedJob(connection, _options, 999, "1", "default");
// Act
fetchedJob.RemoveFromQueue();
// Assert
var count = connection.Query <long>(string.Format(@"SELECT COUNT(*) FROM ""{0}.JOBQUEUE""", _options.Prefix)).Single();
Assert.Equal(3, count);
});
}
public void RemoveFromQueue_ReallyDeletesTheJobFromTheQueue()
{
UseConnection(connection =>
{
// Arrange
var id = CreateJobQueueRecord(connection, _options, "1", "default");
var processingJob = new FirebirdFetchedJob(connection, _options, id, "1", "default");
// Act
processingJob.RemoveFromQueue();
// Assert
var count = connection.Query<long>(string.Format(@"SELECT COUNT(*) FROM ""{0}.JOBQUEUE""", _options.Prefix)).Single();
Assert.Equal(0, count);
});
}
public void RemoveFromQueue_DoesNotDelete_UnrelatedJobs()
{
UseConnection(connection =>
{
// Arrange
CreateJobQueueRecord(connection, _options, "1", "default");
CreateJobQueueRecord(connection, _options, "1", "critical");
CreateJobQueueRecord(connection, _options, "2", "default");
var fetchedJob = new FirebirdFetchedJob(connection, _options, 999, "1", "default");
// Act
fetchedJob.RemoveFromQueue();
// Assert
var count = connection.Query<long>(string.Format(@"SELECT COUNT(*) FROM ""{0}.JOBQUEUE""", _options.Prefix)).Single();
Assert.Equal(3, count);
});
}
