public void SqlJobShouldExecuteSqlStatements()
{
var job = new SqlJobToSucceed();
job.SetParameters(DateTime.Parse("1/1/2012"), "abcd", "TestLogs");
job.Execute();
var cmd = new SqlCommand("select top 1 LogText from TestLogs order by id desc", job.Connection);
var returnValue = cmd.ExecuteScalar();
returnValue.ShouldEqual("Macro parameter will be replaced anywhere. Inserting into TestLogs");
}
public void JobExecutorShouldWait()
{
var job = new SqlJobToSucceed();
job.SetParameters(DateTime.Parse("1/1/2012"), "abcd", "TestLogs");
_fileQueue.Enqueue(job);
var jobExecutor = new JobExecutor(_fileQueue);
jobExecutor.MonitorJobQueue(null);
_fileQueue.Count.ShouldEqual(0);
jobExecutor.MonitorJobQueue(null);
}
public void SqlJobWithParametersShouldBePreservedAfterEnqueued()
{
var job = new SqlJobToSucceed();
job.SetParameters(DateTime.Parse("1/1/2012"), "abcd", "TestLogs");
JobQueue.Enqueue(job);
JobQueue.Count.ShouldEqual(1);
var job2 = JobQueue.Peek();
job2.Parameters.Count.ShouldEqual(3);
}
public void SqlJobDequeueShouldDecreaseCountBy1()
{
var job = new SqlJobToSucceed();
job.SetParameters(DateTime.Parse("1/1/2012"), "abcd", "TestLogs");
JobQueue.Enqueue(job);
JobQueue.Dequeue();
JobQueue.Count.ShouldEqual(0);
}
