public void CorrectlyExecutesScriptIfItHasntAlreadyBeenExecuted()
{
ConnectionSettings settings = getConnectionSettings();
string scriptFile = @"c:\scripts\Update\01_Test.sql";
string fileContents = "file contents...";
MockRepository mocks = new MockRepository();
IScriptExecutionTracker executionTracker = mocks.CreateMock <IScriptExecutionTracker>();
IFileSystem fileSystem = mocks.CreateMock <IFileSystem>();
IQueryExecutor queryExecutor = mocks.CreateMock <IQueryExecutor>();
ITaskObserver taskObserver = mocks.CreateMock <ITaskObserver>();
Expect.Call(executionTracker.ScriptAlreadyExecuted(settings, "01_Test.sql")).Return(false);
taskObserver.Log("Executing: 01_Test.sql");
Expect.Call(fileSystem.ReadTextFile(scriptFile)).Return(fileContents);
queryExecutor.ExecuteNonQuery(settings, fileContents, true);
executionTracker.MarkScriptAsExecuted(settings, "01_Test.sql", taskObserver);
mocks.ReplayAll();
IChangeScriptExecutor executor = new ChangeScriptExecutor(executionTracker, queryExecutor, fileSystem);
executor.Execute(scriptFile, settings, taskObserver);
mocks.VerifyAll();
}
public void CorrectlyExecutesScriptIfItHasntAlreadyBeenExecuted()
{
var settings = new ConnectionSettings("server", "db", true, null, null);
string scriptFile = @"c:\scripts\TestData\01_Test.sql";
string fileContents = "file contents...";
MockRepository mocks = new MockRepository();
IScriptExecutionTracker executionTracker = mocks.StrictMock <IScriptExecutionTracker>();
IFileSystem fileSystem = mocks.StrictMock <IFileSystem>();
IQueryExecutor queryExecutor = mocks.StrictMock <IQueryExecutor>();
ITaskObserver taskObserver = mocks.StrictMock <ITaskObserver>();
Expect.Call(executionTracker.TestDataScriptAlreadyExecuted(settings, "01_Test.sql")).Return(false);
taskObserver.Log("Executing: 01_Test.sql in a transaction");
Expect.Call(fileSystem.ReadTextFile(scriptFile)).Return(fileContents);
Expect.Call(queryExecutor.ScriptSupportsTransactions(fileContents)).Return(true);
queryExecutor.ExecuteNonQueryTransactional(settings, fileContents);
executionTracker.MarkTestDataScriptAsExecuted(settings, "01_Test.sql", taskObserver);
mocks.ReplayAll();
ITestDataScriptExecutor executor = new TestDataScriptExecutor(executionTracker, queryExecutor, fileSystem);
executor.Execute(scriptFile, settings, taskObserver);
mocks.VerifyAll();
}
public void RunsScriptsWithTransactionalStopWordsNonTransactional()
{
ConnectionSettings settings = getConnectionSettings();
string scriptFile = @"c:\scripts\Update\01_Test.sql";
string fileContents = "CREATE DATABASE ...";
MockRepository mocks = new MockRepository();
IScriptExecutionTracker executionTracker = mocks.StrictMock <IScriptExecutionTracker>();
IFileSystem fileSystem = mocks.StrictMock <IFileSystem>();
IQueryExecutor queryExecutor = mocks.StrictMock <IQueryExecutor>();
ITaskObserver taskObserver = mocks.StrictMock <ITaskObserver>();
Expect.Call(executionTracker.ScriptAlreadyExecuted(settings, "01_Test.sql")).Return(false);
taskObserver.Log("Executing: 01_Test.sql");
Expect.Call(fileSystem.ReadTextFile(scriptFile)).Return(fileContents);
Expect.Call(queryExecutor.ScriptSupportsTransactions(fileContents)).Return(false);
queryExecutor.ExecuteNonQuery(settings, fileContents, true);
executionTracker.MarkScriptAsExecuted(settings, "01_Test.sql", taskObserver);
mocks.ReplayAll();
IChangeScriptExecutor executor = new ChangeScriptExecutor(executionTracker, queryExecutor, fileSystem);
executor.Execute(scriptFile, settings, taskObserver);
mocks.VerifyAll();
}
public void CorrectlyLogsWarningWhenScriptHasAlreadyBeenExecuted()
{
ConnectionSettings settings = getConnectionSettings();
string scriptFile = @"c:\scripts\Update\01_Test.sql";
MockRepository mocks = new MockRepository();
IScriptExecutionTracker executionTracker = mocks.CreateMock <IScriptExecutionTracker>();
ITaskObserver taskObserver = mocks.CreateMock <ITaskObserver>();
Expect.Call(executionTracker.ScriptAlreadyExecuted(settings, "01_Test.sql")).Return(true);
taskObserver.Log("Skipping (already executed): 01_Test.sql");
mocks.ReplayAll();
IChangeScriptExecutor executor = new ChangeScriptExecutor(executionTracker, null, null);
executor.Execute(scriptFile, settings, taskObserver);
mocks.VerifyAll();
}
public void DoesNotExecuteScriptsInBaseLineMode()
{
ConnectionSettings settings = getConnectionSettings();
string scriptFile = @"c:\scripts\Update\01_Test.sql";
MockRepository mocks = new MockRepository();
IScriptExecutionTracker executionTracker = mocks.StrictMock <IScriptExecutionTracker>();
ITaskObserver taskObserver = mocks.StrictMock <ITaskObserver>();
DoNotExpect.Call(executionTracker.ScriptAlreadyExecuted(settings, "01_Test.sql"));
taskObserver.Log("Skipping (already executed): 01_Test.sql");
mocks.ReplayAll();
IChangeScriptExecutor executor = new ChangeScriptExecutor(executionTracker, null, null);
executor.Execute(scriptFile, settings, taskObserver);
mocks.VerifyAll();
}
public ChangeScriptExecutor(IScriptExecutionTracker executionTracker, IQueryExecutor executor, IFileSystem fileSystem)
{
_executionTracker = executionTracker;
_executor = executor;
_fileSystem = fileSystem;
}
public ChangeScriptExecutor(IScriptExecutionTracker executionTracker, IQueryExecutor executor, IFileSystem fileSystem)
{
_executionTracker = executionTracker;
_executor = executor;
_fileSystem = fileSystem;
}
