SiStrip/scripts/CreatingTables.sh

0001 #!/bin/sh
0002 connectstring=$1
0003 aUSER=$2
0004 aPASSWD=$3
0005
0006 eval `scramv1 runtime -sh`
0007
0008 workdir=`pwd`
0009
0010 path=$CMSSW_BASE/src/CondFormats/SiStripObjects/xml/
0011 if [ ! -e $path ] ;then
0012 path=$CMSSW_RELEASE_BASE/src/CondFormats/SiStripObjects/xml/
0013 if [ ! -e $path ]; then
0014 echo -e "Error: CondFormats/SiStripObjects/xml doesn't exist\nplease install that package\nexit"
0015 exit 1
0016 fi
0017 fi
0018
0019
0020 echo -e "\n-----------\nCreating tables for db ${connectstring} \n-----------\n"
0021
0022 #cmscond_bootstrap_detector.pl --offline_connect ${connectstring} --auth /afs/cern.ch/cms/DB/conddb/authentication.xml STRIP
0023 for obj in `ls $path/*xml`
0024   do
0025   echo -e  "\npool_build_object_relational_mapping -f $obj   -d CondFormatsSiStripObjects -c ${connectstring} -s $aUSER -p $aPASSWD \n"
0026   pool_build_object_relational_mapping -f $obj   -d CondFormatsSiStripObjects -c ${connectstring} -u $aUSER -p $aPASSWD
0027 done