public void BasicBadFilterDiffrentTypes()
{
var target = new TestFilter();
target.HasIntColFilter(123);
target.HasShortColFilterBadColName(123);
Assert.Fail();
}
public void HasIntColFilter()
{
var target = new TestFilter();
target.HasIntColFilter(123);
target.HasIntColFilter(456);
Assert.Fail();
}
public void BasicTestWithWhere()
{
var target = new TestFilter();
target.HasIntColFilter(123);
Assert.IsTrue(target.Parameters.Count == 1);
Assert.AreEqual("WHERE intCol = @value", target.ToSQLFilter(true));
}
public void BasicTestSillyAnd()
{
var target = new TestFilter();
target.HasIntColFilter(123);
target.HasIntColFilter(123);
Assert.IsTrue(target.Parameters.Count == 1);
Assert.AreEqual("intCol = @value And intCol = @value", target.ToSQLFilter());
}