RunInfoPlugins/test/inspectRunInfo_3XX.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_31X_RUN_INFO"
0010 logName = "oracle://cms_orcoff_prod/CMS_COND_31X_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 # for inspecting last run after run has started
0019 tag = 'runinfo_start_31X_hlt'
0020
0021 # for inspecting last run after run has stopped
0022 #tag = 'runsummary_test'
0023
0024 try :
0025     log = db.lastLogEntry(tag)
0026     #for printing all log info present into log db
0027     #print log.getState()
0028
0029     # for inspecting all payloads/runs
0030     #iov = inspect.Iov(db,tag)
0031
0032     #for inspecting only last payload/run
0033     iov = inspect.Iov(db,tag,0,0,0,1)
0034     print(iov.list())
0035     for x in  iov.summaries():
0036         print(x[1], x[2] ,x[3])
0037     #        print iov.trend("",[0,2,12])
0038 except RuntimeError :
0039     print(" no iov? in", tag)
0040
0041