public ICriteria SetProjection(IProjection projection)
{
if (projection is ProjectionList)
{
throw new NotSupportedException("Projection lists are not (yet) supported.");
}
var distinct = projection as Distinct;
if (distinct != null)
{
ApplyActionToShards(c => c.SetProjection(projection));
this.listExitOperationBuilder.Distinct = true;
return(this);
}
if (!projection.IsAggregate)
{
ApplyActionToShards(c => c.SetProjection(projection));
return(this);
}
string aggregationName = projection.ToString();
if (aggregationName.StartsWith("avg", StringComparison.OrdinalIgnoreCase))
{
var projectionList = Projections.ProjectionList()
.Add(projection)
.Add(Projections.RowCount());
ApplyActionToShards(c => c.SetProjection(projectionList));
this.listExitOperationBuilder.Aggregation =
c => AggregationUtil.Average(c, GetDoubleFieldSelector(0), GetInt32FieldSelector(1));
return(this);
}
if (aggregationName.StartsWith("sum", StringComparison.OrdinalIgnoreCase))
{
ApplyActionToShards(c => c.SetProjection(projection));
this.listExitOperationBuilder.Aggregation = ToSumFunc(projection);
return(this);
}
if (aggregationName.StartsWith("count", StringComparison.OrdinalIgnoreCase))
{
ApplyActionToShards(c => c.SetProjection(projection));
this.listExitOperationBuilder.Aggregation = ToSumFunc(projection);
return(this);
}
if (aggregationName.StartsWith("min", StringComparison.OrdinalIgnoreCase))
{
ApplyActionToShards(c => c.SetProjection(projection));
this.listExitOperationBuilder.Aggregation = AggregationUtil.Min;
return(this);
}
if (aggregationName.StartsWith("max", StringComparison.OrdinalIgnoreCase))
{
ApplyActionToShards(c => c.SetProjection(projection));
this.listExitOperationBuilder.Aggregation = AggregationUtil.Max;
return(this);
}
var message = string.Format(
CultureInfo.InvariantCulture,
"Aggregate projection '{0}' is currently not supported across shards.",
aggregationName);
Log.Error(message);
throw new NotSupportedException(message);
}
private bool CanCopy(IASTNode node, out Action <IASTNode> copyTransformer)
{
copyTransformer = null;
IASTNode child;
switch (node.Type)
{
case HqlSqlWalker.SKIP:
child = node.GetFirstChild();
if (TryGetParameterName(child, out var skipParameterName))
{
this.exitOperationBuilder.FirstResult = (int)namedParameters[skipParameterName].Item1;
}
else if (TryGetInt32(child, out var firstResult))
{
this.exitOperationBuilder.FirstResult = firstResult;
}
return(false);
case HqlSqlWalker.TAKE:
child = node.GetFirstChild();
if (TryGetParameterName(child, out var takeParameterName))
{
this.exitOperationBuilder.MaxResults = (int)namedParameters[takeParameterName].Item1;
}
else if (TryGetInt32(child, out var maxResults))
{
this.exitOperationBuilder.MaxResults = maxResults;
}
return(false);
case HqlSqlWalker.ORDER:
ExtractOrders(node);
return(true);
case HqlSqlWalker.AGGREGATE:
if ("avg".Equals(node.Text, StringComparison.OrdinalIgnoreCase))
{
goto case HqlSqlWalker.AVG;
}
if ("min".Equals(node.Text, StringComparison.OrdinalIgnoreCase))
{
goto case HqlSqlWalker.MIN;
}
else if ("max".Equals(node.Text, StringComparison.OrdinalIgnoreCase))
{
goto case HqlSqlWalker.MAX;
}
throw new NotSupportedException(string.Format(
CultureInfo.InvariantCulture,
"HQL aggregate function '{0}' is currently not supported across shards.",
node.Text));
case HqlSqlWalker.AVG:
ThrowIfAggregationInComplexSelectList(node);
this.exitOperationBuilder.Aggregation = c => AggregationUtil.Average(c, GetFieldSelector(0), GetFieldSelector(1));
copyTransformer = TransformUnshardedAverageNode;
return(true);
case HqlSqlWalker.COUNT:
ThrowIfAggregationInComplexSelectList(node);
this.exitOperationBuilder.Aggregation = c => AggregationUtil.SumInt64(c, o => o);
return(true);
case HqlSqlWalker.MIN:
ThrowIfAggregationInComplexSelectList(node);
this.exitOperationBuilder.Aggregation = c => AggregationUtil.Min(c, o => o);
return(true);
case HqlSqlWalker.MAX:
ThrowIfAggregationInComplexSelectList(node);
this.exitOperationBuilder.Aggregation = c => AggregationUtil.Max(c, o => o);
return(true);
case HqlSqlWalker.SUM:
ThrowIfAggregationInComplexSelectList(node);
this.exitOperationBuilder.Aggregation = c => AggregationUtil.Sum(c, o => o);
return(true);
}
return(true);
}
private static AggregationFunc ToSumFunc(IProjection projection)
{
var aggregationResultClass = projection.GetTypes(null, null)[0].ReturnedClass;
return(AggregationUtil.GetSumFunc(aggregationResultClass));
}
public void TestSum()
{
VerifyAggregateListExitOperation(AggregationUtil.GetSumFunc(typeof(int)), data, new object[] { 11 }, "Sum");
}
