public async Task <List <RoachMilestone> > GetMilestones(RoachRepoId repoId, RoachItemFilter filter = RoachItemFilter.All, CancellationToken cancellationToken = default(CancellationToken)) { var util = FilterUtil.PartitionKey(RoachMilestoneEntity.GetPartitionKey(repoId)); switch (filter) { case RoachItemFilter.All: // Nothing to do: break; case RoachItemFilter.Closed: util = util.And(FilterUtil.Column(nameof(RoachMilestoneEntity.IsOpen), false)); break; case RoachItemFilter.Open: util = util.And(FilterUtil.Column(nameof(RoachMilestoneEntity.IsOpen), true)); break; default: throw new Exception($"Bad enum value {filter}"); } var list = await AzureUtil.QueryAsync <RoachMilestoneEntity>( _milestoneTable, util, cancellationToken); return(list.Select(x => x.Milestone).OrderBy(x => x.Title).ToList()); }
/// <summary> /// Get all issues in the specified label which don't have an assignee and / or a milestone. /// </summary> public async Task <List <RoachIssue> > GetTriageIssues(RoachRepoId repoId, string label, CancellationToken cancellationToken) { var unassignedFilter = TableQuery.CombineFilters( TableQuery.GenerateFilterCondition(nameof(TableEntity.PartitionKey), QueryComparisons.Equal, EntityKeyUtil.ToKey(repoId)), TableOperators.And, TableQuery.GenerateFilterCondition(nameof(RoachIssueEntity.Assignee), QueryComparisons.Equal, TheBugsConstants.UnassignedName)); var unassignedList = await AzureUtil.QueryAsync(_issueTable, new TableQuery <RoachIssueEntity>().Where(unassignedFilter), cancellationToken); var unknownMilestoneFilter = TableQuery.CombineFilters( TableQuery.GenerateFilterCondition(nameof(TableEntity.PartitionKey), QueryComparisons.Equal, EntityKeyUtil.ToKey(repoId)), TableOperators.And, TableQuery.GenerateFilterConditionForInt(nameof(RoachIssueEntity.MilestoneNumber), QueryComparisons.Equal, RoachMilestoneId.NoneNumber)); var unknownMilestoneList = await AzureUtil.QueryAsync(_issueTable, new TableQuery <RoachIssueEntity>().Where(unknownMilestoneFilter), cancellationToken); var list = new List <RoachIssue>(); var hashSet = new HashSet <int>(); foreach (var entity in unassignedList.Concat(unknownMilestoneList)) { if (hashSet.Add(entity.Number) && entity.Labels.Contains(label) && entity.IssueType == IssueType.Issue) { list.Add(entity.Issue); } } return(list); }
private async Task <List <RoachIssueEntity> > GetIssuesInMilestone(RoachRepoId repoId, int milestone, CancellationToken cancellationToken) { var filter = FilterUtil .PartitionKey(RoachIssueEntity.GetPartitionKey(repoId)) .And(FilterUtil.Column(nameof(RoachIssueEntity.MilestoneNumber), milestone)); return(await AzureUtil.QueryAsync <RoachIssueEntity>(_issueTable, filter, cancellationToken)); }
private async Task <List <RoachIssueEntity> > GetIssuesInMilestones(RoachRepoId repoId, List <int> milestones, CancellationToken cancellationToken) { if (milestones == null || milestones.Count == 0) { // Return all of the issues return(await AzureUtil.QueryAsync <RoachIssueEntity>(_issueTable, FilterUtil.PartitionKey(RoachIssueEntity.GetPartitionKey(repoId)), cancellationToken)); } var list = new List <RoachIssueEntity>(); foreach (var milestone in milestones) { list.AddRange(await GetIssuesInMilestone(repoId, milestone, cancellationToken)); } return(list); }