def runsummary(schema,irunlsdict): ''' output [[run(0),l1key(1),amodetag(2),egev(3),hltkey(4),fillnum(5),fillscheme(6),starttime(7),stoptime(8)]] ''' result=[] for run in sorted(irunlsdict): runinfo=dataDML.runsummary(schema,run) runinfo.insert(0,run) result.append(runinfo) return result
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()) for lsnum in lumils: print('lumilsnum,cmslsnum,instlumi ', lsnum, lumiLSdata[lsnum][0], lumiLSdata[lsnum][1] * normval) (runnum, trgLSdata) = dataDML.trgLSById(schema, trgdataid)