文件名:recomment.sh

路径: $HOME/ggscript/ggcomment

功能:该脚本用于批量取消注释,配合批量注释脚本使用,基本功能相反,操作步骤完全一致。通过edit脚本选择使用

日志路径:$HOME/gglog/ggcomment

#!/bin/bashbackuptime=`date+%Y%m%d-%H%M`echo"Thisscriptisusedtoreannotatethespecifiedtable!(createdbyrenyi)"echo$backuptime>''$HOME'/gglog/ggcomment/reannoLog-'$backuptime'.log'read-n1ls-lrt$HOME/ggserver/dirprm/*.prmread-p"Pleaseentertheprmfilename:"valecho"PleaseEnterthetableyouneedtoreannotate"read-n1viannotmpecho"---reannotatetable--------">''$HOME'/gglog/ggcomment/reannoLog-'$backuptime'.log'catannotmp>>''$HOME'/gglog/ggcomment/annoLog-'$backuptime'.log'cp$HOME/ggserver/dirprm/$val$HOME/ggserver/dirprm/bak/$val.$backuptime.bakecho"backupthe'$val'tothe'$HOME/ggserver/dirprm/bak/$val.$backuptime.bak'">>''$HOME'/gglog/ggcomment/reannoLog-'$backuptime'.log'echochecho"Operatingtableyouwanttobelongtowhatstate?"selectchin"parameter""noparameter""REPLICAT""exit"docase$chin"parameter")sed's/^/TABLE/'annotmp>table1sed's/$/,/'table1>table2break;;;"noparameter")sed's/^/TABLE/'annotmp>table1sed's/$/;/'table1>table2break;;;"REPLICAT")sed's/^/MAP/'annotmp>table1sed's/$/,/'table1>table2break;;;"exit")echo"processcomplete"break;;;*)echo"Pleaseselectyourchoice:"1.parameter""2.noparameter""3.REPLICAT""exit"";;esacdone;echo$TALi=1num=`sed-n'$='table2`while["$i"-le"$num"]doTAL=`sed-n$i'p'table2`echo$TALecho--$TALsed"s/--$TAL/$TAL/g"$HOME/ggserver/dirprm/$val>tmp2cattmp2>$HOME/ggserver/dirprm/$val((i++));doneecho"processcomplete">>''$HOME'/gglog/ggcomment/reannoLog-'$backuptime'.log'