Warning, /CondTools/SiPixel/scripts/prepare_pixel_conditions.csh is written in an unsupported language. File is not indexed.
0001 #THIS SCRIPT NEEDS PASSWORD MODIFICATION BEFORE IT CAN RUN
0002 #lookup password for database and replace everywhere it says "PSWD"
0003 echo "Tables before nuking"
0004 pool_list_object_relational_mapping -c "oracle://cms_orcoff_int2r/CMS_COND_PIXEL" -u CMS_COND_PIXEL -p PSWD
0005 echo "Nuking tables..."
0006 sqlplus cms_cond_pixel@cms_orcoff_int2r/PSWD < CondTools/OracleDBA/sql/nuke_tables.sql
0007 echo "Preparing schema"
0008 #pool_build_object_relational_mapping -f mapping-template-SiPixelGainCalibration.xml -o test.xml -d CondFormatsSiPixelObjects -b -c "sqlite_file:test.db" -u whatever -p wherever
0009 pool_build_object_relational_mapping -f CondTools/OracleDBA/xml/mapping_SiPixelObjects_CMSSW200.xml -d
0010 CondFormatsSiPixelObjects -c "oracle://cms_orcoff_int2r/CMS_COND_PIXEL" -u CMS_COND_PIXEL -p PSWD
0011 echo "Upload cabling map"
0012 echo "Offline Gain calib"
0013 echo
0014 echo "List available tags"
0015 cmscond_list_iov -c oracle://cms_orcoff_int2r/CMS_COND_PIXEL -u cms_cond_pixel -p PSWD
