dataDML.py File Reference

Go to the source code of this file.

Namespaces
	dataDML

Functions
def	dataDML.addCorrToBranch
def	dataDML.addHLTRunDataToBranch
def	dataDML.addLumiRunDataToBranch
def	dataDML.addNormToBranch
def	dataDML.addTrgRunDataToBranch
def	dataDML.allfillschemes
def	dataDML.beamInfoById
def	dataDML.beamstatusByIds
def	dataDML.bulkInsertHltLSData
def	dataDML.bulkInsertLumiLSSummary
def	dataDML.bulkInsertTrgLSData
def	dataDML.dataentryIdByRun
def	dataDML.fillInRange
def	dataDML.fillrunMap
def	dataDML.fillschemePatternMap
def	dataDML.guesscorrIdByName
	LumiDB DML API # # Author: Zhen Xie #. More...
def	dataDML.guessDataIdByRun
def	dataDML.guessDataIdForRange
def	dataDML.guessHltDataIdByRunInBranch
def	dataDML.guessLumiDataIdByRunInBranch
def	dataDML.guessnormIdByContext
def	dataDML.guessnormIdByName
def	dataDML.guessTrgDataIdByRunInBranch
def	dataDML.hltLSById
def	dataDML.hltRunById
def	dataDML.hlttrgMappingByrun
def	dataDML.insertRunSummaryData
def	dataDML.insertTrgHltMap
def	dataDML.intglumiForRange
def	dataDML.latestdataIdByEntry
def	dataDML.lumiBXByAlgo
def	dataDML.lumicorrById
def	dataDML.lumiLSById
def	dataDML.luminormById
def	dataDML.lumiRunById
def	dataDML.lumiRunByIds
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')