python处理mysql数据至Elastaticsearch
一、创建python文件mysqlToElastaticsearch.py
1、vim mysqlToElastaticsearch.py
import pymysql
from elasticsearch6 import Elasticsearch
es = Elasticsearch([{"host":"127.0.0.1","port":"9200"}])
conn=pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='root',db='bigDataTest')
cursor=conn.cursor(cursor=pymysql.cursors.DictCursor)
row_affected=cursor.execute("select * from DATACENTER")
all=cursor.fetchall()
id=0
for one in all:
print(one["enname"]