日期判断行修改脚本

#!/bin/sh
#
#the cobar create table on a file of schema.xml
excd=$(date +%Y%m%d)
endd=$(date +%Y%m%d -d +6day)   #当前日期向后推6天的日期
for i in $(seq 6) ; do
 if  [ $excd -le $endd ] && [ $(date -d $excd +%w) -ne 0 ] &&  [ $(date -d $excd +%w) -ne 6 ] ;then   #[$(date -d $excd +%w) -ne 0]判断日期是星期几，0是星期日、6是星期6
        sed -i "s@\(TQ.*ticktable_[0-9]\+\)@\1,k_minute1_$excd,ticktable_$excd@g" /tmp/schema.xml    #如果sed命令参数中有变量记得要用单引号，
#        echo "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA         is finish"
      fi
    excd=$(date +%Y%m%d -d +${i}day)
    continue
done



#!/bin/sh
#
excd=$(date +%Y%m%d)
#endd=$(date +%Y%m%d -d +6day)
for i in $(seq 0 6); do
  tdd=$(date +%Y%m%d -d +${i}day)
  if [ $(date -d +${i}day +%w) -ne 0 ] && [ $(date -d +${i}day +%w) -ne 6 ] ;then
    /mysql/bin/mysql --socket=/mysql/tmps/mysql.sock33017 shhq -e "create table k_minute1_${tdd} like k_minute1_20150910;"
    /mysql/bin/mysql --socket=/mysql/tmps/mysql.sock33017 shhq -e "create table ticktable_${tdd} like ticktable_20150910;"
    /mysql/bin/mysql --socket=/mysql/tmps/mysql.sock33018 shhq -e "create table k_minute1_${tdd} like k_minute1_20150910;"
    /mysql/bin/mysql --socket=/mysql/tmps/mysql.sock33018 shhq -e "create table ticktable_${tdd} like ticktable_20150910;"
  else
    continue
  fi
done

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29620572/viewspace-1799913/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29620572/viewspace-1799913/