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); }