public void WhereValue()
{
IEnumerable <int> source = TestData.GetInts();
IEnumerable <int> result = source.Query <int>("SELECT * FROM this WHERE value() > 3");
Assert.IsTrue(result.SequenceEqual(source.Where(i => i > 3)));
}
public void Count()
{
IEnumerable <int> source = TestData.GetInts();
int result = source.QueryScalar <int>("SELECT count(*) FROM this");
Assert.IsTrue(result == source.Count());
}
public void Sum()
{
IEnumerable <int> source = TestData.GetInts();
int result = source.QueryScalar <int>("SELECT sum(value()) FROM this");
Assert.IsTrue(result == source.Sum());
}
public void AvgInt()
{
IEnumerable <int> source = TestData.GetInts();
double result = source.QueryScalar <int, double>("SELECT avg(value()) FROM this");
Assert.IsTrue(result == source.Average());
}
public void CountDistinctValue()
{
IEnumerable <int> source = TestData.GetInts();
int result = source.QueryScalar <int>("SELECT count(DISTINCT value()) FROM this");
Assert.IsTrue(result == source.Distinct().Count());
}
public void CountWhere()
{
IEnumerable <int> source = TestData.GetInts();
int result = source.QueryScalar <int>("SELECT count(*) FROM this WHERE value() > 3");
Assert.IsTrue(result == source.Where(i => i > 3).Count());
}
public void ZeroEvaluautesAsFalseInWhereClause()
{
IEnumerable <int> source = TestData.GetInts();
var result = source.Query <int>("SELECT * FROM this WHERE 2 - 2");
Assert.IsTrue(result.Any() == false);
}
public void EmbeddedFalseInWhereClause()
{
IEnumerable <int> source = TestData.GetInts();
var result = source.Query <int>("SELECT * FROM this WHERE value() > 3 AND FALSE");
Assert.IsTrue(result.Any() == false);
}
public void StdevPInt()
{
IEnumerable <int> source = TestData.GetInts();
double result = source.QueryScalar <int, double>("SELECT StdevP(value()) FROM this");
Assert.AreEqual(result, source.StandardDeviationP(), TestData.Epsilon);
}
public void NonZeroEvaluautesAsTrueInWhereClause()
{
IEnumerable <int> source = TestData.GetInts();
var result = source.Query <int>("SELECT * FROM this WHERE 2 + 3");
Assert.IsTrue(result.Any());
Assert.IsTrue(source.SequenceEqual(result));
}
public void VarPInt()
{
IEnumerable <int> source = TestData.GetInts();
double result = source.QueryScalar <int, double>("SELECT varp(value()) FROM this");
Assert.AreEqual(result, source.VarianceP(), TestData.Epsilon);
}
public void EmbeddedTrueInWhereClause()
{
IEnumerable <int> source = TestData.GetInts();
var result = source.Query <int>("SELECT * FROM this WHERE value() > 3 AND TRUE");
var answer = source.Where(i => i > 3);
Assert.IsTrue(result.Any());
Assert.IsTrue(answer.SequenceEqual(result));
}
public void NestedExpressions()
{
IEnumerable <int> source = TestData.GetInts();
var result = source.Query <int>("SELECT * FROM this WHERE value() = ((6 / 2) + 1 - 2)");
var answer = source.Where(i => i == ((6 / 2) + 1 - 2));
Assert.IsTrue(result.Any());
Assert.IsTrue(answer.SequenceEqual(result));
}
public void WhereIntInValue()
{
IEnumerable <int> source = TestData.GetInts();
var result = source.Query <int>("SELECT * FROM this WHERE value() IN(2, 3)");
Assert.IsTrue(result.Any());
foreach (int i in result)
{
Assert.IsTrue(i == 2 || i == 3);
}
}
