public void WithWhere_Passes()
{
// Arrange
var rule = new DeleteWithoutWhereRule();
var sqlStatement = "DELETE FROM BigTable WHERE Owner = 15";
var script = Analyzer.Parse(sqlStatement);
// Act
var results = rule.Evaluate(sqlStatement, script);
// Assert
Assert.IsTrue(results.Count == 0);
}
public void WithoutWhere_Warns()
{
// Arrange
var rule = new DeleteWithoutWhereRule();
var sqlStatement = "DELETE FROM BigTable";
var script = Analyzer.Parse(sqlStatement);
// Act
var results = rule.Evaluate(sqlStatement, script);
// Assert
Assert.IsTrue(results.Count == 1);
Assert.AreEqual(results.Single().Rule, rule);
}
