AliaSQL.UnitTests.ChangeScriptExecutorTester.RunsScriptsWithTransactionalStopWordsNonTransactional C# (CSharp) Method

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