#!/bin/bash
#dates=`date +%Y-%m-%d`
dates=`date -d"1 days ago" +%Y-%m-%d`
path_log=/home/logs/fight_cancer_interface/info.$dates.log
path_sql=/home/sql/$dates.sql
grep "统计使用" $path_log | awk -F"统计使用--" '{print $1,$2}' | awk -F"INFO com.wyqj.fightcancer.intercepter.LogInterceptor - /fight_cancer_interface/" '{print $1,$2}' | awk -F".json" '{print $1,$2}' |awk -F"[" '{print $1,"@@@###",$2}'|awk -F"]" '{print $1,"@@@###",$2}' |awk -F'@@@###' '{print $1,$3}' | awk -F ",[[:digit:]][[:digit:]][[:digit:]]" '{print $1,$2}' | awk -F" " '{print $1,$2}' | sed 's/\(:[[:digit:]][[:digit:]]:[[:digit:]][[:digit:]]\)/\1,/g' | awk -F"," '{print $3","$5","$4","$6","$2","$1");"}' |sed "s/,/\',\'/g" |sed "s/);/\');/g" |sed "s/^/\'/g" |sed 's/^/INSERT INTO `fight_cancer`.`tb_statistics_base_info` (`client`,`uniquecode`,`device`,`versioncode`,`interface`,`createtime`) VALUES (/g'|sed "s/client=//g"|sed "s/uniquecode=//g"|sed "s/device=//g" |sed "s/versioncode=//g" > $path_sql
mysql -uroot -pwyqj_root fight_cancer < $path_sql
转载于:https://blog.51cto.com/yyyummy/1417050