Add architect model rule to warn about nested aggregations

tvavrda · May 3, 2021, 1:49pm

This runtime error should be handled by model rules in Architect so the user knows about this problem after opening the model.

tvavrda · May 11, 2021, 6:22am

The logic of the rule can be derived from here:

github.com

origam/origam-source/blob/e2c1f3b5bdf02c62798daf044c56340f1363922f/Origam.DA.Service/Generators/AbstractSqlCommandGenerator.cs#L3077


aggregationVirtualEntity.ParentItem = topLevelEntity.RootItem;
aggregationVirtualEntity.Name = "aggregation" + level;


if (agg2 != null)
{
    // allow nested 
    //   sum(sum()) / avg(avg()) /  min(min()) / max(max())
    //   It will mean e.g. avg(table join second_table)
    //   sum(count()) - will mean count(table join second_table)
    //   count(count()) is not allowed
    if (agg2.AggregationType != item.AggregationType
        && ! (agg2.AggregationType ==  AggregationType.Count 
              && item.AggregationType == AggregationType.Sum)
        )
    {
        throw new ArgumentOutOfRangeException("AggregationType", 
            agg2.AggregationType, 
            "Nested aggregations must be of the same type. Path: " 
            + agg2.Path);
    }
    if (agg2.AggregationType == AggregationType.Count

jsusen · May 19, 2021, 1:55pm

tvavrda · August 13, 2021, 12:22pm

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.