public void ItShouldBePossibleToSetupGtLtQueries()
{
const int id = 10;
const string userName = "******";
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 > {1} AND {0}.UserName < '{2}' )", table.Alias,id,userName));
table.AddField("Id");
table.AddField("UserName");
table.AddField("Password");
table.And(
table.Gt(id).SetFieldName("Id"),
table.Lt(userName).SetFieldName("UserName")
);
var result = PurgeQuery(creator.CreateQuery<string>(table));
Assert.AreEqual(expected, result);
}
