Shell之导出数据库的表为Excel的脚本

最新推荐文章于 2024-09-25 15:03:42 发布

sauphy

最新推荐文章于 2024-09-25 15:03:42 发布

阅读量1w

点赞数

本文链接：https://blog.csdn.net/sauphy/article/details/50116735

版权

## exportLog.sh

#!/bin/bash
#*/30 * * * * /usr/donica/script/exportLog.sh

AIRPLANE="Default"
TMP1="cmt_operate_"
YEAR=$(date +%Y)
MONTH=$(date +%m)
DAY=$(date +%d)
TMP2=".xls"

FILENAME=${TMP1}${YEAR}${MONTH}${DAY}${TMP2}

FILENAME_MONTH=${TMP1}${YEAR}${MONTH}${TMP2}
#echo $FILENAME
LAST_DAY=`cal $MONTH $YEAR|xargs echo|awk '{print $NF}'`
FILENAME_30="cmt_operate_30days.xls"
MYSQL_PATH='/opt/lampp/bin/mysql'
FLAG='--user=hhwifi --password=donica2012 --database=cmt_wifi'
OPERATE_PATH='/root/'

#delete the files every time
find /usr/tuyue/log -mtime +30 -name "cmt_operate_*" -exec rm -f {} \;

$MYSQL_PATH $FLAG -e "select * from cmt_operate where UNIX_TIMESTAMP( operate_time ) >= UNIX_TIMESTAMP( ) - 60*60*24*30" > $FILENAME_30
$MYSQL_PATH $FLAG -e "select * from cmt_operate where DATE_FORMAT( operate_time,  '%Y-%m-%d' ) = DATE_FORMAT( NOW() , '%Y-%m-%d')" > $FILENAME

##Get Plane ID Begin##
PLANE_STR=$($MYSQL_PATH $FLAG -e "select var_value from cmt_config where var_name='system_id' limit 1")
AIRPLANE_STR=$(echo $PLANE_STR | awk '{print $2}')
if [ -z "$AIRPLANE_STR" ]; then
        echo ">>>>>>>>[cmt_wifi/cmt_config/system_id] is NULL,please set the flight id for it."
else
        AIRPLANE=$AIRPLANE_STR
fi
mkdir -p /usr/tuyue/log/$AIRPLANE
##Get Plane ID End##

\cp -f /root/cmt_operate_* /usr/tuyue/log/$AIRPLANE/
rm /root/cmt_operate_*
~