python

超轻量级php框架startmvc

Python 操作 ElasticSearch的完整代码

更新时间:2020-07-20 17:12:01 作者:startmvc
官方文档:https://elasticsearch-py.readthedocs.io/en/master/  1、介绍    python提供了操作Elasti

官方文档:https://elasticsearch-py.readthedocs.io/en/master/

  1、介绍

    python提供了操作ElasticSearch 接口,因此要用python来操作ElasticSearch,首先要安装python的ElasticSearch包,用命令pip install elasticsearch安装或下载安装:https://pypi.python.org/pypi/elasticsearch/5.4.0

  2、创建索引

    假如创建索引名称为ott,类型为ott_type的索引,该索引中有五个字段:

    title:存储中文标题,

    date:存储日期格式(2017-09-08),

    keyword:存储中文关键字,

    source:存储中文来源,

    link:存储链接,

    创建映射:

    

    

3、索引数据

    

    批量索引

    利用bulk批量索引数据

    

  4、查询索引

     

5、删除数据

    

  6、完整代码


#coding:utf8
import os
import time
from os import walk
import CSVOP
from datetime import datetime
from elasticsearch import Elasticsearch
from elasticsearch.helpers import bulk
class ElasticObj:
 def __init__(self, index_name,index_type,ip ="127.0.0.1"):
 '''
 :param index_name: 索引名称
 :param index_type: 索引类型
 '''
 self.index_name =index_name
 self.index_type = index_type
 # 无用户名密码状态
 #self.es = Elasticsearch([ip])
 #用户名密码状态
 self.es = Elasticsearch([ip],http_auth=('elastic', 'password'),port=9200)
 def create_index(self,index_name="ott",index_type="ott_type"):
 '''
 创建索引,创建索引名称为ott,类型为ott_type的索引
 :param ex: Elasticsearch对象
 :return:
 '''
 #创建映射
 _index_mappings = {
 "mappings": {
 self.index_type: {
 "properties": {
 "title": {
 "type": "text",
 "index": True,
 "analyzer": "ik_max_word",
 "search_analyzer": "ik_max_word"
 },
 "date": {
 "type": "text",
 "index": True
 },
 "keyword": {
 "type": "string",
 "index": "not_analyzed"
 },
 "source": {
 "type": "string",
 "index": "not_analyzed"
 },
 "link": {
 "type": "string",
 "index": "not_analyzed"
 }
 }
 }
 }
 }
 if self.es.indices.exists(index=self.index_name) is not True:
 res = self.es.indices.create(index=self.index_name, body=_index_mappings)
 print res
 def IndexData(self):
 es = Elasticsearch()
 csvdir = 'D:/work/ElasticSearch/exportExcels'
 filenamelist = []
 for (dirpath, dirnames, filenames) in walk(csvdir):
 filenamelist.extend(filenames)
 break
 total = 0
 for file in filenamelist:
 csvfile = csvdir + '/' + file
 self.Index_Data_FromCSV(csvfile,es)
 total += 1
 print total
 time.sleep(10)
 def Index_Data_FromCSV(self,csvfile):
 '''
 从CSV文件中读取数据,并存储到es中
 :param csvfile: csv文件,包括完整路径
 :return:
 '''
 list = CSVOP.ReadCSV(csvfile)
 index = 0
 doc = {}
 for item in list:
 if index > 1:#第一行是标题
 doc['title'] = item[0]
 doc['link'] = item[1]
 doc['date'] = item[2]
 doc['source'] = item[3]
 doc['keyword'] = item[4]
 res = self.es.index(index=self.index_name, doc_type=self.index_type, body=doc)
 print(res['created'])
 index += 1
 print index
 def Index_Data(self):
 '''
 数据存储到es
 :return:
 '''
 list = [
 { "date": "2017-09-13",
 "source": "慧聪网",
 "link": "http://info.broadcast.hc360.com/2017/09/130859749974.shtml",
 "keyword": "电视",
 "title": "付费 电视 行业面临的转型和挑战"
 },
 { "date": "2017-09-13",
 "source": "中国文明网",
 "link": "http://www.wenming.cn/xj_pd/yw/201709/t20170913_4421323.shtml",
 "keyword": "电视",
 "title": "电视 专题片《巡视利剑》广获好评:铁腕反腐凝聚党心民心"
 }
 ]
 for item in list:
 res = self.es.index(index=self.index_name, doc_type=self.index_type, body=item)
 print(res['created'])
 def bulk_Index_Data(self):
 '''
 用bulk将批量数据存储到es
 :return:
 '''
 list = [
 {"date": "2017-09-13",
 "source": "慧聪网",
 "link": "http://info.broadcast.hc360.com/2017/09/130859749974.shtml",
 "keyword": "电视",
 "title": "付费 电视 行业面临的转型和挑战"
 },
 {"date": "2017-09-13",
 "source": "中国文明网",
 "link": "http://www.wenming.cn/xj_pd/yw/201709/t20170913_4421323.shtml",
 "keyword": "电视",
 "title": "电视 专题片《巡视利剑》广获好评:铁腕反腐凝聚党心民心"
 },
 {"date": "2017-09-13",
 "source": "人民电视",
 "link": "http://tv.people.com.cn/BIG5/n1/2017/0913/c67816-29533981.html",
 "keyword": "电视",
 "title": "中国第21批赴刚果(金)维和部隊启程--人民 电视 --人民网"
 },
 {"date": "2017-09-13",
 "source": "站长之家",
 "link": "http://www.chinaz.com/news/2017/0913/804263.shtml",
 "keyword": "电视",
 "title": "电视 盒子 哪个牌子好? 吐血奉献三大选购秘笈"
 }
 ]
 ACTIONS = []
 i = 1
 for line in list:
 action = {
 "_index": self.index_name,
 "_type": self.index_type,
 "_id": i, #_id 也可以默认生成,不赋值
 "_source": {
 "date": line['date'],
 "source": line['source'].decode('utf8'),
 "link": line['link'],
 "keyword": line['keyword'].decode('utf8'),
 "title": line['title'].decode('utf8')}
 }
 i += 1
 ACTIONS.append(action)
 # 批量处理
 success, _ = bulk(self.es, ACTIONS, index=self.index_name, raise_on_error=True)
 print('Performed %d actions' % success)
 def Delete_Index_Data(self,id):
 '''
 删除索引中的一条
 :param id:
 :return:
 '''
 res = self.es.delete(index=self.index_name, doc_type=self.index_type, id=id)
 print res
 def Get_Data_Id(self,id):
 res = self.es.get(index=self.index_name, doc_type=self.index_type,id=id)
 print(res['_source'])
 print '------------------------------------------------------------------'
 #
 # # 输出查询到的结果
 for hit in res['hits']['hits']:
 # print hit['_source']
 print hit['_source']['date'],hit['_source']['source'],hit['_source']['link'],hit['_source']['keyword'],hit['_source']['title']
 def Get_Data_By_Body(self):
 # doc = {'query': {'match_all': {}}}
 doc = {
 "query": {
 "match": {
 "keyword": "电视"
 }
 }
 }
 _searched = self.es.search(index=self.index_name, doc_type=self.index_type, body=doc)
 for hit in _searched['hits']['hits']:
 # print hit['_source']
 print hit['_source']['date'], hit['_source']['source'], hit['_source']['link'], hit['_source']['keyword'], \
 hit['_source']['title']

obj =ElasticObj("ott","ott_type",ip ="47.93.117.127")
# obj = ElasticObj("ott1", "ott_type1")
# obj.create_index()
obj.Index_Data()
# obj.bulk_Index_Data()
# obj.IndexData()
# obj.Delete_Index_Data(1)
# csvfile = 'D:/work/ElasticSearch/exportExcels/2017-08-31_info.csv'
# obj.Index_Data_FromCSV(csvfile)
# obj.GetData(es)

总结

以上所述是小编给大家介绍的Python 操作 ElasticSearch的完整代码,希望对大家有所帮助,如果大家有任何疑问欢迎给我留言,小编会及时回复大家的!

Python 操作 ElasticSearch