- 论坛徽章:
- 1
|
本帖最后由 pandorabag 于 2010-12-23 08:25 编辑
- # !/bin/sh
- day=`date +%Y-%m-%d`
- lastday=`date -d "-1 day" +%Y-%m-%d`
- hour=`date -d "-1 hour" +%H`
- if [ $1 ]; then
- day=$1
- fi
- if [ $2 ];then
- hour=$2
- fi
- if [ $3 ];then
- lastday=$3
- fi
- ###############declare#############
- today=$day"-"$hour
- last=$lastday"-"$hour
- ###############func################
- check ()
- {
- if [ $1 ];then
- vt=$1
- fi
- if [ $2 ];then
- user=$2
- fi
- database='/usr/local/mysql/bin/mysql -uroot -pabdd market -e'
- text=`$database "select a,b from down where datestat ='$day' and hourstat='$hour' and product='$vt' ;"`
- com=`echo $text |awk '{printf"%d",$3}' `
- tdown=`echo $text |awk '{printf"%d",$4}' `
- if (( `expr $com \< 130`)) && ((`expr $com \> 70` )) ;then
- echo $1"ok " $com
- else
- lasttext=`$database "select a from down where datestat ='$lastday' and hourstat='$hour' and product='$vt'; "`
- ldown=`echo $lasttext |awk '{printf"%d",$2}' `
- echo -e "\n\n"$1" error 异常: \n\n\ndate\tdowns\n\n$day\t$tdown\n\n$lastday\t$ldown\n\n同比\t$com%\n" |/usr/local/bin/mutt -s $vt"下载量异常" $user
- fi
- }
- check a xx@qq.com
- check b aa@126.com
- check c dd@123.com
复制代码 写了这段代码,求高手们拍砖
代码实现的左右就是从数据库表查询一个结果 并比较
高手们看看那里写的复杂了 或者难看
第一次自己写code 想多注意些格式
欢迎批评指正 |
|