#!/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
#
#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/