Common/test/DropBoxMetadataReader.py

0001 # documentation: https://twiki.cern.ch/twiki/bin/view/CMS/AlCaDBPCL#Drop_box_metadata_management
0002
0003 import FWCore.ParameterSet.Config as cms
0004
0005 process = cms.Process("myprocess")
0006
0007 process.load("CondCore.CondDB.CondDB_cfi")
0008 process.load("FWCore.MessageService.MessageLogger_cfi")
0009
0010 process.CondDB.connect = 'sqlite_file:DropBoxMetadata.db'
0011
0012 process.maxEvents = cms.untracked.PSet(
0013     input = cms.untracked.int32(1)
0014 )
0015 process.source = cms.Source("EmptySource",
0016                             firstRun = cms.untracked.uint32(300000)
0017                             )
0018
0019
0020 # given a set of .json files in the current dir, ProduceDropBoxMetadata produces a sqlite containign the payload with the prod/and/prep metadata
0021 process.myReader = cms.EDAnalyzer("ProduceDropBoxMetadata",
0022                                   # set to True if you want to write out a sqlite.db translating the json's into a payload
0023                                   write = cms.untracked.bool(False),
0024                                   toWrite = cms.VPSet(),
0025
0026                                   # this boolean will read the content of whichever payload is available and print its content to stoutput
0027                                   # set this to false if you write out a sqlite.db translating the json's into a payload
0028                                   read = cms.untracked.bool(True),
0029                                   # toRead lists of record names to be sought inside the DropBoxMetadataRcd payload avaialble to the ProduceDropBoxMetadata;
0030                                   # for instance, if write is True, you're reading back the metadata you've just entered in the payload from the .json files
0031                                   toRead = cms.untracked.vstring(
0032                                     'BeamSpotObjectsRcdByRun',
0033                                     'BeamSpotObjectsRcdByLumi',
0034                                     'BeamSpotObjectsRcdHPByLumi',
0035                                     'BeamSpotObjectsRcdHPByRun',
0036                                     'SiStripBadStripRcd',
0037                                     'SiStripBadStripFromHitEffRcd',
0038                                     'SiStripApvGainRcd',
0039                                     'TrackerAlignmentRcd',
0040                                     'TrackerAlignmentHGRcd',
0041                                     'SiStripApvGainRcdAAG',
0042                                     'EcalPedestalsRcd',
0043                                     "LumiCorrectionsRcd",
0044                                     "SiPixelQualityFromDbRcd_prompt",
0045                                     "SiPixelQualityFromDbRcd_stuckTBM",
0046                                     "SiPixelQualityFromDbRcd_other",
0047                                     "SiPixelLorentzAngleRcd",
0048                                     "SiPixelLorentzAngleRcdMCS",
0049                                     "CTPPSRPAlignmentCorrectionsDataRcd",
0050                                     "PPSTimingCalibrationRcd_HPTDC",
0051                                     "PPSTimingCalibrationRcd_SAMPIC",
0052                                     "SiStripLorentzAngleRcd",
0053                                     ) # same strings as fType
0054                                   )
0055
0056 process.p = cms.Path(process.myReader)
0057
0058 process.load('Configuration.StandardSequences.FrontierConditions_GlobalTag_cff')
0059 process.GlobalTag.globaltag = '124X_dataRun3_Express_Queue'
0060
0061 # Set to True if you want to read a DropBoxMetadata payload from a local sqlite
0062 # specify the name of the sqlitefile.db and the tag name; the payload loaded will be for run 300000
0063 readsqlite = True
0064 if readsqlite:
0065     process.GlobalTag.toGet = cms.VPSet(
0066         cms.PSet(record = cms.string("DropBoxMetadataRcd"),
0067                  tag = cms.string("DropBoxMetadata"),
0068                  connect = cms.string("sqlite_file:DropBoxMetadata.db")
0069                 )
0070         )