public void CorrectlyMarksScriptAsExecuted()
{
ConnectionSettings settings = new ConnectionSettings(string.Empty, string.Empty, false, string.Empty, string.Empty);
string scriptFilename = "03_Test.sql";
MockRepository mocks = new MockRepository();
IQueryExecutor queryExecutor = mocks.StrictMock<IQueryExecutor>();
ITaskObserver observer = mocks.StrictMock<ITaskObserver>();
queryExecutor.ExecuteNonQueryTransactional(settings, "insert into usd_AppliedDatabaseScript (ScriptFile, DateApplied, hash) values ('03_Test.sql', getdate(), '')");
mocks.ReplayAll();
IScriptExecutionTracker tracker = new ScriptExecutionTracker(queryExecutor);
tracker.MarkScriptAsExecuted(settings, scriptFilename, observer);
mocks.VerifyAll();
}
public void CorrectlyDeterminesWhenScriptHasNotBeenExecuted()
{
ConnectionSettings settings = new ConnectionSettings(string.Empty, string.Empty, false, string.Empty, string.Empty);
string scriptFilename = "03_Test.sql";
string[] executedScriptFiles = new string[] { "01_Test.sql", "02_Test.sql" };
MockRepository mocks = new MockRepository();
IQueryExecutor queryExecutor = mocks.StrictMock<IQueryExecutor>();
Expect.Call(queryExecutor.ReadFirstColumnAsStringArray(settings, "select ScriptFile from usd_AppliedDatabaseScript")).Return(executedScriptFiles);
mocks.ReplayAll();
IScriptExecutionTracker tracker = new ScriptExecutionTracker(queryExecutor);
bool alreadyExecuted = tracker.ScriptAlreadyExecuted(settings, scriptFilename);
Assert.AreEqual(false, alreadyExecuted);
mocks.VerifyAll();
}