/// <inheritdoc />
public void Sql(string sqlStatement, string description)
{
var expression = new ExecuteSqlStatementExpression {
SqlStatement = sqlStatement, Description = description
};
_context.Expressions.Add(expression);
}
public void Sql(string sqlStatement, bool sayStatement)
{
var expression = new ExecuteSqlStatementExpression {
SqlStatement = sqlStatement, SayStatement = sayStatement
};
_context.Expressions.Add(expression);
}
private void AddSql(string sql)
{
var expression = new ExecuteSqlStatementExpression(_context.CurrentDatabaseProvider, _databaseProviders, _sqlSyntax)
{
SqlStatement = sql
};
_context.Expressions.Add(expression);
}
public void ToStringIsDescriptive()
{
var expression = new ExecuteSqlStatementExpression()
{
SqlStatement = "INSERT INTO BLAH"
};
expression.ToString().ShouldBe("ExecuteSqlStatement INSERT INTO BLAH");
}
public void ToStringCanUseDescription()
{
var expression = new ExecuteSqlStatementExpression()
{
SqlStatement = "INSERT INTO BLAH", Description = "FOOBAR"
};
expression.ToString().ShouldBe("ExecuteSqlStatement FOOBAR");
}
public void ToStringCanDisableOutput()
{
var expression = new ExecuteSqlStatementExpression()
{
SqlStatement = "INSERT INTO BLAH"
};
expression.ToString().ShouldBe("");
}
public void ErrorIsReturnWhenSqlStatementIsNullOrEmpty()
{
var expression = new ExecuteSqlStatementExpression()
{
SqlStatement = null
};
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldContain(ErrorMessages.SqlStatementCannotBeNullOrEmpty);
}
public void ExecutesTheStatement()
{
var expression = new ExecuteSqlStatementExpression()
{
SqlStatement = "INSERT INTO BLAH"
};
var processor = new Mock <IMigrationProcessor>();
processor.Setup(x => x.Execute(expression.SqlStatement)).Verifiable();
expression.ExecuteWith(processor.Object);
processor.Verify();
}
public string Generate(ExecuteSqlStatementExpression expression)
{
return(expression.SqlStatement);
}
