Code666 (代码贴、代码片段)

[PowerShell] shell 日志统计程序 →→→→→进入此内容的聊天室

来自 , 2019-04-10, 写在 PowerShell, 查看 122 次.
URL http://www.code666.cn/view/e9a53d0e
  1.   #!/bin/sh
  2.  
  3.   mday=$(date +%Y%m%d -d "1 day ago")
  4.   fday=$(date +%m%d -d "1 day ago")  #filename
  5.   filedir=/home/fanhy
  6.  
  7.   #echo $mday
  8.   #cur_dir=$(pwd)
  9.   #arg=$1
  10.  #echo $arg
  11.  #echo $mday
  12.  #grep ' unsign' $filedir
  13.  #cat $filedir/*.txt|grep 'unsign' > $filedir/test.log
  14.  grep ' unsign' $filedir/*_$fday.txt | awk -F "total): " '{print $2}'| awk '{a[$1]+=$2}END{for(i in a) if(i>0 && a[i]>0) print "INSERT INTO match_signret_stat(`ma
  15.   tch_id`,`day`,`state`,`num`)VALUES(" i,"," m,"," 2,"," a[i] ");"}' RS=" " FS=":" m=$mday > $filedir/$mday.unsign.sql
  16.  
  17.  grep ' sign' $filedir/*_$fday.txt | awk -F "total): " '{print $2}'| awk '{a[$1]+=$2}END{for(i in a) if(i>0 && a[i]>0) print "INSERT INTO match_signret_stat(`matc
  18.   h_id`,`day`,`state`,`num`)VALUES(" i,"," m,"," 1,"," a[i] ");"}' RS=" " FS=":" m=$mday > $filedir/$mday.sign.sql
  19.  
  20.  
  21.  ##mysql insert
  22.  /usr/bin/mysql -uroot jjstat < $filedir/$mday.unsign.sql;
  23.  /usr/bin/mysql -uroot jjstat < $filedir/$mday.sign.sql;
  24. //shell/5687

回复 "shell 日志统计程序"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666