public void ExecutesTheStatement() { var expression = new ExecuteSqlScriptExpression { SqlScript = testSqlScript }; var processor = new Mock<IMigrationProcessor>(); processor.Setup(x => x.Execute(scriptContents)).Verifiable(); expression.ExecuteWith(processor.Object); processor.Verify(); }
public void Script(string pathToSqlScript, IDictionary<string, string> tokenDictionary) { var expression = new ExecuteSqlScriptExpression { SqlScript = pathToSqlScript, Parameters = tokenDictionary }; _context.Expressions.Add(expression); }
public void CanUseScriptsOnAnotherDriveToWorkingDirectory() { var scriptOnAnotherDrive = "z" + Path.VolumeSeparatorChar + Path.DirectorySeparatorChar + testSqlScript; var expression = new ExecuteSqlScriptExpression { SqlScript = scriptOnAnotherDrive }; var conventions = new MigrationConventions { GetWorkingDirectory = () => "c" + Path.VolumeSeparatorChar + Path.DirectorySeparatorChar + "code" }; expression.ApplyConventions(conventions); expression.SqlScript.ShouldBe(scriptOnAnotherDrive); }
public void Script(string pathToSqlScript) { var expression = new ExecuteSqlScriptExpression { SqlScript = pathToSqlScript }; _context.Expressions.Add(expression); }
public void ToStringIsDescriptive() { var expression = new ExecuteSqlScriptExpression { SqlScript = testSqlScript }; expression.ToString().ShouldBe("ExecuteSqlScript embeddedtestscript.sql"); }
public void ErrorIsReturnWhenSqlScriptIsNullOrEmpty() { var expression = new ExecuteSqlScriptExpression { SqlScript = null }; var errors = ValidationHelper.CollectErrors(expression); errors.ShouldContain(ErrorMessages.SqlScriptCannotBeNullOrEmpty); }
public void ExecutesTheStatementWithParameters() { const string scriptContents = "TEST SCRIPT ParameterValue $(escaped_parameter)"; var expression = new ExecuteSqlScriptExpression { SqlScript = "testscript-withparameters.sql", Parameters = new Dictionary<string, string> {{"parameter", "ParameterValue"}} }; var processor = new Mock<IMigrationProcessor>(); processor.Setup(x => x.Execute(scriptContents)).Verifiable(); expression.ExecuteWith(processor.Object); processor.Verify(); }