shell mysql 处理数据小结
shell mysql 处理数据小结，shell中子进行变量的传递看了好久..学习一下另一种思维方式
# cat productinfo.sh
#!/bin/bash
#stat data for check product system
#cc@ccsafe.com
#2008-10-15
readonly -a g_DBConf=("-hlocalhost" "-uuser" "-ppwd")
readonly -a g_DBConf_remote=("-hccsafe" "-uuser2" "-ppwd2")
readonly g_resultFile="/usr/local/product_info_svr/dbshell/check_url/stat_result.txt"
readonly g_LogFile="/home/saferoot/cc/productinfo.log"
readonly g_tmp="/tmp/tmpurl"
g_checkday=0
g_checkedday=0
g_productday=0
g_productdomain=0
g_producturls=0
g_urldomain=""
function stat_day_domain_num()
{
cat $g_tmp |awk -F '/' '{print $3}'|sort |uniq -c |sort -nr |head -20|while read LINE
#while read -r LINE
do
g_producturls=$(echo $LINE |awk '{print $1}')
g_urldomain=$(echo $LINE |awk '{print $2}')
echo "$g_producturls $g_urldomain"
local sql="INSERT INTO xlstat.webdomainstat(urldomain,producturls) VALUES('$g_urldomain','$g_producturls');"
#echo $sql
g_sql=`printf "%s%s" "$g_sql" "$sql"`
#sub process!!
echo "$g_sql">/tmp/tmpsql
#echo "$sql" |mysql ${g_DBConf_remote[@]}
done
read g_g_sql> ${g_LogFile}
wait
end_t=`date +"%s"`
echo "`date +"[%Y%m%d %T]"` shell end. use-time:$(( end_t-start_t ))sec. "
}
main $@
#
页:
[1]