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={}
if runnum in beamstatusdata:
beamsta=beamstatusdata[runnum]
alllumilsdata[runnum]=generateLumiLSdataForRun(perrundata,alllumirundata[runnum],beamsta)#lumirundata [datasource,nominalenergy,ncollidingbunches,starttime,stoptime,nls]
pixellumirundata=alllumirundata[runnum]
(pixellumirevid,pixellumientryid,pixellumidataid)=dataDML.addLumiRunDataToBranch(session.nominalSchema(),runnum,pixellumirundata,pixellumibranchinfo,nameDealer.pixellumidataTableName())
pixellumilsdata=alllumilsdata[runnum]
revisionDML.addRunToCurrentDataTag(session.nominalSchema(),runnum,pixellumidataid,trgdataid,hltdataid,lumitype='PIXEL')
session.transaction().commit()
dataDML.bulkInsertLumiLSSummary(session,runnum,pixellumidataid,pixellumilsdata,nameDealer.pixellumisummaryv2TableName(),withDetails=False)
del session
del svc
hfdataidmap[int(options.runnum)])
destsession.transaction().start(False)
[destlumidataid, desttrgdataid,
desthltdataid] = hfdataidmap[int(options.runnum)]
(lumirevid, lumientryid, lumidataid) = dataDML.addLumiRunDataToBranch(
destsession.nominalSchema(), int(options.runnum), rundat,
branchinfo, nameDealer.lumidataTableName())
dataDML.bulkInsertLumiLSSummary(destsession, int(options.runnum),
lumidataid, lsdat,
nameDealer.lumisummaryv2TableName())
destsession.transaction().commit()
destsession.transaction().start(False)
revisionDML.addRunToCurrentDataTag(destsession.nominalSchema(),
int(options.runnum),
lumidataid,
desttrgdataid,
desthltdataid,
lumitype='HF',
comment=options.comment)
destsession.transaction().commit()
else:
print('non-existing old hf data in destdb of run ',
int(options.runnum))
destsession.transaction().start(False)
(lumirevid, lumientryid, lumidataid) = dataDML.addLumiRunDataToBranch(
destsession.nominalSchema(), int(options.runnum), rundat,
branchinfo, nameDealer.lumidataTableName())
print((lumirevid, lumientryid, lumidataid))
dataDML.bulkInsertLumiLSSummary(destsession, int(options.runnum),
lumidataid, lsdat,
nameDealer.lumisummaryv2TableName())
hltdataid = hfdataidinfo[2]
beamsta = {}
if beamstatusdata.has_key(runnum):
beamsta = beamstatusdata[runnum]
alllumilsdata[runnum] = generateLumiLSdataForRun(
perrundata, alllumirundata[runnum], beamsta
) #lumirundata [datasource,nominalenergy,ncollidingbunches,starttime,stoptime,nls]
pixellumirundata = alllumirundata[runnum]
(pixellumirevid, pixellumientryid,
pixellumidataid) = dataDML.addLumiRunDataToBranch(
session.nominalSchema(), runnum, pixellumirundata,
pixellumibranchinfo, nameDealer.pixellumidataTableName())
pixellumilsdata = alllumilsdata[runnum]
revisionDML.addRunToCurrentDataTag(session.nominalSchema(),
runnum,
pixellumidataid,
trgdataid,
hltdataid,
lumitype='PIXEL')
session.transaction().commit()
dataDML.bulkInsertLumiLSSummary(
session,
runnum,
pixellumidataid,
pixellumilsdata,
nameDealer.pixellumisummaryv2TableName(),
withDetails=False)
del session
del svc
(hf_tagid,hf_tagname)=revisionDML.currentDataTag(destsession.nominalSchema(),lumitype='HF')
print('(hf_tagid,hf_tagname) ',(hf_tagid,hf_tagname))
hfdataidmap=revisionDML.dataIdsByTagId(destsession.nominalSchema(),hf_tagid,[int(options.runnum)],withcomment=False,lumitype='HF')
destsession.transaction().commit()
print('dest hfdataidmap ',hfdataidmap)
if int(options.runnum) in hfdataidmap:
print('existing old hf data in destdb of run ',options.runnum,hfdataidmap[int(options.runnum)])
destsession.transaction().start(False)
[destlumidataid,desttrgdataid,desthltdataid]=hfdataidmap[int(options.runnum)]
(lumirevid,lumientryid,lumidataid)=dataDML.addLumiRunDataToBranch(destsession.nominalSchema(),int(options.runnum),rundat,branchinfo,nameDealer.lumidataTableName())
dataDML.bulkInsertLumiLSSummary(destsession,int(options.runnum),lumidataid,lsdat,nameDealer.lumisummaryv2TableName())
destsession.transaction().commit()
destsession.transaction().start(False)
revisionDML.addRunToCurrentDataTag(destsession.nominalSchema(),int(options.runnum),lumidataid,desttrgdataid,desthltdataid,lumitype='HF',comment=options.comment)
destsession.transaction().commit()
else:
print('non-existing old hf data in destdb of run ',int(options.runnum))
destsession.transaction().start(False)
(lumirevid,lumientryid,lumidataid)=dataDML.addLumiRunDataToBranch(destsession.nominalSchema(),int(options.runnum),rundat,branchinfo,nameDealer.lumidataTableName())
print((lumirevid,lumientryid,lumidataid))
dataDML.bulkInsertLumiLSSummary(destsession,int(options.runnum),lumidataid,lsdat,nameDealer.lumisummaryv2TableName())
destsession.transaction().commit()
destsession.transaction().start(False)
revisionDML.addRunToCurrentDataTag(destsession.nominalSchema(),int(options.runnum),lumidataid,0,0,lumitype='HF',comment=options.comment)
destsession.transaction().commit()
del sourcesession
del sourcesvc
del destsession