Warning, /CondCore/Utilities/test/migrateAlign is written in an unsupported language. File is not indexed.
0001
0002 #in 180 with CondCore/Utilities V04-04-00
0003 cd /build/vin/Align18X
0004 foreach tag (TIFpass4 TIFpass4APE TibTidModuleSurvey_v4 TibTidModuleSurveyAPE_v4 TibTidTecAllSurvey_v4 TibTidTecAllSurveyAPE_v4)
0005 set pname=`cmscond_list_iov -c frontier://cmsfrontier.cern.ch:8000/Frontier/CMS_COND_18X_ALIGNMENT -t $tag | grep "Payload" | sed 's/.*PayloadContainerName //g' | sed 's/Rcd//'`
0006 cmscond_export_iov -s frontier://cmsfrontier.cern.ch:8000/Frontier/CMS_COND_18X_ALIGNMENT -d sqlite_file:$tag.db -D CondFormatsAlignment -t $tag -n $pname
0007 cmscond_list_iov -c sqlite_file:$tag.db -t $tag
0008 end
0009
0010 set dir200=/build/vin/Align20X
0011 set dir180=/build/vin/Align18X
0012 cd $dir200
0013 foreach x ($dir180/*.db)
0014 echo $x
0015 foreach tag (`cmscond_list_iov -c sqlite_file:$x`)
0016 cmscond_list_iov -c sqlite_file:$x -t $tag > `basename $x`_dump.${tag}
0017 end
0018 end
0019
0020 #in 200
0021 set dict=CondFormatsAlignment
0022 set dir200=/build/vin/Align20X
0023 set dir180=/build/vin/Align18X
0024 cd dir200
0025 cp $dir180/*.db $dir200/.
0026
0027 touch drop
0028 echo "drop table METADATA;" >> drop
0029 foreach x ($dir200/*.db)
0030 echo $x
0031 pool_upgrade_pool_schema -c sqlite_file:$x -d $dict
0032 pool_drop_container -n "cond::IOV" --full -c sqlite_file:$x
0033 echo ".exit" | sqlite3 -batch -init drop $x
0034 end
0035 rm drop
0036
0037 foreach x (*_dump*)
0038 set file = `echo $x | sed 's/_dump.*$//'`
0039 echo $file
0040 cmscond_load_iov -c sqlite_file:$dir200/$file $x
0041 end
0042
0043
0044 foreach x ($dir200/*.db)
0045 echo $x
0046 pool_query_database -c sqlite_file:$x -d $dict CondCoreIOVService
0047 foreach tag (`cmscond_list_iov -c sqlite_file:$x`)
0048 echo $tag
0049 cmscond_list_iov -c sqlite_file:$x -t $tag
0050 end
0051 end
0052
0053 cd /build/vin/Align20X
0054 set dir200=/build/vin/Align20X
0055 foreach x ($dir200/*.db)
0056 echo $x
0057 foreach tag (`cmscond_list_iov -c sqlite_file:$x`)
0058 echo $tag
0059 set pname=`cmscond_list_iov -c sqlite_file:$x -t $tag | grep "Payload" | sed 's/.*PayloadContainerName //g' | sed 's/Rcd//'`
0060 cmscond_export_iov -s sqlite_file:$x -d oracle://cms_orcoff_int2r/CMS_COND_ALIGNMENT -p /afs/cern.ch/cms/DB/conddb -D CondFormatsAlignment -t $tag -n $pname
0061 cmscond_list_iov -c oracle://cms_orcoff_int2r/CMS_COND_ALIGNMENT -P /afs/cern.ch/cms/DB/conddb -t $tag
0062 end
0063 end
0064
