Utilities/test/listTags.py

0001 import DLFCN, sys, os, time
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
0008
0009
0010 # rdbms = RDBMS()
0011 rdbms = RDBMS("/afs/cern.ch/cms/DB/conddb")
0012 logName = "oracle://cms_orcoff_prod/CMS_COND_31X_POPCONLOG"
0013 gdbName = "oracle://cms_orcoff_prod/CMS_COND_31X_GLOBALTAG"
0014 # gName = "GR09_31X_V6P::All"
0015 gName = 'CRAFT09_R_V9::All'
0016 #gName = 'STARTUP3X_V8F::All'
0017 rdbms.setLogger(logName)
0018 #globalTag = rdbms.globalTag(gdbName,gName,"","")
0019 # globalTag = rdbms.globalTag(gdbName,gName,"oracle://cms_orcoff_prod/","")
0020 globalTag = rdbms.globalTag(gdbName,gName,"frontier://FrontierArc/","_0911")
0021
0022 for tag in globalTag.elements:
0023 #    dbname = tag.pfn[tag.pfn.rfind('/'):]
0024 #    db_o = rdbms.getDB("oracle://cms_orcoff_prod"+dbname)
0025     db = rdbms.getDB(tag.pfn)
0026     log = db.lastLogEntry(tag.tag)
0027     iov = db.iov(tag.tag)
0028     iov.tail(1)
0029     for elem in iov.elements :
0030         lastSince = elem.since()
0031     print(tag.record,tag.label,tag.pfn,tag.tag)
0032     print(iov.size(), iov.revision(), time.asctime(time.gmtime(unpackTime(iov.timestamp())[0])), iov.comment(), lastSince)
0033     print(log.getState())
0034     iov=0
0035     db=0
0036
0037
0038 def iovSize(rdbms,conn,tag) :
0039     try :
0040         db = rdbms.getDB(conn)
0041         log = db.lastLogEntry(tag)
0042         iov = db.iov(tag)
0043         size = iov.size()
0044         for elem in iov.elements :
0045             if (elem.till()>4294967295) :
0046                 print(tag, elem.since(), elem.till(), elem.payloadToken())
0047     except RuntimeError :
0048         print(conn, tag," no iov?")
0049         size=-1
0050     iov=0
0051     db=0
0052     return size
0053
0054
0055
0056