mysql数据写入influxdb

from influxdb import InfluxDBClient  # 引入influxdb包
import pymysql  # 引入mysql包
import datetime

db = pymysql.connect(host="localhost", user="root", password="123456", db="gdjt_data1", port=3306)  # 连接mysql
cur = db.cursor()  # 获取游标
sql = "select *  from gj_shield_record"
cur.execute(sql)  # 执行sql
assert isinstance(cur, object)
results = cur.fetchall()  # 获取所有数据

host = '172.16.101.137'
port = 8086
user = 'root'
password = 'tydt123456'
dbname = 'tydt-cim'
# influxdb 数据连接
n = 0
start = datetime.datetime.now()
conn_db = InfluxDBClient(host, port, user, password, dbname)  # 连接influxdb
for row in results:  # 循环插入数据
    id = row[0]
    shieldid = row[1]
    uptime = row[2]
    timestamp = row[3]
    updatetime = row[4]
    content = row[5]
    n+=1
    end = datetime.datetime.now()
    print("条数：&#