EcalPlugins/test/inspect.py

0001 from __future__ import print_function
0002 #
0003 # I should write a decent test of the python binding...
0004 #
0005 def dumpSummaries(dbname):
0006     db = rdbms.getDB(dbName)
0007     tags = db.allTags()
0008
0009     for tag in tags.split() :
0010         try :
0011             #        log = db.lastLogEntry(tag)
0012             #        print log.getState()
0013             iov = inspect.Iov(db,tag)
0014             for x in  iov.summaries():
0015                 print(x[1],x[2],x[3])
0016             #        print iov.trend("",[0,2,12])
0017         except RuntimeError :
0018             print(" no iov? in", tag)
0019
0020     iov=0
0021
0022 def dumpContents(dbname):
0023     db = rdbms.getDB(dbName)
0024     tags = db.allTags()
0025
0026     for tag in tags.split() :
0027         try :
0028             iov = inspect.Iov(db,tag)
0029             for x in  iov.list():
0030                 print(x[1],x[2])
0031                 print(inspect.PayLoad(db,x[0]))
0032         except RuntimeError :
0033             print(" no iov? in", tag)
0034
0035     iov=0
0036
0037
0038
0039 import sys, os, DLFCN
0040 sys.setdlopenflags(DLFCN.RTLD_GLOBAL+DLFCN.RTLD_LAZY)
0041
0042 from pluginCondDBPyInterface import *
0043 a = FWIncantation()
0044 os.putenv("CORAL_AUTH_PATH","/afs/cern.ch/cms/DB/conddb")
0045 rdbms = RDBMS()
0046
0047 dbName = "sqlite_file:testExample.db"
0048
0049 # dbName =  "oracle://cms_orcoff_prod/CMS_COND_20X_ECAL"
0050 #logName = "oracle://cms_orcoff_prod/CMS_COND_21X_POPCONLOG"
0051
0052 #rdbms.setLogger(logName)
0053 from CondCore.Utilities import iovInspector as inspect
0054
0055 dumpSummaries(dbName)
0056 dumpContents(dbName)