public void Execute_Processes_JobTable()
{
using (var connection = ConnectionUtils.CreateConnection())
{
// Arrange
const string createSql = @"
insert into HangFire.Job (InvocationData, Arguments, CreatedAt, ExpireAt)
values ('', '', getutcdate(), @expireAt)";
connection.Execute(createSql, new { expireAt = DateTime.UtcNow.AddMonths(-1) });
var manager = CreateManager();
// Act
manager.Execute(_token);
// Assert
Assert.Equal(0, connection.Query <int>(@"select count(*) from HangFire.Job").Single());
}
}
public void Execute_Processes_CounterTable()
{
using (var connection = ConnectionUtils.CreateConnection())
{
// Arrange
const string createSql = @"
insert into HangFire.Counter ([Key], [Value], ExpireAt)
values ('key', 1, @expireAt)";
connection.Execute(createSql, new { expireAt = DateTime.UtcNow.AddMonths(-1) });
var manager = CreateManager();
// Act
manager.Execute(_token);
// Assert
Assert.Equal(0, connection.Query <int>(@"select count(*) from HangFire.Counter").Single());
}
}
