文件名：recomment.sh
路径: $HOME/ggscript/ggcomment
功能：该脚本用于批量取消注释，配合批量注释脚本使用，基本功能相反，操作步骤完全一致。通过edit脚本选择使用
日志路径:$HOME/gglog/ggcomment
#!/bin/bash
backuptime=`date +%Y%m%d-%H%M`
echo "This script is used to reannotate the specified table!(created by renyi)"
echo $backuptime > ''$HOME'/gglog/ggcomment/reannoLog-'$backuptime'.log'
read -n 1
ls -lrt $HOME/ggserver/dirprm/*.prm
read -p "Please enter the prm file name:" val
echo "Please Enter the table you need to reannotate"
read -n 1
vi annotmp
echo "---reannotate table --------" > ''$HOME'/gglog/ggcomment/reannoLog-'$backuptime'.log'
cat annotmp >> ''$HOME'/gglog/ggcomment/annoLog-'$backuptime'.log'
cp $HOME/ggserver/dirprm/$val $HOME/ggserver/dirprm/bak/$val.$backuptime.bak
echo "backup the '$val' to the '$HOME/ggserver/dirprm/bak/$val.$backuptime.bak'" >> ''$HOME'/gglog/ggcomment/reannoLog-'$backuptime'.log'
echo ch
echo "Operating table you want to belong to what state?"
select ch in "parameter" "noparameter" "REPLICAT" "exit"
do
case $ch in
"parameter")
sed 's/^/TABLE /' annotmp > table1
sed 's/$/,/' table1 > table2
break;
;;
"noparameter")
sed 's/^/TABLE /' annotmp > table1
sed 's/$/;/' table1 > table2
break;
;;
"REPLICAT")
sed 's/^/MAP /' annotmp > table1
sed 's/$/,/' table1 > table2
break;
;;
"exit")
echo "process complete"
break;
;;
*)
echo "Please select your choice :"1.parameter" "2.noparameter" "3.REPLICAT" "exit""
;;
esac
done;
echo $TAL
i=1
num=`sed -n '$=' table2`
while [ "$i" -le "$num" ]
do
TAL=`sed -n $i'p' table2`
echo $TAL
echo --$TAL
sed "s/--$TAL/$TAL/g" $HOME/ggserver/dirprm/$val > tmp2
cat tmp2 > $HOME/ggserver/dirprm/$val
((i++));
done
echo "process complete" >> ''$HOME'/gglog/ggcomment/reannoLog-'$backuptime'.log'
