def getGoodBRuns():
runs_b_on = []
sys.setdlopenflags(DLFCN.RTLD_GLOBAL + DLFCN.RTLD_LAZY)
a = FWIncantation()
#os.putenv("CORAL_AUTH_PATH","/afs/cern.ch/cms/DB/conddb")
rdbms = RDBMS("/afs/cern.ch/cms/DB/conddb")
db = rdbms.getDB(options.dbName)
tags = db.allTags()
if options.printTags:
print "\nOverview of all tags in " + options.dbName + " :\n"
print tags
print "\n"
sys.exit()
# for inspecting last run after run has started
#tag = 'runinfo_31X_hlt'
tag = options.dbTag
# for inspecting last run after run has stopped
#tag = 'runinfo_test'
try:
#log = db.lastLogEntry(tag)
#for printing all log info present into log db
#print log.getState()
iov = inspect.Iov(db, tag)
#print "########overview of tag "+tag+"########"
#print iov.list()
if v > 1:
print "######## summries ########"
for x in iov.summaries():
print x[0], x[1], x[2], x[3]
what = {}
if v > 1:
print "###(start_current,stop_current,avg_current,max_current,min_current,run_interval_micros) vs runnumber###"
print iov.trend(what)
if v > 0:
print "######## trends ########"
for x in iov.trendinrange(what, options.startRun - 1,
options.endRun + 1):
if v > 0 or x[0] == 67647L or x[0] == 66893L or x[0] == 67264L:
print x[0], x[1], x[2], x[2][4], x[2][3]
#print x[0],x[1] ,x[2], x[2][4], timeStamptoUTC(x[2][6]), timeStamptoUTC(x[2][7])
if x[2][4] >= minI and x[2][3] <= maxI:
runs_b_on.append(int(x[0]))
except Exception, er:
print er
def dumpXML(db,tag,since,filename='dump.xml'):
'''Dump record in XML format for a given tag '''
try :
iov = inspect.Iov(db,tag)
token = getToken(db,tag,since)
payload=inspect.PayLoad(db,token)
out = open(filename,'w')
print >> out, payload
except Exception,er :
print er
def listIovs(db, tag):
'''List all available iovs for a given tag'''
try:
iov = inspect.Iov(db, tag)
iovlist = iov.list()
print("Available iovs for tag: ", tag)
for p in iovlist:
print(" Since ", p[1], " Till ", p[2])
except Exception as er:
print(" listIovs exception ", er)
def plot (db, tag,since,filename='plot.root'):
'''Invoke the plot function from the wrapper and save to the specified \
file. The file format will reflect the extension given.'''
try :
iov = inspect.Iov(db,tag)
iovlist = iov.list()
token = getToken(db,tag,since)
payload=inspect.PayLoad(db,token)
payload.plot(filename,"",[],[])
except Exception,er :
print er
def getToken(db, tag, since):
''' Return payload token for a given iov, tag, db'''
try:
iov = inspect.Iov(db, tag)
iovlist = iov.list()
for p in iovlist:
tmpsince = p[1]
if str(tmpsince) == str(since):
return p[0]
print("Could not retrieve token for tag: ", tag, " since: ", since)
sys.exit(0)
except Exception as er:
print(er)
def listIovs(self, tag='EcalIntercalibConstantsMC_EBg50_EEnoB'):
db = self.rdbms.getDB(self.dbName)
iov_list = []
try:
#db.startTransaction()
iov = inspect.Iov(db, tag)
iovlist = iov.list()
#db.commitTransaction()
#print "Available iovs for tag: ",tag
for p in iovlist:
iov_list.append([p[1], p[2]])
iov = 0
except Exception, er:
print er
def dumpXML(db, tag, since, filename='dump.xml'):
'''Dump record in XML format for a given tag '''
try:
iov = inspect.Iov(db, tag)
db.startReadOnlyTransaction()
Plug = __import__(str(db.payloadModules(tag)[0]))
payload = Plug.Object(db)
listOfIovElem = [iovElem for iovElem in db.iov(tag).elements]
inst = 0
for elem in db.iov(tag).elements:
inst = inst + 1
if str(elem.since()) == str(since):
found = inst
break
db.commitTransaction()
payload = inspect.PayLoad(db, tag, elem)
out = open(filename, 'w')
print(payload, file=out)
except Exception as er:
print(" dumpXML exception ", er)
def plot(db, tag, since, filename='plot.root'):
'''Invoke the plot function from the wrapper and save to the specified \
file. The file format will reflect the extension given.'''
try:
iov = inspect.Iov(db, tag)
db.startReadOnlyTransaction()
Plug = __import__(str(db.payloadModules(tag)[0]))
payload = Plug.Object(db)
listOfIovElem = [iovElem for iovElem in db.iov(tag).elements]
inst = 0
for elem in db.iov(tag).elements:
inst = inst + 1
if str(elem.since()) == str(since):
found = inst
break
db.commitTransaction()
payload = inspect.PayLoad(db, tag, elem)
payload.plot(filename, "", [], [])
except Exception as er:
print(" plot exception ", er)
import os, sys, DLFCN
sys.setdlopenflags(DLFCN.RTLD_GLOBAL + DLFCN.RTLD_LAZY)
from pluginCondDBPyInterface import *
a = FWIncantation()
os.putenv("CORAL_AUTH_PATH", "/afs/cern.ch/cms/DB/conddb")
rdbms = RDBMS()
dbName = "oracle://cms_orcoff_prod/CMS_COND_21X_RUN_INFO"
logName = "oracle://cms_orcoff_prod/CMS_COND_21X_POPCONLOG"
rdbms.setLogger(logName)
from CondCore.Utilities import iovInspector as inspect
db = rdbms.getDB(dbName)
tags = db.allTags()
tag = 'runsummary_test'
try:
log = db.lastLogEntry(tag)
print log.getState()
iov = inspect.Iov(db, tag)
print iov.list()
for x in iov.summaries():
print x[1], x[2], x[3]
# print iov.trend("",[0,2,12])
except RuntimeError:
print " no iov? in", tag
dbName = "oracle://cms_orcoff_prod/CMS_COND_21X_RUN_INFO"
logName = "oracle://cms_orcoff_prod/CMS_COND_21X_POPCONLOG"
rdbms.setLogger(logName)
from CondCore.Utilities import iovInspector as inspect
db = rdbms.getDB(dbName)
tags = db.allTags()
tag = 'l1triggerscaler_test_v2'
try:
log = db.lastLogEntry(tag)
print(log.getState())
#for printing all log info present into log db
#print log.getState()
# for inspecting all payloads/runs
#iov = inspect.Iov(db,tag)
#for inspecting only last payload/run
iov = inspect.Iov(db, tag, 1, 1, 1, 0)
print(iov.list())
for x in iov.summaries():
print(x[1], x[2], x[3])
# print iov.trend("",[0,2,12])
except RuntimeError:
print(" no iov? in", tag)
logName = "oracle://cms_orcoff_prod/CMS_COND_21X_POPCONLOG"
rdbms.setLogger(logName)
from CondCore.Utilities import iovInspector as inspect
db = rdbms.getDB(dbName)
tags = db.allTags()
# for inspecting last run after run has started
tag = 'runstart_test'
# for inspecting last run after run has stopped
#tag = 'runsummary_test'
try:
log = db.lastLogEntry(tag)
#for printing all log info present into log db
#print log.getState()
# for inspecting all payloads/runs
#iov = inspect.Iov(db,tag)
#for inspecting only last payload/run
iov = inspect.Iov(db, tag, 0, 0, 0, 1)
print(iov.list())
for x in iov.summaries():
print(x[1], x[2], x[3])
# print iov.trend("",[0,2,12])
except RuntimeError:
print(" no iov? in", tag)
rdbms = RDBMS()
dbName = "sqlite_file:dati.db"
rdbms = RDBMS("/afs/cern.ch/cms/DB/conddb/")
dbName = "oracle://cms_orcoff_prep/CMS_COND_30X_RPC"
tagPVSS = 'test1'
from CondCore.Utilities import iovInspector as inspect
db = rdbms.getDB(dbName)
tags = db.allTags()
##----------------------- Create assosiacion map for detectors -----------------
##tagPVSS = 'PVSS_v3'
try:
iov = inspect.Iov(db, tagPVSS)
iovlist = iov.list()
print iovlist
detMapName = {}
for p in iovlist:
payload = inspect.PayLoad(db, p[0])
info = payload.summary().split(" ")
i = 0
for e in info:
try:
if int(info[i + 1]) == 0:
detName = "W" + str(info[i + 2]) + "_S" + str(
info[i + 3]) + "_RB" + str(
