parser.add_argument('--debug',dest='debug',action='store_true', help='debug' ) options=parser.parse_args() svc=sessionManager.sessionManager(options.connect, authpath=options.authpath, 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)
raise RuntimeError('argument -P authpath is required for add action') if not options.input: raise RuntimeError('argument -input input is required for add action') if not options.name: raise RuntimeError('argument -name name is required for add action') svc=sessionManager.sessionManager(options.connect,authpath=options.authpath,siteconfpath=options.siteconfpath) session=None if options.action=='add': session=svc.openSession(isReadOnly=False,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')]) # # add norm factor # session.transaction().start(False) schema=session.nominalSchema() (revision_id,branch_id)=revisionDML.branchInfoByName(schema,'NORM') dataDML.addNormToBranch(schema,options.name,options.amodetag,float(options.input),int(options.egev),{},(revision_id,'NORM')) session.transaction().commit() elif options.action=='list': session=svc.openSession(isReadOnly=True,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')]) session.transaction().start(True) schema=session.nominalSchema() if options.tag is None:#ask for the latest of name if options.name is None and options.amodetag is None and options.egev is None: branchfilter=revisionDML.revisionsInBranchName(schema,'NORM') allnorms=dataDML.mostRecentLuminorms(schema,branchfilter) lumiReport.toScreenNorm(allnorms) elif options.name is not None: normdataid=dataDML.guessnormIdByName(schema,options.name) norm=dataDML.luminormById(schema,normdataid) nname=norm[0]
raise RuntimeError('[ERROR] normname undefined') lumitype='HF' if options.lumitype: lumitype=options.lumitype else: if 'lumitype' in normdefinitionDict and normdefinitionDict['lumitype']: lumitype=normdefinitionDict['lumitype'] istypedefault=0 if 'istypedefault' in normdefinitionDict and normdefinitionDict['istypedefault']: istypedefault=int(normdefinitionDict['istypedefault']) commentStr='' if 'comment' in normdefinitionDict: commentStr=normdefinitionDict['comment'] if options.action=='create': (revision_id,branch_id)=revisionDML.branchInfoByName(dbsession.nominalSchema(),'NORM') branchinfo=(revision_id,'NORM') (normrev_id,normentry_id,normdata_id)=normDML.createNorm(dbsession.nominalSchema(),normname,lumitype,istypedefault,branchinfo,comment=commentStr) else: normdata_id=normDML.normIdByName(dbsession.nominalSchema(),normname) for normvalueDict in normvalues: if 'corrector' not in normvalueDict or not normvalueDict['corrector']: raise RuntimeError('parameter corrector is required for create/insert action') if 'since' not in normvalueDict or not normvalueDict['since']: raise RuntimeError('parameter since is required for create/insert action') correctorStr=normvalueDict['corrector'] sincerun=int(normvalueDict['since']) if options.firstsince: if sincerun<int(options.firstsince): continue amodetag=normvalueDict['amodetag']
sourcelumiid=cursor.currentRow()['LUMIDATAID'].data() del qHandle except: if qHandle:del qHandle raise lumirundatafromdb=[] lumilsdatafromdb={} if sourcelumiid: (lumirundatafromdb,lumilsdatafromdb)=lumiDataFromDB(sourcesession.nominalSchema(),sourcelumiid) sourcesession.transaction().commit() (rundat,lsdat)=generateLumidata(lumidatafromfile[0],lumidatafromfile[1],lumirundatafromdb,lumilsdatafromdb,begLS,endLS) print('rundat ',rundat) destsvc=sessionManager.sessionManager(options.deststr,authpath=options.authpath,debugON=False) destsession=destsvc.openSession(isReadOnly=False,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')]) destsession.transaction().start(False) (lumibranchid,lumibranchparent)=revisionDML.branchInfoByName(destsession.nominalSchema(),'DATA') branchinfo=(lumibranchid,'DATA') print('branchinfo ',branchinfo) (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())
sourcelumiid=cursor.currentRow()['LUMIDATAID'].data() del qHandle except: if qHandle:del qHandle raise lumirundatafromdb=[] lumilsdatafromdb={} if sourcelumiid: (lumirundatafromdb,lumilsdatafromdb)=lumiDataFromDB(sourcesession.nominalSchema(),sourcelumiid) sourcesession.transaction().commit() (rundat,lsdat)=generateLumidata(lumidatafromfile[0],lumidatafromfile[1],lumirundatafromdb,lumilsdatafromdb,begLS,endLS) print 'rundat ',rundat destsvc=sessionManager.sessionManager(options.deststr,authpath=options.authpath,debugON=False) destsession=destsvc.openSession(isReadOnly=False,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')]) destsession.transaction().start(False) (lumibranchid,lumibranchparent)=revisionDML.branchInfoByName(destsession.nominalSchema(),'DATA') branchinfo=(lumibranchid,'DATA') print 'branchinfo ',branchinfo (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())
options = parser.parse_args() svc = sessionManager.sessionManager(options.connect, authpath=options.authpath, 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)