RunInfoPlugins/test/inspectL1Scaler.py

0001 import os,sys, DLFCN
0002 sys.setdlopenflags(DLFCN.RTLD_GLOBAL+DLFCN.RTLD_LAZY)
0003
0004 from pluginCondDBPyInterface import *
0005 a = FWIncantation()
0006 #os.putenv("CORAL_AUTH_PATH","/afs/cern.ch/cms/DB/conddb")
0007 rdbms = RDBMS("/afs/cern.ch/cms/DB/conddb")
0008
0009 dbName =  "oracle://cms_orcoff_prod/CMS_COND_21X_RUN_INFO"
0010 logName = "oracle://cms_orcoff_prod/CMS_COND_21X_POPCONLOG"
0011
0012 rdbms.setLogger(logName)
0013 from CondCore.Utilities import iovInspector as inspect
0014
0015 db = rdbms.getDB(dbName)
0016 tags = db.allTags()
0017
0018 tag = 'l1triggerscaler_test_v2'
0019
0020 try :
0021     log = db.lastLogEntry(tag)
0022     print(log.getState())
0023
0024     #for printing all log info present into log db
0025     #print log.getState()
0026
0027     # for inspecting all payloads/runs
0028     #iov = inspect.Iov(db,tag)
0029
0030     #for inspecting only last payload/run
0031     iov = inspect.Iov(db,tag,1,1,1,0)
0032     print(iov.list())
0033     for x in  iov.summaries():
0034         print(x[1], x[2] ,x[3])
0035     #        print iov.trend("",[0,2,12])
0036 except RuntimeError :
0037     print(" no iov? in", tag)
0038
0039