P5/21X/CreateSchema.sh

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