Exemple #1
0
 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)
Exemple #2
0
         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]
Exemple #3
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']
Exemple #4
0
                 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())
Exemple #5
0
                 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())
Exemple #6
0
 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)