TDengine测试总结

最新推荐文章于 2024-08-08 08:31:09 发布

勇气201

最新推荐文章于 2024-08-08 08:31:09 发布

阅读量1.2k

点赞数

分类专栏： TDengine

本文链接：https://blog.csdn.net/yongqi_zhang/article/details/115390236

版权

TDengine 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文介绍了如何通过RESTful接口与TDengine数据库进行交互，包括使用HTTP请求发送SQL命令进行数据插入，以及使用node-red的httprequest节点实现自动化数据写入。示例代码详细展示了连接、认证及构建SQL语句的过程。

摘要由CSDN通过智能技术生成

安装

docker安装

按照官方文档即可。开放相关端口。

debian安装

按照官方文档即可。下载deb安装包，然后执行安装，启动服务。

客户端

taos.studio 不知道怎么连接
TDengineGUI使用RESTful很容易连接
端口6041
用户名root
密码taosdata

连接

RESTful连接

杰控组态软件，使用http功能编写脚本，定时插入数据
表的结构为 ts timestamp,seconds int

retCode1=HttpObj.ConnectToHttpServer("11.41.230.239",6041,"/rest/sql",1,3000,0,0)
If retCode1=0 Then
retCode2=HttpObj.SendHttpRequestHeader("Authorization: Basic cm9vdDp0YW9zZGF0YQ==")
RunSys.SendDebugInfo retCode2
x=RunSys.GetVarValue(VA,"%SECOND-COUNT",-1)
ts=CurrentTime.GetFormatTime("%Y-%m-%d %H:%M:%S")

strBody="insert into demo.fm values('" & ts & "'," & x & ")"

retCode3=HttpObj.SendHttpRequestBody(strBody)

End If

HttpObj.CloseHttpConnect

使用node-red的http request节点
设置url
11.41.230.239:6041/rest/sql
使用基本认证：用户名root 密码 taosdata
然后在function里面使用insert语句
wendu_YT为全局变量
时间必须加引号’'才行
时间要转换为中国的时间

var temp=global.get("wendu_YT").toFixed(2);

var dt=msg.payload; 

msg.payload="INSERT INTO yangtai.yangtai VALUES('" + dt + "'," + temp +")";

 return msg;

完整的流程如下
在这里插入图片描述

[{"id":"1d1618b4.ca9e87","type":"tab","label":"TDengine","disabled":false,"info":""},{"id":"996bb4d3.826af8","type":"moment","z":"1d1618b4.ca9e87","name":"","topic":"","input":"","inputType":"msg","inTz":"Asia/Shanghai","adjAmount":0,"adjType":"days","adjDir":"add","format":"YYYY-MM-DD HH:mm:ss","locale":"zh","output":"","outputType":"msg","outTz":"Asia/Shanghai","x":320,"y":140,"wires":[["b0f99320.62003"]]},{"id":"c279c573.747358","type":"inject","z":"1d1618b4.ca9e87","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"10","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":100,"y":140,"wires":[["996bb4d3.826af8"]]},{"id":"b0f99320.62003","type":"function","z":"1d1618b4.ca9e87","name":"准备sql语句","func":"var temp=global.get(\"wendu_YT\").toFixed(2);\n\nvar dt=msg.payload; \n\nmsg.payload=\"INSERT INTO yangtai.yangtai VALUES('\" + dt + \"',\" + temp +\")\";\n\n return msg;\n\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":550,"y":120,"wires":[["3a7d8e3.4bc7d72"]]},{"id":"3a7d8e3.4bc7d72","type":"http request","z":"1d1618b4.ca9e87","name":"","method":"POST","ret":"txt","paytoqs":"ignore","url":"121.41.230.239:6041/rest/sql","tls":"","persist":false,"proxy":"","authType":"basic","x":740,"y":140,"wires":[[]]}]