Warning, /CondTools/DT/test/DTReadOutMapping-O2OProcedure is written in an unsupported language. File is not indexed.
0001 ####This is a simulation of O2O procedure for DTReadOutMapping object####
0002
0003 step 1: prepare offline db schema(this is a simulation of ORCON/ORCOFF DBA)
0004
0005 sqlplus user@db/pass<DT-payload.sql
0006 sqlplus user@db/pass<CondIOV.sql
0007 sqlplus user@db/pass<createMetaDataTable.sql
0008
0009 step 2: fill dummy data in offline payload tables with two sets of data
0010 in cms O2O, these tables are filled by O2O queries(this is a
0011 simulation of online to offline transformation)
0012 sqlplus user@db/pass<DT-fillmapping.sql
0013
0014 step 3: setup and fill pool tables(this is a simulation of "poolification" steps after the transformation)
0015 #setenv CORAL_AUTH_USER user not needed if using -u -p
0016 #setenv CORAL_AUTH_PASSWORD pass
0017 ../../Utilities/bin/setup_pool_database DTReadOutMapping CondFormatsDTObjects sqlite_file:testfile.db ../src/DTReadOutMapping-mapping-custom.xml -u user -p pass
0018 ../../Utilities/bin/setup_pool_database "cond::IOV" CondCoreIOVService sqlite_file:testfile.db CondIOV-mapping-custom.xml (will be removed in the future)
0019
0020 step 4: FCregisterPFN -p sqlite_file:testfile.db -t POOL_RDBMS(only if the first time)
0021
0022 step 5: build and tag IOV. NOTE: two infinite IOV tagged by different
0023 tags. The selection of the data is by query on the extra columns in table
0024 DTREADOUTMAPPING (this is a simulation of tagging the data from online)
0025
0026 cmscond_build_iov_byquery -i -q "CELL_MAP_VERSION='my_ROB' AND ROB_MAP_VERSION='my_ROS'" -u user -p pass -d CondFormatsDTObjects -t DTREADOUTMAPPING -o DTReadOutMapping -c sqlite_file:testfile.db myversion
0027 cmscond_build_iov_byquery -i -q "CELL_MAP_VERSION='cmssw_ROB' AND ROB_MAP_VERSION='cmssw_ROS'" -u user -p pass -d CondFormatsDTObjects -t DTREADOUTMAPPING -o DTReadOutMapping -c sqlite_file:testfile.db cmssw_version
0028
0029 step 6: read data back from cmsRun. Note the tag value (this is a simulation of offline CMSSW job)
0030 cmsRun load_test_myversion.cfg
0031 cmsRun load_test_cmsswversion.cfg
