debugON=options.debug) session=svc.openSession(isReadOnly=False,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')]) inputfilename=os.path.abspath(options.inputfile) parseresult=parseInputFile(inputfilename,options.singlerun) runlist=parseresult.keys() irunlsdict={} for run in runlist: irunlsdict[run]=None session.transaction().start(True) (pixellumibranchid,pixellumibranchparent)=revisionDML.branchInfoByName(session.nominalSchema(),'DATA') print 'pixellumibranchid ',pixellumibranchid,' pixellumibranchparent ',pixellumibranchparent pixellumibranchinfo=(pixellumibranchid,'DATA') (pixel_tagid,pixel_tagname)=revisionDML.currentDataTag(session.nominalSchema(),lumitype='PIXEL') (hf_tagid,hf_tagname)=revisionDML.currentDataTag(session.nominalSchema(),lumitype='HF') hfdataidmap=revisionDML.dataIdsByTagId(session.nominalSchema(),hf_tagid,runlist,withcomment=False,lumitype='HF') beamstatusdata=dataDML.beamstatusByIds(session.nominalSchema(),hfdataidmap) #print 'beamstatusdata ',beamstatusdata lumirundata=dataDML.lumiRunByIds(session.nominalSchema(),hfdataidmap,lumitype='HF')#{runnum: (nominalegev(0),ncollidingbunches(1),starttime(2),stoptime(3),nls(4)} session.transaction().commit() #print 'lumirundata ', lumirundata alllumirundata=generateLumiRundata(inputfilename,lumirundata,runlist) alllumilsdata={} for runnum,perrundata in parseresult.items(): pixellumidataid=0 session.transaction().start(False) #session.transaction().start(True) hfdataidinfo=hfdataidmap[runnum] hflumidataid=hfdataidinfo[0] trgdataid=hfdataidinfo[1] hltdataid=hfdataidinfo[2] beamsta={}
(pixellumibranchid, pixellumibranchparent) = revisionDML.branchInfoByName( session.nominalSchema(), 'DATA') print 'pixellumibranchid ', pixellumibranchid, ' pixellumibranchparent ', pixellumibranchparent pixellumibranchinfo = (pixellumibranchid, 'DATA') (pixel_tagid, pixel_tagname) = revisionDML.currentDataTag(session.nominalSchema(), lumitype='PIXEL') (hf_tagid, hf_tagname) = revisionDML.currentDataTag(session.nominalSchema(), lumitype='HF') hfdataidmap = revisionDML.dataIdsByTagId(session.nominalSchema(), hf_tagid, runlist, withcomment=False, lumitype='HF') beamstatusdata = dataDML.beamstatusByIds(session.nominalSchema(), hfdataidmap) #print 'beamstatusdata ',beamstatusdata lumirundata = dataDML.lumiRunByIds( session.nominalSchema(), hfdataidmap, lumitype='HF' ) #{runnum: (nominalegev(0),ncollidingbunches(1),starttime(2),stoptime(3),nls(4)} session.transaction().commit() #print 'lumirundata ', lumirundata alllumirundata = generateLumiRundata(inputfilename, lumirundata, runlist) alllumilsdata = {} for runnum, perrundata in parseresult.items(): pixellumidataid = 0 session.transaction().start(False) #session.transaction().start(True) hfdataidinfo = hfdataidmap[runnum] hflumidataid = hfdataidinfo[0] trgdataid = hfdataidinfo[1]