influxdb數據導出筆記

influx query ‘from(bucket: “byt-grid-data”)
|> range(start: 2025-04-01T00:00:00Z, stop: 2025-04-02T23:59:59Z)
|> filter(fn: ? => r[“_measurement”] == “byt-gzsn-hsxn-sc-dcs”)
|> filter(fn: ? => r[“_field”] == “F_ACT_FZZ02_FB_O”)
|> filter(fn: ? => r[“host”] == “host1”)
|> toFile(file: “/tmp/restored_data.csv”)’

influx query ‘from(bucket: “byt-grid-data”)
|> range(start: 2025-04-01T00:00:00Z, stop: 2025-04-01T00:59:59Z)
|> filter(fn: ? => r[“_measurement”] == “byt-gzsn-hsxn-sc-dcs”)
|> filter(fn: ? => r[“_field”] == “F_ACT_FZZ02_FB_O”)
|> filter(fn: ? => r[“host”] == “host1”)’ > /tmp/t001.csv

查詢InfluxDB并返回帶注釋的CSV

influx query ‘from(bucket: “byt-grid-data”)
|> range(start: 2025-04-10T00:00:00Z, stop: 2025-04-11T01:00:00Z)
|> filter(fn: ? => r[“_measurement”] == “byt-gzsn-hsxn-sc-dcs”)
|> filter(fn: ? => r[“_field”] == “F_ACT_FZZ02_FB_O”)
|> filter(fn: ? => r[“host”] == “host1”)
|> timeShift(duration: 8h)’ --raw > /tmp/t002.csv

influx query ‘from(bucket: “byt-grid-data”)
|> range(start: 2025-04-10T00:00:00+08:00, stop: 2025-04-11T00:00:00+08:00)
|> filter(fn: ? => r[“_measurement”] == “byt-gzsn-hsxn-sc-dcs”)
|> filter(fn: ? => r[“_field”] == “F_ACT_FZZ02_FB_O”)
|> filter(fn: ? => r[“host”] == “host1”)
|> timeShift(duration: 8h)’ --raw > /tmp/t002.csv

登陸ftp

lftp -u hl,Admin@123 -p 63036 122.224.62.130

執行腳本

2024.10.16 2025.4.8

sh /root/bin/export_influx.sh F_ACT_FZZ02_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G7MAC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G8MG_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_1K2AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G10MAC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_2K1AC_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G12AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G13AC_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh AIAO_G35M1_PV_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ01_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ02_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FDLD01_FG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ01_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_2K2AC_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G12AC_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ08_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh AIAO_G35M2_PV_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_2K1AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FDLD01_FG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F4AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G7MAC_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G40AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G38AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G13AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G11AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_2K2AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F41AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ08_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F5AC_SDG_FB_O 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_1K2AC_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G11AC_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F41AC_SDG_SP_IN 2024-10-16 2025-04-09 /opt/influx_export/hsxn

2025.1.22 2025.4.8

sh /root/bin/export_influx.sh Current_G30M_CUN_U 2025-01-22 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F46AC_SDG_SP_IN 2025-01-22 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F46AC_SDG_FB_O 2025-01-22 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G8MG_SDG_FB_O 2025-01-22 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT04_U 2025-01-22 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G7MAC_CUN_U 2025-01-22 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G6MAC_SDG_SP_IN 2025-01-22 2025-04-09 /opt/influx_export/hsxn

2025-01-21 2025-03-02

sh /root/bin/export_influx.sh TT_GTT05_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh TT_GTT06_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC2_WY6_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_2K3A12_FG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC1_WY7_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F51M_SDG_FB_O 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT09_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC2_WY8_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_Others_FTT28B_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC1_WY2_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F52M_SDG_FB_O 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_2K4A12_FG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC2_WY3_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC1_WY4_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F52M_SDG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh AIAO_G35AC1_M2_P_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT11_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G17AC_SDG_FB_O 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh AIAO_G35AC2_M2_P_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_G18AC_PS1_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh AIAO_G35AC1_M1_P_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh AIAO_G35AC2_M3_P_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G15AC_SDG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh G45GP_G45GP_CUR5_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G35AC_SDG_FB_O 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh G45GP_G45GP_CUR4_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC1_WY9_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT24_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh AIAO_G35AC1_M3_P_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC2_WY1_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT10_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G14AC_SDG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_1K3A12_FG_FB_O 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G18AC_SOG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC2_9BP_PV_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh TT_GTT02_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_1K3A12_FG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_T_FTT02a_T_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC2_WY5_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC2_WY7_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_Others_FTT28A_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC1_WY1_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh G45GP_G45GP_CUR1_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT21_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC1_WY6_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_G17AC_PS1_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G14AC_SDG_FB_O 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh G45GP_G45GP_CUR6_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G17AC_SDG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G18AC_SOG_FB_O 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC2_WY4_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh TT_GTT03_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_F51M_SDG_SP_IN 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh BLJ_BC1_P_PV3_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh MILL_MOTOR_G17AC_CUN_1_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Current_G14AC_CUN_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Current_G13AC_CUN_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT29_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh MILL_MOTOR_G18AC_CUN_1_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Current_G16AC_CUN_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT31_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Current_G15AC_CUN_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT23_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT27_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT22_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT26_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT25_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT28_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Current_G12AC_CUN_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT30_U 2025-01-21 2025-03-02 /opt/influx_export/hsxn

2025-01-21 2025-04-09

sh /root/bin/export_influx.sh TT_GTT01_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh TT_GTT04_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G9MG_SDF_FB_O 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_2SPZZ01_SP_IN 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G35AC_SDG_SP_IN 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_T_FTT06_T_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_Pressure_FPT16_P_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_1K3A12_FG_EXT_EN 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_GZZ04_SP_IN 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G38AC_SDG_SP_IN 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Pressure_GPT01_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G6MAC_CUN_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G6MAC_SDG_FB_O 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G9MG_SDF_SP_IN 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_2K3A12_FG_FB_O 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_2SPZZ01_FB_O 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh ACT_G35AC_SDG_UNIT 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_ACT_2K4A12_FG_EXT_EN 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh Current_G11AC_CUN_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ04_SP_IN 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ03_FB_O 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ04_FB_O 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G10MAC_CUN_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh K_G_ACT_G9MG_CUN_U 2025-01-21 2025-04-09 /opt/influx_export/hsxn
sh /root/bin/export_influx.sh F_ACT_FZZ03_SP_IN 2025-01-21 2025-04-09 /opt/influx_export/hsxn

惠水西南邊緣端

核心腳本

/root/bin/export_influx.sh

#!/bin/bash# 使用方法: ./export_influx.sh <標簽名稱> <開始日期> <結束日期> <輸出目錄>
# 示例: ./export_influx.sh F_ACT_FZZ02_FB_O 2025-04-01 2025-04-03 ./outputif [ $# -ne 4 ]; thenecho "錯誤：參數數量不正確！"echo "用法: $0 <標簽名稱> <開始日期> <結束日期> <輸出目錄>"exit 1
fiTAG="$1"
START_DATE="$2"
END_DATE="$3"
OUTPUT_DIR="$4"# 創建輸出目錄
OUTPUT_DIR="$OUTPUT_DIR"/"$TAG"
mkdir -p "$OUTPUT_DIR"# 日期格式校驗
date -d "$START_DATE" +%Y-%m-%d >/dev/null 2>&1 || { echo "無效的開始日期格式"; exit 1; }
date -d "$END_DATE" +%Y-%m-%d >/dev/null 2>&1 || { echo "無效的結束日期格式"; exit 1; }# 將日期轉換為秒數（用于循環）
START_SEC=$(date -d "$START_DATE" +%s)
END_SEC=$(date -d "$END_DATE" +%s)if [ $START_SEC -gt $END_SEC ]; thenecho "錯誤：開始日期不能晚于結束日期！"exit 1
fi# 記錄開始時間
start_time_p=$(date +%s)
echo "開始時間: $(date -d @"$start_time_p" '+%Y-%m-%d %H:%M:%S')"# 按天循環處理
current_sec=$START_SEC
while [ $current_sec -lt $END_SEC ]; do# 獲取當前循環日期CURRENT_DATE=$(date -d @$current_sec +%Y-%m-%d)# 增加一天current_sec=$((current_sec + 86400))STOP_DATE=$(date -d @$current_sec +%Y-%m-%d)# 生成時間范圍（當日00:00:00到次日00:00:00）START_TIME="${CURRENT_DATE}T00:00:00+08:00"STOP_TIME="${STOP_DATE}T00:00:00+08:00"# 生成輸出文件名OUTPUT_FILE="${OUTPUT_DIR}/${CURRENT_DATE}.csv"echo "正在導出 ${CURRENT_DATE} 的數據到 ${OUTPUT_FILE}..."# 執行查詢命令influx query "from(bucket: \"byt-grid-data\")|> range(start: $START_TIME, stop: $STOP_TIME)|> filter(fn: (r) => r[\"_measurement\"] == \"byt-gzsn-hsxn-sc-dcs\")|> filter(fn: (r) => r[\"_field\"] == \"$TAG\")|> filter(fn: (r) => r[\"host\"] == \"host1\")|> timeShift(duration: 8h)" --raw > "$OUTPUT_FILE"# 檢查文件是否為空if [ ! -s "$OUTPUT_FILE" ]; thenecho "警告：${CURRENT_DATE} 無數據，刪除空文件"rm -f "$OUTPUT_FILE"fidoneecho "導出完成！"# 記錄結束時間
end_time_p=$(date +%s)# 計算耗時
elapsed_time=$((end_time_p - start_time_p))# 格式化耗時
days=$((elapsed_time / 60 / 60 / 24))
hours=$((elapsed_time / 60 / 60 % 24))
minutes=$((elapsed_time / 60 % 60))
seconds=$((elapsed_time % 60))# 打印耗時
echo "開始時間: $(date -d @"$start_time_p" '+%Y-%m-%d %H:%M:%S')"
echo "結束時間: $(date -d @"$end_time_p" '+%Y-%m-%d %H:%M:%S')"
printf "耗時: %02dd%02dh%02dm%02ds\n" $days $hours $minutes $seconds

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/pingmian/76228.shtml
繁體地址，請注明出處：http://hk.pswp.cn/pingmian/76228.shtml
英文地址，請注明出處：http://en.pswp.cn/pingmian/76228.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

HTTP Content-Type：深入解析與應用

HTTP Content-Type：深入解析與應用

HTTP Content-Type：深入解析與應用 引言 在互聯網世界中，數據傳輸是至關重要的。而HTTP協議作為最常用的網絡協議之一，其在數據傳輸過程中扮演著關鍵角色。其中，HTTP Content-Type頭字段在數據傳輸中發揮著至關重要的作用。本文將深入解析HTTP Content-Type，并探討其在實…
閱讀更多...
使用SQL查詢ES數據

使用SQL查詢ES數據

使用SQL查詢ES數據 32 進階&#xff1a;使用SQL查詢ES數據環境準備利用腳本導入測試數據 SQL學習基本查詢排序查詢過濾查詢范圍查詢分組查詢(group)分組過濾查詢(grouphaving)聚合函數統計limit查詢分頁查詢 32 進階&#xff1a;使用SQL查詢ES數據 環境準備 需要首先安裝ES8.…
閱讀更多...
禁止頁面滾動的方法-微信小程序

禁止頁面滾動的方法-微信小程序

在微信小程序中&#xff0c;有幾種方法可以禁止頁面滾動&#xff1a; 一、通過頁面配置禁止滾動 在頁面的JSON配置文件中設置&#xff0c;此方法完全禁止頁面的滾動行為&#xff1a; {"disableScroll": true }二、通過 CSS 樣式禁止滾動 在頁面的WXSS文件中添加&…
閱讀更多...
用戶畫像（https://github.com/memodb-io/memobase）應用

用戶畫像（https://github.com/memodb-io/memobase）應用

1.下載項目的源代碼，我們要先啟動后端，用docker啟動 cd src/server cp .env.example .env cp ./api/config.yaml.example ./api/config.yaml 這里我的配置內容如下config.yaml(因為我是調用的符合openai格式的大模型，所以我沒改，如果要是別的大模型的話，需要自己再做兼容…
閱讀更多...
微信小程序生成某個具體頁面的二維碼

微信小程序生成某個具體頁面的二維碼

微信小程序&#xff0c;如果要生成某個具體頁面&#xff0c;而非首頁的二維碼&#xff0c;體驗和正式的生成方法如下&#xff1a; 1、體驗版二維碼&#xff1a; 管理---版本管理---修改頁面路徑&#xff0c;輸入具體頁面的路徑以及參數&#xff0c;生成的是二維碼 2、正式小程…
閱讀更多...
【今日三題】小樂樂改數字 (模擬) / 十字爆破 (預處理+模擬) / 比那名居的桃子 (滑窗 / 前綴和)

【今日三題】小樂樂改數字 (模擬) / 十字爆破 (預處理+模擬) / 比那名居的桃子 (滑窗 / 前綴和)

??個人主頁&#xff1a;小羊 ??所屬專欄&#xff1a;每日兩三題 很榮幸您能閱讀我的文章&#xff0c;誠請評論指點&#xff0c;歡迎歡迎 ~ 目錄 小樂樂改數字 (模擬)十字爆破 (預處理模擬&#xff09;比那名居的桃子 (滑窗 / 前綴和) 小樂樂改數字 (模擬) 小樂樂改數字…
閱讀更多...
四旋翼無人機手動模式

四旋翼無人機手動模式

無人機的手動模式&#xff08;Manual Mode&#xff09;是指飛手完全通過遙控器手動控制無人機的飛行姿態、高度、方向和速度&#xff0c;?無需依賴自動穩定系統或輔助功能?&#xff08;如GPS定位、氣壓計定高、視覺避障等&#xff09;。這種模式賦予操作者最大的操控自由度&a…
閱讀更多...
C++高精度算法（加、減、乘）

C++高精度算法（加、減、乘）

首先聲明&#xff0c;沒有除法是因為我不會&#xff08;手動狗頭_doge&#xff09; 簡介 顧名思義&#xff0c;高精度算法是用來算一些超級大的數&#xff0c;比如長到 longlong 都存不下的那種&#xff0c;還有就是小數點后好多位&#xff0c;double都存不下的那種&#xff…
閱讀更多...
思科交換機配置

思科交換機配置

以下是交換機配置的詳細步驟指南&#xff0c;適用于Cisco交換機&#xff0c;其他品牌需調整命令&#xff1a; 1. 初始連接與基本配置 連接方式&#xff1a;使用Console線連接交換機&#xff0c;通過終端軟件&#xff08;如PuTTY&#xff09;登錄。波特率&#xff1a;9600&…
閱讀更多...
數據質量問題中，數據及時性怎么保證？如何有深度體系化回答！

數據質量問題中，數據及時性怎么保證？如何有深度體系化回答！

數據治理&#xff0c;數據質量這快是中大廠&#xff0c;高階大數據開發面試必備技能&#xff0c;企業基于大數據底座去做數倉&#xff0c;那么首先需要保障的就是數據質量。 數據質量的重要性在現代企業中變得越發突出。以下是數據質量的幾個關鍵方面&#xff0c;說明其對企業…
閱讀更多...
【學習筆記】CPU 的“超線程”是什么？

【學習筆記】CPU 的“超線程”是什么？

1. 什么是超線程&#xff1f; 超線程&#xff08;Hyper-Threading&#xff09;是Intel的技術&#xff0c;讓一個物理CPU核心模擬出兩個邏輯核心。 效果&#xff1a;4核CPU在系統中顯示為8線程。 本質&#xff1a;通過復用空閑的硬件單元&#xff08;如ALU、FPU&#xff09;&a…
閱讀更多...
閉包的理解

閉包的理解

一、閉包的概念 當通過調用外部函數返回的內部函數后&#xff0c;即使外部函數已經執行結束了&#xff0c;但是被內部函數引用的外部函數的變量依然會保存在內存中&#xff0c;我們把引用了其他函數作用域變量的函數和這些被引用變量的集合&#xff0c;稱為閉包&#xff08;Clo…
閱讀更多...
從小米汽車事故反思 LabVIEW 開發

從小米汽車事故反思 LabVIEW 開發

近期&#xff0c;小米汽車的一起嚴重事故引發了社會各界的廣泛關注。這起事故不僅讓我們對智能汽車的安全性產生了深深的思考&#xff0c;也為 LabVIEW 開發領域帶來了諸多值得汲取的知識與領悟。 在智能汽車領域&#xff0c;尤其是涉及到智能駕駛輔助系統時&#xff0c;安全是…
閱讀更多...
項目進度延誤的十大原因及應對方案

項目進度延誤的十大原因及應對方案

項目進度延誤主要源于以下十大原因&#xff1a;目標不明確、需求頻繁變更、資源配置不足或不合理、溝通不暢、風險管理不足、缺乏有效的項目監控、技術難題未及時解決、團隊協作效率低下、決策鏈過長、外部因素影響。其中&#xff0c;需求頻繁變更是導致延誤的關鍵因素之一&…
閱讀更多...
AI 賦能 DBA：如何用 DeepSeek 等大模型簡化數據庫管理工作

AI 賦能 DBA：如何用 DeepSeek 等大模型簡化數據庫管理工作

AI 賦能 DBA：如何用 DeepSeek 等大模型簡化數據庫管理工作 摘要： 數據庫管理員（DBA）的工作涉及 SQL 優化、故障排查、性能監控等復雜任務。而 DeepSeek、ChatGPT 等大模型可以大幅減少重復勞動，提高 DBA 的工作效率。本文將結合真實案例，介紹如何利用 AI 優化 DBA 工作流…
閱讀更多...
vxe-table4.6 + vue3.2 + ant-design-vue 3.x 實現對列的顯示、隱藏、排序

vxe-table4.6 + vue3.2 + ant-design-vue 3.x 實現對列的顯示、隱藏、排序

概要 vxe-table中的vxe-toolbar沒有拖拽功能&#xff0c;故自己實現 源碼 <template><a-popover v-model:visible"open" placement"bottomRight" trigger"click"><template #content><div class"content">…
閱讀更多...
c++基礎知識二

c++基礎知識二

1.面向對象 1.1 定義 面向對象編程是一種程序設計方法，它將數據和操作數據的方法封裝在一起，形成類。類是一種用戶自定義的數據類型，它包含了數據和對數據的操作方法。面向對象編程的特點包括封裝、繼承、多態 1.2 訪問控制符 public 公有屬性，方法。都可以訪問 prot…
閱讀更多...
Netty之ChannelOutboundBuffer詳解與實戰

Netty之ChannelOutboundBuffer詳解與實戰

深入理解Netty的高低水位線機制及其應用實踐 在高性能網絡編程中&#xff0c;Netty作為一個廣泛使用的異步事件驅動的Java框架&#xff0c;其高效的流量控制機制對于系統的穩定性和性能至關重要。本文將深入探討Netty中的高低水位線&#xff08;High/Low Water Mark&#xff0…
閱讀更多...
（自用）WebSocket創建流程

（自用）WebSocket創建流程

在Spring Boot項目中新建WebSocket服務&#xff0c;可以按照以下詳細步驟進行操作&#xff1a; 1.創建Spring Boot項目 可以通過Spring Initializr&#xff08;<>&#xff09;快速創建一個新的Spring Boot項目&#xff0c;添加Spring Web和Spring Boot DevTools依賴&…
閱讀更多...
JQuery初步學習

JQuery初步學習

文章目錄 一、前言二、概述2.1 介紹2.2 安裝 三、語法3.1 文檔就緒3.2 選擇器 四、事件4.1 概述4.2 事件綁定/解綁4.3 一次性事件4.4 事件委托4.5 自定義事件 五、效果5.1 隱藏/顯示5.2 淡入淡出5.3 滑動5.4 動畫 六、鏈七、HTML7.1 內容/屬性7.2 元素操作7.3 類屬性7.4 樣式屬…
閱讀更多...
最新文章

Copyright @ 2022~2023