public List <BuildResultEntity> GetBuildResults(DateTimeOffset startDate, string viewName) { var filter = FilterUtil.SinceDate(ColumnNames.PartitionKey, startDate); filter = FilterView(filter, viewName); var query = new TableQuery <BuildResultEntity>().Where(filter); return(_buildResultDateTable.ExecuteQuery(query).ToList()); }
public FilterUtil Or(FilterUtil other) { var filter = TableQuery.CombineFilters( _filter, TableOperators.Or, other.Filter); return(new FilterUtil(filter)); }
public static FilterUtil Combine(FilterUtil left, CombineOperator op, FilterUtil right) { var filter = TableQuery.CombineFilters( left.Filter, ToTableOperator(op), right.Filter); return(new FilterUtil(filter)); }
public List <string> GetViewNames(DateTimeOffset startDate) { var query = new TableQuery <ViewNameEntity>().Where(FilterUtil.SinceDate(ColumnNames.PartitionKey, startDate)); var viewNameList = _viewNameDateTable.ExecuteQuery(query); var list = new List <string>(); list.Add(AzureUtil.ViewNameAll); list.AddRange(viewNameList.Select(x => x.ViewName).Distinct()); return(list); }
public List <BuildFailureEntity> GetTestCaseFailures(DateTimeOffset startDate, string name, string viewName) { var filter = FilterUtil .SinceDate(ColumnNames.PartitionKey, startDate) .And(FilterUtil.Column(nameof(BuildFailureEntity.Identifier), name)); filter = FilterView(filter, viewName); var query = new TableQuery <BuildFailureEntity>().Where(filter); return(_buildFailureDateTable.ExecuteQuery(query).ToList()); }
public List <BuildResultEntity> GetBuildResultsByKindName(DateTimeOffset startDate, string kindName, string viewName) { var filter = FilterUtil .SinceDate(ColumnNames.PartitionKey, startDate) .And(FilterUtil.Column(nameof(BuildResultEntity.ClassificationName), kindName)); filter = FilterView(filter, viewName); var query = new TableQuery <BuildResultEntity>().Where(filter); return(_buildResultDateTable.ExecuteQuery(query).ToList()); }
private static FilterUtil FilterView(FilterUtil util, string viewName) { Debug.Assert(nameof(BuildResultEntity.ViewName) == nameof(BuildFailureEntity.ViewName)); if (viewName == AzureUtil.ViewNameAll) { return(util); } var other = FilterUtil.Column(nameof(BuildResultEntity.ViewName), viewName, ColumnOperator.Equal); return(util.And(other)); }
/// <summary> /// Query counter entities between the specified dates (inclusive) /// </summary> public static TableQuery <T> CreateTableQuery <T>(DateTimeOffset startDate, DateTimeOffset endDate) where T : CounterEntity, new() { var startDateKey = new DateKey(startDate); var endDateKey = new DateKey(endDate); var filter = FilterUtil .Combine( FilterUtil.BetweenDateKeys(ColumnNames.PartitionKey, startDateKey, endDateKey), CombineOperator.And, FilterUtil.Combine( FilterUtil.Column(nameof(CounterEntity.DateTimeUtcTicks), startDate.UtcTicks, ColumnOperator.GreaterThanOrEqual), CombineOperator.And, FilterUtil.Column(nameof(CounterEntity.DateTimeUtcTicks), endDate.UtcTicks, ColumnOperator.LessThanOrEqual))); return(new TableQuery <T>().Where(filter.Filter)); }
/// <summary> /// Query async for a single entity value matching the specified key /// </summary> public static async Task <T> QueryAsync <T>( CloudTable table, EntityKey key, CancellationToken cancellationToken = default(CancellationToken)) where T : ITableEntity, new() { var filter = FilterUtil.Key(key); var query = new TableQuery <T>().Where(filter); var segment = await table.ExecuteQuerySegmentedAsync(query, null, cancellationToken); if (segment.Results.Count == 0) { return(default(T)); } return(segment.Results[0]); }
public static TableQuery <T> Where <T>(this TableQuery <T> query, FilterUtil filter) { return(query.Where(filter.Filter)); }
public static FilterUtil Key(EntityKey key) { return(FilterUtil .PartitionKey(key.PartitionKey) .And(FilterUtil.RowKey(key.RowKey))); }