public void ItShouldBePossibleToSetupNullNotNullQuery()
{
var table = new QueryTable("Users");
var creator = new SqLiteQueryCreator();
var expected = PurgeQuery(string.Format("SELECT {0}.Id AS {0}_Id,{0}.UserName AS {0}_UserName," +
"{0}.Password AS {0}_Password FROM Users AS {0}" +
" WHERE ( {0}.Id IS NOT NULL AND {0}.UserName IS NULL )", table.Alias));
table.AddField("Id");
table.AddField("UserName");
table.AddField("Password");
table.And(
table.IsNotNull().SetFieldName("Id"),
table.IsNull().SetFieldName("UserName")
);
var result = PurgeQuery(creator.CreateQuery<string>(table));
Assert.AreEqual(expected, result);
}
