python elasticsearch update by query

会飞的尼古拉斯

已于 2023-08-02 10:18:24 修改

阅读量1.2k

点赞数 1

分类专栏： elasticsearch Python 文章标签： python elasticsearch

于 2023-08-02 10:15:24 首次发布

本文链接：https://blog.csdn.net/weixin_43632687/article/details/132055812

版权

Python 同时被 2 个专栏收录

127 篇文章 6 订阅

订阅专栏

elasticsearch

38 篇文章 1 订阅

订阅专栏

创建索引以及添加数据

PUT test
{
  "mappings": {
    "properties": {
      "test":{
        "type": "nested"
    }
  }
}}


GET test/_mapping


PUT test/_doc/1
{
  "test":{"name":"ellis","age":100}
}

elasticsearch包

from elasticsearch import Elasticsearch
conn = Elasticsearch(hosts=['192.168.214.133'],port=31200,http_auth="elastic:ellischen")

update_by_query = {
  "query": {
    "nested": {
      "path": "test",
      "query": {
        "term": {
          "test.name": {
            "value": "ellis"
          }
        }
      }
    }
  },
  "script": {
    "source": "ctx._source['test']['age']+=1",
    "params": {"age":101}, 
    "lang": "painless"
  }
}


conn.update_by_query(index='test',body=update_by_query)

elasticsearch-dsl包

from elasticsearch_dsl import connections
from elasticsearch_dsl import Search
from elasticsearch_dsl import Q as esQ
from elasticsearch_dsl import UpdateByQuery
conn = connections.create_connection(hosts=['192.168.214.133'],port=31200,http_auth="elastic:ellischen")
source = "ctx._source['test']['age']=params.age"
params = {"age":110}
query_body=esQ('nested',**{"path":'test',"query":esQ('term',**{"test.name":{"value":"ellis"}})})
update_by_query = UpdateByQuery().using(conn).index('test').query(query_body).script(source=source,params=params)

update_by_query.execute()

from_dict 方法

from elasticsearch_dsl import connections
from elasticsearch_dsl import Search
from elasticsearch_dsl import Q as esQ
from elasticsearch_dsl import UpdateByQuery
conn = connections.create_connection(hosts=['192.168.214.133'],port=31200,http_auth="elastic:ellischen")
# source = "ctx._source['test']['age']=params.age"
# params = {"age":110}
# query_body=esQ('nested',**{"path":'test',"query":esQ('term',**{"test.name":{"value":"ellis"}})})
# update_by_query = UpdateByQuery().using(conn).index('test').query(query_body).script(source=source,params=params)

# update_by_query.execute()

update_by_query = {
  "query": {
    "nested": {
      "path": "test",
      "query": {
        "term": {
          "test.name": {
            "value": "ellis"
          }
        }
      }
    }
  },
  "script": {
    "source": "ctx._source['test']['age']+=1",
    "params": {"age":101}, 
    "lang": "painless"
  }
}
search = UpdateByQuery().from_dict(update_by_query).using(conn).index('test')
search.execute()