public TimeBoundaryRequestData(string dataSource, string bound, IFilterSpec filter, IContextSpec context)
{
DataSource = dataSource;
Bound = bound;
Filter = filter;
Context = context;
}
private static IGroupByQueryDescriptor ConfigureAggregationSpec(
IGroupByQueryDescriptor aggregation,
TimeSlot timeslot,
IFilterSpec filter,
IReadOnlyList <string> dimensions)
{
if (filter != null)
{
aggregation = aggregation.Filter(filter);
}
if (dimensions.Any())
{
aggregation = aggregation.Dimensions(dimensions);
}
return(aggregation
.DataSource(BigBankCube.DataSource)
.Granularity(Granularities.All)
.Interval(timeslot.Start, timeslot.End)
.Aggregations(
new DoubleSumAggregator(BigBankCube.Metrics.Price, BigBankCube.Metrics.Price),
new LongSumAggregator(BigBankCube.Metrics.Count, BigBankCube.Metrics.Count))
.PostAggregations(new ArithmeticPostAggregator(
BigBankCube.Metrics.AveragePrice,
ArithmeticFunction.Divide,
fields: new IPostAggregationSpec[]
{
new FieldAccessPostAggregator(BigBankCube.Metrics.Price, BigBankCube.Metrics.Price),
new FieldAccessPostAggregator(BigBankCube.Metrics.Count, BigBankCube.Metrics.Count)
})));
}
public ExpressionLinqSpec(
IFilterSpec <TParam, TEntity> filterSpec
)
{
_filterSpec = filterSpec;
_sortingSpec = null;
}
public ScanRequestData(string dataSource, IList <string> intervals, IFilterSpec filter, IContextSpec context, IEnumerable <string> columns, string resultFormat, int?limit, int?batchSize)
{
DataSource = dataSource;
Intervals = intervals;
Filter = filter;
Context = context;
Columns = columns;
Limit = limit;
ResultFormat = resultFormat;
BatchSize = batchSize;
}
public TimeseriesRequestData(string dataSource, bool descending, object granularity, IList <string> intervals, IFilterSpec filter, IEnumerable <IAggregationSpec> aggregations, IEnumerable <IPostAggregationSpec> postAggregations, TimeseriesContextSpec context)
{
DataSource = dataSource;
Descending = descending;
Granularity = granularity;
Intervals = intervals;
Filter = filter;
Aggregations = aggregations;
PostAggregations = postAggregations;
Context = context;
}
public SearchRequestData(string dataSource, object granularity, IList <string> intervals, IFilterSpec filter, SearchContextSpec context, IEnumerable <string> searchDimensions, int limit, ISearchQuerySpec query, SortSpec sort)
{
DataSource = dataSource;
Granularity = granularity;
Intervals = intervals;
Filter = filter;
Context = context;
SearchDimensions = searchDimensions;
Limit = limit;
Query = query;
Sort = sort;
}
public SelectRequestData(string dataSource, object granularity, IList <string> intervals, IFilterSpec filter, IContextSpec context, IEnumerable <string> dimensions, IEnumerable <string> metrics, PagingSpec pagingSpec, bool descending)
{
DataSource = dataSource;
Granularity = granularity;
Intervals = intervals;
Filter = filter;
Context = context;
Dimensions = dimensions;
Metrics = metrics;
PagingSpec = pagingSpec;
Descending = descending;
}
public GroupByRequestData(object dataSource, object granularity, IList <string> intervals, IFilterSpec filter, GroupByContextSpec context, IEnumerable <IDimensionSpec> dimensions, IEnumerable <IAggregationSpec> aggregations, IEnumerable <IPostAggregationSpec> postAggregations, ILimitSpec limitSpec, IHavingSpec havingSpec)
{
DataSource = dataSource;
Granularity = granularity;
Intervals = intervals;
Filter = filter;
Context = context;
Dimensions = dimensions;
Aggregations = aggregations;
PostAggregations = postAggregations;
LimitSpec = limitSpec;
HavingSpec = havingSpec;
}
public TopNRequestData(string dataSource, IDimensionSpec dimension, ITopNMetricSpec metric, object granularity, long threshold, IList <string> intervals, IFilterSpec filter, IEnumerable <IAggregationSpec> aggregations, IEnumerable <IPostAggregationSpec> postAggregations, TopNContextSpec context)
{
DataSource = dataSource;
Dimension = dimension;
Metric = metric;
Granularity = granularity;
Threshold = threshold;
Intervals = intervals;
Filter = filter;
Aggregations = aggregations;
PostAggregations = postAggregations;
Context = context;
}
public ScanRequestData(string dataSource, IEnumerable <ExpressionVirtualColumn> virtualColumns, IList <string> intervals, IFilterSpec filter, IContextSpec context,
IEnumerable <string> columns, string resultFormat, int?limit, int?offset, OrderByDirection?order, int?batchSize)
{
DataSource = dataSource;
VirtualColumns = virtualColumns;
Intervals = intervals;
Filter = filter;
Context = context;
Columns = columns;
Limit = limit;
Offset = offset;
Order = order;
ResultFormat = resultFormat;
BatchSize = batchSize;
}
public ITimeBoundaryQueryDescriptor Filter(IFilterSpec filterSpec)
{
FilterValue = filterSpec;
return(this);
}
public QueryFilterHavingSpec(IFilterSpec filter)
{
Filter = filter;
}
public ITimeseriesQueryDescriptor Filter(IFilterSpec filterSpec)
{
FilterValue = filterSpec;
return(this);
}
public IGroupByQueryDescriptor Filter(IFilterSpec filterSpec)
{
FilterValue = filterSpec;
return(this);
}
public FilteredAggregator(IFilterSpec filter, IAggregationSpec aggregator)
{
Filter = filter;
Aggregator = aggregator;
}
public NotFilter(IFilterSpec filter)
{
Field = filter;
}
public ISelectQueryDescriptor Filter(IFilterSpec filterSpec)
{
FilterValue = filterSpec;
return(this);
}
public static ILinqSpec <TParam, TEntity> Filter <TParam>(IFilterSpec <TParam, TEntity> filterSpec)
where TParam : IQriteria
=> new ExpressionLinqSpec <TEntity, TParam>(filterSpec);
public SpecLinqQuery(IFilterSpec <TParam, TEntity> filterSpec, ILinqRequestHandler handler, ILinqConvertor <TResponse> linqConvertor)
: this(LinqSpec <TEntity> .Filter(filterSpec), handler, linqConvertor)
{
}
