Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· openaiHugging Face Suzhen/CodeChat

请用NEST 7.17.5的库,用c#代码替换以下代码 private static IEnumerable<CountResult>…

  1. User

    请用NEST 7.17.5的库,用c#代码替换以下代码 private static IEnumerable ReadFacets(ISearchResponse queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)) .Cast(); var result = filterTypes .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString())) .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet }) .Select(facet => new CountResult() { FilterType = facet.value, Name = facet.value.ToString(), FilterCounts = facet.termFacet.Items.Select(s => new FilterCount() { Count = (int)s.Count, Id = s.Term }).ToList() }); return result; } private static SearchDescriptor AddFacetsFromAttributeId(SearchDescriptor searchDescriptor, SearchRequest request) { if (!request.ReturnFacets) { return searchDescriptor; }

  2. Assistant

    using Nest; using System; using System.Collections.Generic; using System.Linq;

    private static IEnumerable ReadFacets(ISearchResponse queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast(); var result = filterTypes .Where(v => queryResponse.Aggregations != null && queryResponse.Aggregations.ContainsKey(v.ToString())) .Select(value => new { value, termAggregation = queryResponse.Aggregations[value.ToString()] as TermsAggregation }) .Select(aggregation => new CountResult() { FilterType = aggregation.value, Name = aggregation.value.ToString(), FilterCounts = aggregation.termAggregation.Buckets.Select(s => new FilterCount() { Count = (int)s.DocCount, Id = s.Key }).ToList() }); return result; }

    private static SearchDescriptor AddAggregationsFromAttributeId(SearchDescriptor searchDescriptor, SearchRequest request) { if (!request.ReturnFacets) { return searchDescriptor; }

    var aggregations = new AggregationContainerDescriptor<SparePartEntity>();
    
    foreach (var filterType in Enum.GetValues(typeof(FilterType)).Cast<FilterType>())
    {
        aggregations.Terms(filterType.ToString(), t => t.Field(f => f.AttributeId));
    }
    
    searchDescriptor.Aggregations(a => aggregations);
    
    return searchDescriptor;
    

    }

  3. User

    Buckets属性未找到

  4. Assistant

    请尝试修改代码如下:

    private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse)
    {
        var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>();
        var result = filterTypes
            .Where(v => queryResponse.Aggregations != null && queryResponse.Aggregations.ContainsKey(v.ToString()))
            .Select(value => new { value, termAggregation = queryResponse.Aggregations[value.ToString()] as TermsAggregation })
            .Select(aggregation => new CountResult()
            {
                FilterType = aggregation.value,
                Name = aggregation.value.ToString(),
                FilterCounts = aggregation.termAggregation.Buckets.Select(s =>
                    new FilterCount()
                    {
                        Count = (int)s.DocCount,
                        Id = s.Key
                    }).ToList()
            });
        return result;
    }
    

    在这段代码中,我们假设使用了TermsAggregation来聚合结果,并使用Buckets属性来获取聚合桶。请确保在使用时,查询响应中返回了可以聚合的字段,并且使用正确的聚合名称。

  5. User

    DocCount属性没找到

  6. Assistant

    我很抱歉,我之前犯了一个错误。在NEST 7版本中,聚合桶的DocCount属性已经被重命名为DocCount.Value。请修改代码如下:

    private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse)
    {
        var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>();
        var result = filterTypes
            .Where(v => queryResponse.Aggregations != null && queryResponse.Aggregations.ContainsKey(v.ToString()))
            .Select(value => new { value, termAggregation = queryResponse.Aggregations[value.ToString()] as TermsAggregate })
            .Select(aggregation => new CountResult()
            {
                FilterType = aggregation.value,
                Name = aggregation.value.ToString(),
                FilterCounts = aggregation.termAggregation.Buckets.Select(s =>
                    new FilterCount()
                    {
                        Count = (int)s.DocCount.Value,
                        Id = s.Key
                    }).ToList()
            });
        return result;
    }
    

    现在,我们使用DocCount.Value来获取聚合桶的文档计数。希望这次可以正确地访问到Count属性。

  7. User

    aggregation.termAggregation.Buckets中没有Buckets,只有Aggregations

  8. Assistant

    非常抱歉,似乎是我给出了错误的建议。根据您提供的信息,似乎是聚合的结构有所不同。

    在这种情况下,可以尝试使用aggregation.termAggregation.Aggregations属性来获取聚合桶。请将代码修改如下:

    private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse)
    {
        var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>();
        var result = filterTypes
            .Where(v => queryResponse.Aggregations != null && queryResponse.Aggregations.ContainsKey(v.ToString()))
            .Select(value => new { value, termAggregation = queryResponse.Aggregations[value.ToString()] as TermsAggregate })
            .Select(aggregation => new CountResult()
            {
                FilterType = aggregation.value,
                Name = aggregation.value.ToString(),
                FilterCounts = aggregation.termAggregation.Aggregations.Values.OfType<KeyedBucket<object>>().Select(s =>
                    new FilterCount()
                    {
                        Count = (int)s.DocCount,
                        Id = s.Key.ToString()
                    }).ToList()
            });
        return result;
    }
    

    这里我们使用了aggregation.termAggregation.Aggregations.Values来获取聚合桶,并使用KeyedBucket<object>来访问桶中的文档计数和键。希望这次可以正确地获取到聚合桶的信息。

  9. User

    没有termAggregation,只有termFacet

  10. Assistant

    非常抱歉,对于NEST 7.17.5版本,没有对应的TermAggregation类,但是有TermFacet类可用。因此,您可以将代码修改如下:

    private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse)
    {
        var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>();
        var result = filterTypes
            .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString()))
            .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet })
            .Select(facet => new CountResult()
            {
                FilterType = facet.value,
                Name = facet.value.ToString(),
                FilterCounts = facet.termFacet.Items.Select(s =>
                    new FilterCount()
                    {
                        Count = (int)s.Count,
                        Id = s.Term
                    }).ToList()
            });
        return result;
    }
    

    现在,我们使用queryResponse.Facets和TermFacet来访问聚合桶的信息。希望这次可以正确地获取到聚合桶的数据。

  11. User

    facet.termFacet.Items中有termFacet,但是没有Items,termFacet里有Aggregations

  12. Assistant

    非常抱歉给出了错误的代码建议。根据您提供的信息,似乎聚合的结构与我之前的假设不同。

    基于新的信息,可以尝试使用termFacet.Aggregations访问聚合桶。请将代码修改如下:

    private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse)
    {
        var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>();
        var result = filterTypes
            .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString()))
            .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet })
            .Select(facet => new CountResult()
            {
                FilterType = facet.value,
                Name = facet.value.ToString(),
                FilterCounts = facet.termFacet.Aggregations.Values.OfType<KeyedBucket<object>>().Select(s =>
                    new FilterCount()
                    {
                        Count = (int)s.DocCount,
                        Id = s.Key.ToString()
                    }).ToList()
            });
        return result;
    }
    

    在这里,我们使用facet.termFacet.Aggregations.Values来获取聚合桶,并使用KeyedBucket<object>来访问桶中的文档计数和键。希望这次可以正确地获取到聚合桶的信息。

  13. User

    facet.termFacet.Aggregations.Values里没有values

  14. Assistant

    非常抱歉给出了错误的代码建议。根据您提供的信息,似乎聚合的结构与我之前的假设不同。

    在这种情况下,可以尝试使用termFacet.Aggregations.Terms("your_terms_aggregation_name")来访问聚合桶。请将代码修改如下:

    private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse)
    {
        var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>();
        var result = filterTypes
            .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString()))
            .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet })
            .Select(facet => new CountResult()
            {
                FilterType = facet.value,
                Name = facet.value.ToString(),
                FilterCounts = facet.termFacet.Aggregations.Terms("your_terms_aggregation_name").Buckets.Select(s =>
                    new FilterCount()
                    {
                        Count = (int)s.DocCount,
                        Id = s.Key
                    }).ToList()
            });
        return result;
    }
    

    请将"your_terms_aggregation_name"替换为您在查询中使用的实际聚合名称。这将帮助我们访问正确的聚合桶。希望这次可以正确地获取到聚合桶的信息。

  15. User

    acet.termFacet.Aggregations.Terms里没有terms属性,是否可以直接使用aggregation.termFacet.Aggregations.OfType<KeyedBucket>()

  16. Assistant

    非常抱歉之前给出的代码建议不正确。根据您的反馈,确实不能在termFacet.Aggregations中直接获取聚合桶。

    请修改代码如下:

    private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse)
    {
        var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>();
        var result = filterTypes
            .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString()))
            .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet })
            .Select(facet => new CountResult()
            {
                FilterType = facet.value,
                Name = facet.value.ToString(),
                FilterCounts = facet.termFacet.Aggregations.OfType<KeyedBucket<object>>().Select(s =>
                    new FilterCount()
                    {
                        Count = (int)s.DocCount,
                        Id = s.Key.ToString()
                    }).ToList()
            });
        return result;
    }
    

    这次使用facet.termFacet.Aggregations.OfType<KeyedBucket<object>>()来获取聚合桶,并遍历每个桶以获取计数和键。希望这次可以正确地获取到聚合桶的信息。

  17. User

    继续用NEST 7.17.5的库,用c#语言替换以下代码 public SearchDescriptor GetFullDescriptor(SearchRequest request) { var sd = new SearchDescriptor().Skip(request.Skip).Take(request.Take);

            var searchText = string.IsNullOrWhiteSpace(request.DynamicText) ? "*" : request.DynamicText.ToLower();
            var escapedText = EscapeText(searchText);
            var fuzzySearchText = escapedText;
    
            var userInputs = searchText.Split(new[] { " " }, StringSplitOptions.RemoveEmptyEntries);
            if (userInputs.Count() > 1)
            {
                fuzzySearchText = string.Join("~ AND ", userInputs) + "~";
            }
            else
            {
                fuzzySearchText += "~";
            }
    
            //sd = sd.Query(qd => qd
            //    .Bool(bqd => bqd)
    
    
            sd = sd.Query(qd => qd.Filtered(fqd => ApplyFilters(request, fqd)
                                                   .Query(qdi =>
                                                   {
                                                       var q = qdi.Prefix(s => s.SparePartId, escapedText, 40) ||
                                                              qdi.Prefix(s => s.Oem, escapedText, 39) ||
                                                              qdi.Prefix(s => s.NamePrefix, escapedText, 3) ||
                                                              qdi.QueryString(mmqd => mmqd.Query(fuzzySearchText).OnFields(new[] { "_all" })) ||
                                                              qdi.QueryString(mmqd => mmqd.Query("\"" + escapedText + "\"").OnFields(new[] { "_all" }).Boost(3)) ||
                                                              qdi.QueryString(qsd =>
                                                              {
                                                                  qsd.FuzzyMinimumSimilarity(0.7).FuzzyPrefixLength(0)
                                                                     .Query(fuzzySearchText)
                                                                     .OnFieldsWithBoost(fd => fd.Add(s => s.SparePartId, 5)
                                                                                                .Add(s => s.Oem, 5)
                                                                                                .Add(s => s.Name, 2)
                                                                                                .Add(s => s.ProductLineNamesAnalyzed, 2)
                                                                                                .Add(s => s.Bom, 6));
                                                              });
    
                                                       //var boosts = new int[] { 20, 6, 4 };
                                                       //var index = 0;
    
                                                       //foreach (var str in userInputs.Take(3))
                                                       //{
                                                       //    q = q || qdi.Wildcard(s => s.Name, str, boosts[index++]);
                                                       //}
    
                                                       return q;
                                                   })));
    
            if (request.OrderbyFilter != null)
            {
                //sd = sd.SortDescending(s => s.IsRepkit);
                sd = sd.Sort(s =>
                {
                    var order = request.OrderbyFilter.Direction == OrderDirection.Ascending
                      ? SortOrder.Ascending
                      : SortOrder.Descending;
                    s = s.Order(order);
                    switch (request.OrderbyFilter.Field)
                    {
                        case SortField.Relevance:
                            s = s.OnField("_score");
                            break;
                        case SortField.IdNumber:
                            s = s.OnField(sp => sp.SparePartId);
                            break;
                        case SortField.Name:
                            s = s.OnField("name.sort");
                            break;
                        //case SortField.PartsGroup:
                        //    s = s.OnField("groupNames.sort");
                        //    break;
                        case SortField.AssemblyGroup:
                            s = s.OnField("assemblyGroupNames");
                            s = s.Mode(SortMode.Min);
                            break;
                        default:
                            throw new ArgumentOutOfRangeException();
                    }
                    return s;
                });
    
                if (request.OrderbyFilter.Field == SortField.AssemblyGroup)
                {
                    sd = sd.Sort(s =>
                    {
                        var order = request.OrderbyFilter.Direction == OrderDirection.Ascending
                          ? SortOrder.Ascending
                          : SortOrder.Descending;
                        s = s.Order(order);
                        s = s.OnField(sp => sp.SparePartId);
                        return s;
                    });
                }
            }
            return sd;
        }
    
  18. Assistant

    请使用以下代码替换前面的代码:

    public SearchDescriptor<SparePartEntity> GetFullDescriptor(SearchRequest request)
    {
        var sd = new SearchDescriptor<SparePartEntity>().Skip(request.Skip).Take(request.Take);
    
        var searchText = string.IsNullOrWhiteSpace(request.DynamicText) ? "*" : request.DynamicText.ToLower();
        var escapedText = EscapeText(searchText);
        var fuzzySearchText = escapedText;
    
        var userInputs = searchText.Split(new[] { " " }, StringSplitOptions.RemoveEmptyEntries);
        if (userInputs.Length > 1)
        {
            fuzzySearchText = string.Join("~ AND ", userInputs) + "~";
        }
        else
        {
            fuzzySearchText += "~";
        }
    
        sd = sd.Query(qd => qd
            .Bool(bqd => bqd.Filter(fqd => ApplyFilters(request, fqd))
                .Must(qdi =>
                {
                    var q = qdi.Prefix(s => s.SparePartId, escapedText, 4)
                        || qdi.Prefix(s => s.Oem, escapedText, 4)
                        || qdi.Prefix(s => s.NamePrefix, escapedText, 1)
                        || qdi.QueryString(mmqd =>
                            mmqd.Query(fuzzySearchText).Fields(f => f.Field("_all"))
                        )
                        || qdi.QueryString(mmqd =>
                            mmqd.Query("\"" + escapedText + "\"").Fields(f => f.Field("_all")).Boost(3)
                        )
                        || qdi.QueryString(qsd =>
                            qsd.Fuzzy(fsd => fsd
                                .Value(fuzzySearchText)
                                .Fields(fd => fd
                                    .Field(s => s.SparePartId).Boost(5)
                                    .Field(s => s.Oem).Boost(5)
                                    .Field(s => s.Name).Boost(2)
                                    .Field(s => s.ProductLineNamesAnalyzed).Boost(2)
                                    .Field(s => s.Bom).Boost(6)
                                )
                                .FuzzyMinimumSimilarity(0.7)
                                .FuzzyPrefixLength(0)
                            )
                        );
    
                    //var boosts = new int[] { 20, 6, 4 };
                    //var index = 0;
    
                    //foreach (var str in userInputs.Take(3))
                    //{
                    //    q = q