public void TestWhereBoolNotConditionEquals()
{
var expected = "$filter=HasUniqueRoleAssignments eq false";
var query = new ListItemCollection(null, null)
.Where(i => i.HasUniqueRoleAssignments == false);
var result = query.ToString();
Assert.AreEqual(expected, result);
}
public void TestWhereStartsWith()
{
var expected = "$filter=startswith(Title,'Value') eq true";
var query = new ListItemCollection(null, null)
.Where(i => i.Title.StartsWith("Value"));
var result = query.ToString();
Assert.AreEqual(result, expected);
}
public void TestWhereYear()
{
var expected = "$filter=year(Date) eq 1";
var query = new ListItemCollection(null, null)
.Where(i => ((DateTime)i.Values["Date"]).Year == 1);
var result = query.ToString();
Assert.AreEqual(result, expected);
}
public void TestWhereContainsEquals()
{
var expected = "$filter=substringof('Value',Title) eq true";
var query = new ListItemCollection(null, null)
.Where(i => i.Title.Contains("Value") == true);
var result = query.ToString();
Assert.AreEqual(result, expected);
}
public void TestDoubleOr()
{
var expected = "$filter=(id eq 1 or Title eq 'title')";
var query = new ListItemCollection(null, null)
.Where(i => i.Id == 1 || i.Title == "title");
var actual = query.ToString();
Assert.AreEqual(expected, actual, true);
}
public void TestLessEqual()
{
var expected = "$filter=Number le 0";
var query = new ListItemCollection(null, null)
.Where(i => (int)i.Values["Number"] <= 0);
var actual = query.ToString();
Assert.AreEqual(expected, actual);
}
public void TestNotEqual()
{
var expected = "$filter=Title ne 'title'";
var query = new ListItemCollection(null, null)
.Where(i => i.Title != "title");
var actual = query.ToString();
Assert.AreEqual(expected, actual);
}
public void TestQuadrupleOr()
{
var expected = "$filter=(((id eq 1 or Title eq 'title') or Number eq 0) or Number2 eq 1)";
var query = new ListItemCollection(null, null)
.Where(i => i.Id == 1 || i.Title == "title" || (int)i.Values["Number"] == 0 || (int)i.Values["Number2"] == 1);
var actual = query.ToString();
Assert.AreEqual(expected, actual, true);
}