public Execute ( string fullFilename, AliaSQL.Core.Model.ConnectionSettings settings, ITaskObserver taskObserver, bool logOnly = false ) : void | ||
fullFilename | string | |
settings | AliaSQL.Core.Model.ConnectionSettings | |
taskObserver | ITaskObserver | |
logOnly | bool | |
return | void |
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.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 in a transaction"); Expect.Call(fileSystem.ReadTextFile(scriptFile)).Return(fileContents); queryExecutor.ExecuteNonQueryTransactional(settings, fileContents); 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.StrictMock<IScriptExecutionTracker>(); ITaskObserver taskObserver = mocks.StrictMock<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 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(); }