public void PagedQueryFiltering_WhenFilteringValueBetweenExclusive_ThenDataAndCountQueriesContainsWhereClauseWithProperCondition()
{
var startDate = new DateTime(2000, 10, 20);
var endDate = new DateTime(2010, 10, 20);
PagedQuery <Data> query = BuildPagedQuery(b => b.Where("Column1", Is.Between(startDate, endDate, inclusive: false)));
ShouldContainWhere(query, "WHERE Column1 >= @p1 AND Column1 < @p2");
ParameterValueShouldBe(query, "p1", startDate);
ParameterValueShouldBe(query, "p2", endDate);
}
public void WhereBetweenWithIsHelper()
{
FlowQuerySelection <UserEntity> users = Query <UserEntity>()
.Where(u => u.Id, FqIs.Between(2, 3))
.Select();
Assert.That(users.Count(), Is.EqualTo(2));
foreach (UserEntity user in users)
{
Assert.That(user.Id, Is.InRange(2, 3));
}
}
public void CanFilterBetween()
{
FlowQuerySelection <UserEntity> users = Query <UserEntity>()
.Where(x => x.Id, FqIs.Between(2, 4))
.Select();
Assert.That(users.Count(), Is.EqualTo(3));
foreach (UserEntity u in users)
{
Assert.That(u.Id, Is.InRange(2, 4));
}
}
public static IQueryFilter <UserEntity> Id_Of_User_UsingWhereHelper_Is(int between, int and)
{
return(new QueryFilter <UserEntity>(query => query.And((x, y) => y(x.Id, Is.Between(between, and)))));
}
public static IQueryFilter <UserEntity> Id_SpecifedByMagicString_Of_User_Is(int between, int and)
{
return(new QueryFilter <UserEntity>(query => query.And("Id", Is.Between(between, and))));
}
public static IQueryFilter <UserEntity> Id_Of_User_Is(int between, int and)
{
return(new QueryFilter <UserEntity>(query => query.And(x => x.Id, Is.Between(between, and))));
}
