1. #!/bin/bash
    3. startTime="2019-06-05 00:00:00"
    4. endTime="2022-02-01 00:00:00"
    6. #lis=(qs sh jsfw pl hzj mhs mch xh sbq nxdq dwk xs nss)
    7. lis=(hzj)
    8. allDbCount=0
    10. for db in ${lis[@]};do
    12.     dbCount=0
    14.     `taos -s "show ${db}.stables" >> /home/${db}.txt`
    15.     `sed -i '1,7d' /home/${db}.txt`
    16.     `sed -i '$d' /home/${db}.txt`
    17.     `sed -i '$d' /home/${db}.txt`
    19.     stbList=`cat /home/${db}.txt | awk -F' ' '{print $1}'`
    21.     echo "=====  dbName: ${db}  ====="
    22.     for stb in ${stbList[@]};do
    23.         (taos -s "select count(*) from ${db}.${stb} where point_time >= \'${startTime}\' and point_time < \'${endTime}\' >> /home/${db}_${stb}.txt")
    24.         `sed -i '1d' /home/${db}_${stb}.txt`
    25.         count=`cat /home/${db}_${stb}.txt`
    26.         echo "===== stbName: ${stb} , stbCount: ${count} ====="
    27.         export dbCount=`expr ${dbCount} + ${count}`
    28.         `rm -rf  /home/${db}_${stb}.txt`
    29.     done
    30.     echo "=====  dbName: ${db} , dbCount: ${dbCount}  ====="
    31.     export allDbCount=`expr ${allDbCount} + ${dbCount}`
    32.     `rm -rf  /home/${db}.txt`
    33. done
    35. echo "=====  allDbCount: ${allDbCount}  ====="