public void TestOrderBy()
{
CreateDocument(1, 2, 3, 4, 5);
CreateDocument(6, 7, 8, 9, 10);
var aggregateModel = new AggregateModel();
aggregateModel.RegisterModel();
var model = nameof(AggregateModel);
var input = AggregateModel.CreateInput("numbers");
var prediction = Function.Prediction(model, input);
using (var q = QueryBuilder.Select(SelectResult.Expression(prediction.Property("sum")).As("sum"))
.From(DataSource.Database(Db))
.Where(prediction.Property("sum").GreaterThan(Expression.Int(1)))
.OrderBy(Ordering.Expression(prediction.Property("sum")).Descending())) {
var rows = VerifyQuery(q, (n, result) =>
{
var sum = result.GetInt(0);
sum.Should().Be(n == 1 ? 40 : 15);
});
rows.Should().Be(2);
}
}
