dumpRunInfo Namespace Reference

Classes
class	constants

Functions
def	fillnumForRun
def	hltkeyForRun
def	l1keyForRun
def	main

Variables
string	VERSION = '1.02'

Function Documentation

def dumpRunInfo.fillnumForRun	(		dbsession,
			c,
			runnum
	)

select string_value from cms_runinfo.runsession_parameter where runnumber=129265 and name='CMS.SCAL:FILLN' and rownum<=1;

Definition at line 17 of file dumpRunInfo.py.

References AlCaHLTBitMon_QueryRunRegistry.data, and GetRecoTauVFromDQM_MC_cff.next.

Referenced by main().

def fillnumForRun(dbsession,c,runnum):
    '''select string_value from cms_runinfo.runsession_parameter where runnumber=129265 and name='CMS.SCAL:FILLN' and rownum<=1;
    
    '''
    result=''
    try:
        dbsession.transaction().start(True)
        schema=dbsession.schema(c.runinfoschema)
        if not schema:
            raise Exception('cannot connect to schema '+c.runinfoschema)
        if not schema.existsTable(c.runsessionparameterTable):
            raise Exception('non-existing table '+c.runsessionparameterTable)

        fillOutput=coral.AttributeList()
        fillOutput.extend("fillnum","string")
        
        bindVarList=coral.AttributeList()
        bindVarList.extend("name","string")
        bindVarList.extend("runnumber","unsigned int")

        bindVarList["name"].setData(c.fillnumname)
        bindVarList["runnumber"].setData(int(runnum))
        
        query=schema.newQuery()
        query.addToTableList(c.runsessionparameterTable)
        query.addToOutputList('STRING_VALUE','value')
        query.setCondition('NAME=:name AND RUNNUMBER=:runnumber',bindVarList)
        query.limitReturnedRows(1)
        query.defineOutput(fillOutput)
        
        cursor=query.execute()
        while next(cursor):
            result=cursor.currentRow()['fillnum'].data()
        del query
        dbsession.transaction().commit()
        #print result
        return result
    except Exception as e:
        print str(e)
        dbsession.transaction().rollback()
        del dbsession