FCAT

Appearance

influxdb2.7.1 ​

参考:https://blog.csdn.net/weilanhai1997/article/details/132218079   
https://blog.csdn.net/Wis57/article/details/129386162 

username: admin  
password: Qwrt-123  
organization: fcat  
bucketName: public  

NYE3D8YhmpUbgoGnGhII5ObknSYnWmp4qHEtnx9whU8afC9Tre5m3gHD8Q19ememyrjxRoLBJKbiuE2IXqIr5Q==

表设计 ​

表名：sys_business_log   
tags: 索引的字段名  name  module_name level  
fields: 字段名  content  

name			名称：具体设备编码  
module_name		模块名称，业务日志来源不同的模块  
content			日志内容  
level			日志级别：0-debug，1-info，2-error  
time

添加数据 ​

菜单：Load Data   ->   Sources    ->   FileUpload  ->   Line Protocal   ->   ENTER MANUALLY  
sys_business_log,name="002230000616",module_name="hes",level="0" content="开始读基础参数" 1695286631434

数据查询 ​

菜单：Data Explorer  ->   Simple Table   QueryBUILDER    
新建查询：  

from(bucket:"public")  
 |> range(start: -36100d)  
 |> filter(fn: (r) => r._measurement == "sys_business_log")
from(bucket:"public")  
 |> range(start: -36100d)  
 |> filter(fn: (r) => r._measurement == "sys_business_log")

分配一个普通用户的权限 ​

菜单：Load Data   ->   API Tokens   ->   Custom API Token    ->   指定上面创建的bucketName: public   read 、write权限  
hcTydLFAVyFovjROM8uD2dSxhLuqEGaA5dKCd54OsOnMNVLWQ12Vwc27LI6mAJgibNEmFFP2ktGzIRnOrdiMow==

Sql语句 ​

相对时间，开始到现在 ​

from(bucket:"public")  
 |> range(start: -10m)  
 |> filter(fn: (r) => r._measurement == "sys_business_log" and r.name == "000008181004")
from(bucket:"public")  
 |> range(start: -10m)  
 |> filter(fn: (r) => r._measurement == "sys_business_log" and r.name == "000008181004")

相对时间，开始和结束 ​

from(bucket:"public")
|> range(start: -2d,stop:-23h)
|> filter(fn: (r) => r._measurement == "sys_business_log" and r.name == "000008181004")
from(bucket:"public")
|> range(start: -2d,stop:-23h)
|> filter(fn: (r) => r._measurement == "sys_business_log" and r.name == "000008181004")

绝对时间，开始和结束 ​

from(bucket:"public")
|> range(start: 2023-10-10T00:00:00Z, stop: 2023-11-10T00:00:00Z)
|> filter(fn: (r) => r._measurement == "sys_business_log" and r.name == "000008181004")
from(bucket:"public")
|> range(start: 2023-10-10T00:00:00Z, stop: 2023-11-10T00:00:00Z)
|> filter(fn: (r) => r._measurement == "sys_business_log" and r.name == "000008181004")