.net core elasticsearch 动态构建bool查询以及constent score查询

日常的生产中我们不可避免的会涉及到动态构建es的查询条件的场景,本文将展开这方面的demo
https://stackoverflow.com/questions/64902916/dynamic-elastic-search-query-in-c-sharp-nest

https://www.elastic.co/guide/en/elasticsearch/client/net-api/7.17/constant-score-query-usage.html

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Nest;
using Elasticsearch.Net;
using EsHelper.Model;

namespace EsHelper
{
    public class EsTool
    {
        public ElasticClient _elasticClient { get; set; }

        public EsTool()
        {
            var pool = new SingleNodeConnectionPool(new Uri("http://192.168.214.131:9200"));
            var setting = new ConnectionSettings(pool).BasicAuthentication("elastic","ellischen");
            _elasticClient = new ElasticClient(setting);
        }


        public QueryContainer[] dynamicMust()
        {
            QueryContainer orQuery = null;
            List<QueryContainer> queryContainerList = new List<QueryContainer>();


            //orQuery = new TermQuery() { Field = "title" ,Value= "Android in Action, Second Edition" };
            //queryContainerList.Add(orQuery);


            orQuery = new LongRangeQuery() { Field = "pageCount", GreaterThanOrEqualTo = 2 };
            queryContainerList.Add(orQuery);

            return queryContainerList.ToArray();
        }

        public QueryContainer[] dynamicShould()
        {
            QueryContainer orQuery = null;
            List<QueryContainer> queryContainerList = new List<QueryContainer>();

            orQuery = new TermQuery() { Field = "title.keyword" ,Value= "Android in Action, Second Edition" };
            queryContainerList.Add(orQuery);

            orQuery = new PrefixQuery() { Field = "title", Value = "S" };
            queryContainerList.Add(orQuery);

            return queryContainerList.ToArray();
        }

        public  QueryContainer BookShould()
        {
            return new QueryContainerDescriptor<Books>().Bool(
                b => b.Should(
                    dynamicShould()));
        }

        public QueryContainer BookMust()
        {
            return new QueryContainerDescriptor<Books>().Bool(
                b => b.Must(
                    dynamicMust()));
        }



        public void test()
        {
            var searchRequest = new SearchRequest<Books>("books")
            {
                Query = new BoolQuery()
                {
                    Must = dynamicMust(),
                    Should = dynamicShould(),
                    MinimumShouldMatch = 1

                },
                Size=10000
            };
            var vv = _elasticClient.Search<Books>(searchRequest);
        }

        public void testConstantScoreQuery()
        {
            var searchRequest = new SearchRequest<Books>("books")
            {
                Query = new ConstantScoreQuery()
                {
                    Filter = new BoolQuery()
                    {
                        Must = dynamicMust(),
                        Should = dynamicShould(),
                        MinimumShouldMatch = 1

                    }
                },
                Size = 10000
            };
            var vv = _elasticClient.Search<Books>(searchRequest);
        }

    }
}


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值