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(