def runList(schema,
fillnum=None,
runmin=None,
runmax=None,
fillmin=None,
fillmax=None,
startT=None,
stopT=None,
l1keyPattern=None,
hltkeyPattern=None,
amodetag=None,
nominalEnergy=None,
energyFlut=0.2,
requiretrg=True,
requirehlt=True,
lumitype='HF'):
'''
output: [runnumber,...]
'''
return dataDML.runList(schema,
fillnum=fillnum,
runmin=runmin,
runmax=runmax,
fillmin=None,
fillmax=None,
startT=startT,
stopT=stopT,
l1keyPattern=l1keyPattern,
hltkeyPattern=hltkeyPattern,
amodetag=amodetag,
nominalEnergy=nominalEnergy,
energyFlut=energyFlut,
requiretrg=requiretrg,
requirehlt=requirehlt,
lumitype=lumitype)
DATABRANCH_ID = 3
if __name__ == '__main__':
myconstr = 'oracle://cms_orcoff_prod/cms_lumi_prod'
svc = sessionManager.sessionManager(myconstr,
authpath='/afs/cern.ch/user/x/xiezhen',
debugON=False)
session = svc.openSession(isReadOnly=True,
cpp2sqltype=[('unsigned int', 'NUMBER(10)'),
('unsigned long long', 'NUMBER(20)')
])
session.transaction().start(True)
schema = session.nominalSchema()
runs = dataDML.runList(schema,
fillnum=1616,
runmin=160403,
runmax=160957,
nominalEnergy=3500.0)
print(runs)
myrun = runs[0]
runsummary = dataDML.runsummary(schema, myrun)
print(runsummary)
normid = dataDML.guessnormIdByContext(schema, 'PROTPHYS', 3500)
normval = dataDML.luminormById(schema, normid)[2]
print('norm in use ', normval)
(lumidataid, trgdataid,
hltdataid) = dataDML.guessDataIdByRun(schema, myrun)
print('all dataids ', lumidataid, trgdataid, hltdataid)
(runnum, lumiLSdata) = dataDML.lumiLSById(schema, lumidataid)
lumils = sorted(lumiLSdata.keys())
def runList(schema,datatagid,runmin=None,runmax=None,fillmin=None,fillmax=None,startT=None,stopT=None,l1keyPattern=None,hltkeyPattern=None,amodetag=None,nominalEnergy=None,energyFlut=0.2,requiretrg=True,requirehlt=True,preselectedruns=None,lumitype='HF'):
'''
output: [runnumber,...]
'''
return dataDML.runList(schema,datatagid,runmin=runmin,runmax=runmax,fillmin=fillmin,fillmax=fillmax,startT=startT,stopT=stopT,l1keyPattern=l1keyPattern,hltkeyPattern=hltkeyPattern,amodetag=amodetag,nominalEnergy=nominalEnergy,energyFlut=energyFlut,requiretrg=requiretrg,requirehlt=requirehlt,lumitype=lumitype)
#!/usr/bin/env python
VERSION='2.00'
import os,sys,array
import coral
from RecoLuminosity.LumiDB import sessionManager,dataDML,CommonUtil
DATABRANCH_ID=3
if __name__=='__main__':
myconstr='oracle://cms_orcoff_prod/cms_lumi_prod'
svc=sessionManager.sessionManager(myconstr,authpath='/afs/cern.ch/user/x/xiezhen',debugON=False)
session=svc.openSession(isReadOnly=True,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')])
session.transaction().start(True)
schema=session.nominalSchema()
runs=dataDML.runList(schema,fillnum=1616,runmin=160403,runmax=160957,nominalEnergy=3500.0)
print runs
myrun=runs[0]
runsummary=dataDML.runsummary(schema,myrun)
print runsummary
normid=dataDML.guessnormIdByContext(schema,'PROTPHYS',3500)
normval=dataDML.luminormById(schema,normid)[2]
print 'norm in use ',normval
(lumidataid,trgdataid,hltdataid)=dataDML.guessDataIdByRun(schema,myrun)
print 'all dataids ',lumidataid,trgdataid,hltdataid
(runnum,lumiLSdata)=dataDML.lumiLSById(schema,lumidataid)
lumils=lumiLSdata.keys()
lumils.sort()
for lsnum in lumils:
print 'lumilsnum,cmslsnum,instlumi ',lsnum,lumiLSdata[lsnum][0],lumiLSdata[lsnum][1]*normval
(runnum,trgLSdata)=dataDML.trgLSById(schema,trgdataid)
cmsls=trgLSdata.keys()
def runList(schema,fillnum=None,runmin=None,runmax=None,startT=None,stopT=None,l1keyPattern=None,hltkeyPattern=None,amodetag=None,nominalEnergy=None,energyFlut=0.2,requiretrg=True,requirehlt=True,lumitype='HF'):
'''
output: [runnumber,...]
'''
return dataDML.runList(schema,fillnum,runmin,runmax,startT,stopT,l1keyPattern,hltkeyPattern,amodetag,nominalEnergy,energyFlut,requiretrg,requirehlt,lumitype)
