3 Star 1 Fork 0

shao1chuan / windplc_1

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
indb_readme.txt 1.32 KB
一键复制 编辑 原始数据 按行查看 历史
shaoshao 提交于 2024-01-15 21:22 . shao
influxdb删除数据:
influx delete -org windb --bucket plc \
--start 1970-01-01T00:00:00Z \
--stop 2050-01-01T00:00:00Z \
--predicate '_measurement="opcua"' \
--host http://localhost:8086 \
--token 3v3lz9sRWqAzo4zm7w4ujCNRAlsgdPDp8INbgwey6iPOymP9J0hnD02Wb8dznadWMzOwjpkVJ8TfAR9yrnTPEw==
localhost: 3v3lz9sRWqAzo4zm7w4ujCNRAlsgdPDp8INbgwey6iPOymP9J0hnD02Wb8dznadWMzOwjpkVJ8TfAR9yrnTPEw==
plc:VsqErgEYQU_V6L_96TP9wthZVBqpROLkNyqJhxiMA8Rhw8TLX3ArKiZnPLNGmREJ4nsE1CoDekK0DFGRFyE4Ig==
查询数据过去一天:
from(bucket: "plc") |> range(start: -1d) |> filter(fn: (r) => r["_measurement"] == "opcua") |> filter(fn: (r) => r["_field"] == "WindSpeed" or r["_field"] == "ActivePower" or r["_field"] == "WindDirection" or r["_field"] == "DataEffectiveFlag")
查询数据过去一小时:
from(bucket: "plc") |> range(start: -1h) |> filter(fn: (r) => r["_measurement"] == "opcua") |> filter(fn: (r) => r["_field"] == "WindSpeed" or r["_field"] == "ActivePower" or r["_field"] == "WindDirection" or r["_field"] == "DataEffectiveFlag")
from(bucket: "plc")
|> range(start: -365d)
|> sort(desc: true)
|> filter(fn: (r) => r._measurement == "opcua")
|> filter(fn: (r) => exists r._value)
|> filter(fn: (r) => r._value == r._value)
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
Python
1
https://gitee.com/shao1chuan/windplc_1.git
git@gitee.com:shao1chuan/windplc_1.git
shao1chuan
windplc_1
windplc_1
master

搜索帮助