Linux安装TDengine

//下载
wget https://www.tdengine.com/assets-download/3.0/TDengine-server-3.0.4.1-Linux-x64.rpm
//安装
sudo rpm -ivh TDengine-server-3.0.4.1-Linux-x64.rpm
//卸载
//rpm -e tdengine 并且删除相应数据文件 rm -rf /var/lib/taos


//启动
systemctl start taosd
//查看状态
systemctl status taosd
//设置开机自启
systemctl enable taosd
//开启REST API对应服务,默认端口为 6041
systemctl start taosadapter


//查看是否启动
netstat -tunlp | grep '6030'

//进入命令行
taos

//设置root密码
alter user root pass '123456';
taos -u root -p123456


//执行相应sql
CREATE DATABASE demo;
USE demo;
CREATE TABLE t (ts TIMESTAMP, speed INT);
INSERT INTO t VALUES ('2019-07-15 00:00:00', 10);
INSERT INTO t VALUES ('2019-07-15 01:00:00', 20);
SELECT * FROM t;

# -*- coding: utf-8 -*-
# @Time    : 2023/5/10 16:37
# @Author  : Cocktail_py
import taos
conn = taos.connect(host="localhost",port=6030,user="root",password="123456",database="demo")
print('clinet info:',conn.client_info)
print('server info:',conn.client_info)
conn.close()



from taosrest import RestClient
client = RestClient("http://127.0.0.1:6041", user="root", password="123456")
res: dict = client.sql("SELECT * FROM demo.t LIMIT 1")
print(res)


# 通过result api 发送数据
# https://github.com/flytrap/vnpy_tdengine/blob/main/vnpy_tdengine/tdengine_database.py
url = f"http://{self.user}:{self.password}@{self.host}:{self.port}/rest/sql/{self.database}"
resp = requests.post(url, data=sql.encode("utf8"))

# -*- coding: utf-8 -*-
# @Time    : 2023/5/12 12:17
# @Author  : Cocktail_py
import time
import taos


def batch():
    """
    批量写入
    CREATE STABLE cost(ts TIMESTAMP, qty BIGINT, p BINARY(512)) TAGS(gId BIGINT, sId INT);
    """
    conn = taos.connect(host="localhost",
                        port=6030,
                        user="root",
                        password="taosdata",
                        database="cost")
    timestamp = int(time.time() * 1000)
    lines = [
        ["s" + "1", timestamp, 6, "p1", 1, 11],
        ["s" + "2", timestamp, 6, "p1", 2, 11],
        ["s" + "3", timestamp, 6, "p1", 3, 3],
        ["s" + "4", timestamp, 6, "p1", 4, 6],

    ]
    stmt = conn.statement("INSERT INTO ? USING cost TAGS(?, ?) VALUES(?, ?, ?)")
    table_tags = {} # 标签
    table_values = {} # 值
    for data in lines:
        table_tags[data[0]] = (data[-2], data[-1])
        table_values[data[0]] = [[], [],[]]
    for data in lines:
        table_values[data[0]][0].append(data[1])
        table_values[data[0]][1].append(data[2])
        table_values[data[0]][2].append(data[3])
    for tb_name in table_values.keys():
        tags = table_tags[tb_name]
        tag_params = taos.new_bind_params(2)
        tag_params[0].bigint(tags[0])
        tag_params[1].int(tags[1])
        stmt.set_tbname_tags(tb_name, tag_params)
        values = table_values[tb_name]
        value_params = taos.new_multi_binds(3)
        value_params[0].timestamp(values[0])
        value_params[1].bigint(values[1])
        value_params[2].binary(values[2])
        stmt.bind_param_batch(value_params)
    stmt.execute()
    conn.close()

# 参考:https://docs.taosdata.com/develop/insert-data/sql-writing/

参考:
英文文档
中文文档