1. Read the parent directory of the execution
basepath=$ (CD ' DirName $ '; CD.; pwd)
2.Sudo switch User and execute MySQL statement
echo ' password ' |sudo-u mysqladmin-s/usr/local/mysql/bin/mysql-umysql user name-pmysql password-e "delete xxxx;"
3. Parameter reading
if[[$#-ge1]]; Thenopt=" $" Shift Case "$opt" inch-Help ) print_msg"$helpInfo" ;; -Day ) Targettime=`Date-D" $" "+%y%m%d"' Train_day $targetTime;; -daysection) BeginTime=`Date-D" $" "+%y%m%d"' EndTime=`Date-D" $" "+%y%m%d"` while["$beginTime"-le"$endTime" ] Dotrain_day $beginTime beginTime=`Date-D"$beginTime +1 Day"+%y%m%d ' Done ;; *) print_msg"train_day parameter Error $helpInfo"-Err Exit1 ;; EsacElsetargettime=`Date-D"-1 Day"+%y%m%d ' print_msg"Default statistics $targetTime yesterday"train_day $targetTime Exit0fi
Shell Base Library
#!/bin/Bashfunctionprint_msg () { Help='print_msg message content [-err |-waring |-info]' if[[$#-eq1]]; Then Echo-E"\033[42m \033[01m $ \033[0m" elif[[$#-ge1]]; Thenmsg=$1opt=" $" Shift Case "$opt" inch-err)Echo-E"\033[41m \033[01m $msg \033[0m" ;; -Waring)Echo-E"\033[43m \033[01m $msg \033[0m" ;; -Info) Echo-E"\033[42m \033[01m $msg \033[0m" ;; *) Echo-E"\033[41m \033[01m print_msg error: $help \033[0m"Exit1 ;; Esac Else Echo-E"\033[41m \033[01m print_msg error: $help \033[0m"Exit1 fi}functionread_conf () { Help="read_conf configuration file address configuration section name" if[[$#-eq2]] ; Thenvalue=$(sed "/^$2=/!d;s/.*=//"$1) Echo$valueElseprint_msg'read_conf parameter error: $help'-Err Exit1 fi}
[linux]-Common code block