【influxdb】python操作类（无账号密码验证，可自行添加header认证）

import requests

from config import influxDB

host = influxDB["host"]
username = influxDB["username"]
password = influxDB["password"]
database = influxDB["database"]


def query(sql):
    """
    influxdb查询
    :param sql:
    sql = "CREATE DATAbase mydb"
    sql = "select * from test"
    :return:
    """
    url = influxDB["host"] + "/query?db={0}&q={1}".format(database, sql)
    result = requests.get(url).json()
    return result


def insert(sql):
    """

    :param sql:
    string sql = "test,name=测试,count=1 value=10"
    插入表test   索引name   列count,value
    :return:
    """
    # 设置请求头为文本
    headers = {'Content-Type': 'text/plain'}
    url = influxDB["host"] + "/write?db={0}&precision=s".format(database)
    result = requests.post(url, data=sql.encode('utf-8'), headers=headers).text
    return result

# influxDB
influxDB = {
    "host": "http://127.0.0.1:8086",
    "database": "mydb",
    "username": "",
    "password": "",
}

from app.influxDB import influxDBClient

if __name__ == "__main__":
    ret = influxDBClient.query("CREATE DATAbase mydb")
    print(ret)

    ret = influxDBClient.insert("test,name=1,count=1 value=10")
    print(ret)

    ret = influxDBClient.query("select * from test")
    print(ret)