dataDML.py File Reference

Go to the source code of this file.

Namespaces
	dataDML

Functions
def	dataDML.addHLTRunDataToBranch
def	dataDML.addLumiRunDataToBranch
def	dataDML.addNormToBranch
def	dataDML.addTrgRunDataToBranch
def	dataDML.beamInfoById
def	dataDML.bulkInsertHltLSData
def	dataDML.bulkInsertLumiLSSummary
def	dataDML.bulkInsertTrgLSData
def	dataDML.dataentryIdByRun
def	dataDML.guessDataIdByRun
def	dataDML.guessnormIdByContext
def	dataDML.guessnormIdByName
def	dataDML.hltLSById
def	dataDML.hltRunById
def	dataDML.hlttrgMappingByrun
def	dataDML.insertRunSummaryData
def	dataDML.insertTrgHltMap
def	dataDML.latestdataIdByEntry
def	dataDML.lumiBXByAlgo
def	dataDML.lumiLSById
def	dataDML.luminormById
def	dataDML.lumiRunById
def	dataDML.mostRecentLuminorms
def	dataDML.runList
def	dataDML.runsummary
def	dataDML.trgLSById
def	dataDML.trgRunById

Variables
tuple	dataDML.branchinfo = (branchid,'DATA')
tuple	dataDML.datainfo = revisionDML.createBranch(schema,'DATA','TRUNK',comment='hold data')
tuple	dataDML.hltdata = generateDummyData.hlt(schema,20)
list	dataDML.hltlsdata = hltdata[2]
list	dataDML.hltrundata = [hltdata[0],hltdata[1]]
tuple	dataDML.hlttrgmap = generateDummyData.hlttrgmap(schema)
tuple	dataDML.latestNorms = revisionDML.latestDataRevisionOfEntry(schema,nameDealer.luminormTableName(),luminormentry_id,normrevlist)
tuple	dataDML.latestrevision = revisionDML.latestDataRevisionOfEntry(schema,nameDealer.lumidataTableName(),lumientry_id,revlist)
tuple	dataDML.lumidummydata = generateDummyData.lumiSummary(schema,20)
tuple	dataDML.lumientry_id = revisionDML.entryInBranch(schema,nameDealer.lumidataTableName(),'1211','DATA')
list	dataDML.lumilsdata = lumidummydata[1]
tuple	dataDML.luminormentry_id = revisionDML.entryInBranch(schema,nameDealer.luminormTableName(),'pp7TeV','NORM')
list	dataDML.lumirundata = [lumidummydata[0]]
string	dataDML.myconstr = 'oracle://devdb10/cms_xiezhen_dev'
tuple	dataDML.normbranchinfo = (normbranchid,'NORM')
tuple	dataDML.norminfo = revisionDML.createBranch(schema,'NORM','TRUNK',comment='hold normalization factor')
tuple	dataDML.normrevlist = revisionDML.revisionsInBranchName(schema,'NORM')
tuple	dataDML.revlist = revisionDML.revisionsInBranchName(schema,'DATA')
tuple	dataDML.runsummarydata = generateDummyData.runsummary(schema,'PROTPHYS',3500)
tuple	dataDML.schema = session.nominalSchema()
tuple	dataDML.session = svc.openSession(isReadOnly=False,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')])
tuple	dataDML.svc = sessionManager.sessionManager(myconstr,authpath='/afs/cern.ch/user/x/xiezhen',debugON=False)
tuple	dataDML.tables = lumidbDDL.createTables(schema)
tuple	dataDML.trgdata = generateDummyData.trg(schema,20)
tuple	dataDML.trgentry_id = revisionDML.entryInBranch(schema,nameDealer.trgdataTableName(),'1222','DATA')
list	dataDML.trglsdata = trgdata[3]
list	dataDML.trgrundata = [trgdata[0],trgdata[1],trgdata[2]]
tuple	dataDML.trunkinfo = revisionDML.createBranch(schema,'TRUNK',None,comment='main')