P5/20X/SiStripO2O_AT_P5.sh

0001 #!/bin/bash
0002
0003 pedestalsTag=test_SiStripPedestals_TKCC_20X
0004 noiseTag=test_SiStripNoise_TKCC_20X
0005 cabTag=test_SiStripFedCabling_TKCC_20X
0006 authPath=/nfshome0/xiezhen/conddb/
0007 connectString="oracle://cms_orcon_prod/CMS_COND_20X_STRIP"
0008
0009 log=log_at_P5
0010 rm -rf $log
0011 mkdir $log
0012
0013 eval `scramv1 runtime -sh`
0014
0015 export TNS_ADMIN=/nfshome0/xiezhen/conddb/
0016
0017 #sqlplus -S -M "HTML ON " cms_trk_tkcc/tkcc2008@cms_omds_lb < OMDSQuery.sql
0018
0019 sqlplus -S -M "HTML ON " cms_trk_tkcc/tkcc2008@cms_omds_lb < OMDSQuery.sql | awk 'BEGIN{newline=0; stringa=""} $0~/<*th.*>/{newline=0} $0~/<tr>/{newline=1;if(stringa!="") print stringa; stringa=""} $0~/<\/tr>/{newline=0;} $0!~/<?td.*>/{if(newline && $0!="<tr>"){stringa=sprintf("%s %s",stringa,$0)}}' | sort -n| while read line;
0020   do
0021   vec=($line)
0022   echo ${vec[@]}
0023   runNb=${vec[0]}
0024     #echo ${vec[1]}
0025   partition=${vec[2]}
0026   fecV=${vec[3]}
0027   fedV=${vec[4]}
0028   cabV=${vec[5]}
0029
0030   echo $runNb $partition $fecV $fedV $cabV
0031
0032   fedVMaj=`echo $fedV | cut -d "." -f1`
0033   fedVmin=`echo $fedV | cut -d "." -f2`
0034
0035   fecVMaj=`echo $fecV | cut -d "." -f1`
0036   fecVmin=`echo $fecV | cut -d "." -f2`
0037
0038   cabVMaj=`echo $cabV | cut -d "." -f1`
0039   cabVmin=`echo $cabV | cut -d "." -f2`
0040
0041   echo $fedVMaj $fedVmin
0042   cat template_sistripo2o.cfg | sed -e "s@insert_Run@$runNb@g" -e "s@insert_ConfigDbPartition@$partition@g" -e "s@insert_cabmajor@$cabVMaj@g" -e "s@insert_cabminor@$cabVmin@g" -e "s@insert_fedmajor@$fedVMaj@g" -e "s@insert_fedminor@$fedVmin@g" -e "s@insert_fecmajor@$fecVMaj@g" -e "s@insert_fecminor@$fecVmin@g" -e "s@insert_authPath@$authPath@" -e "s@insert_pedestals_tag@$pedestalsTag@" -e "s@insert_noise_tag@$noiseTag@" -e "s@insert_cabling_tag@$cabTag@"  -e "s@insert_connect_string@$connectString@" > $log/siStripO2O_$runNb.cfg
0043
0044   cmsRun $log/siStripO2O_$runNb.cfg > $log/siStripO2O_$runNb.log
0045 done