public void ItShouldBePossibleToCreateASimpleSelectQueryWithAnd()
{
var id = Guid.NewGuid();
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}.UserName = '******' AND {0}.Id = '{2}' )", table.Alias, userName, id));
table.AddField("Id");
table.AddField("UserName");
table.AddField("Password");
table.And(
table.Eq(userName).SetFieldName("UserName"),
table.Eq(id).SetFieldName("Id")
);
var result = PurgeQuery(creator.CreateQuery<string>(table));
Assert.AreEqual(expected, result);
}
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);
}
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);
}