Functions
	usage ()

Variables
str	letters = "hi:o:t:f:d:S:v:V:c:r:l:u"
list	keywords = ["help","infile=","outfile=","tag=","folder=","dbname=","server=","value=","value2=","channel=","run=","lumi=","update"]
	opts
	extraparams
str	inFile = 'COOLOFL_CALO/CONDBR2'
str	outFile = 'caloSqlite.db'
str	tag = ''
str	folderPath = ''
str	dbName = 'CONDBR2'
str	server = ''
	value = None
int	value2 = 0
int	run = -1
int	lumi = 0
bool	update = False
list	channels = [0,1]
	a = a.strip()
	log = CaloCondLogger.getLogger("WriteLumi")
str	ischema = 'sqlite://;schema='+inFile+';dbname='+dbName
str	oschema = 'sqlite://;schema='+outFile+';dbname='+dbName
	dbr = CaloCondTools.openDbConn(ischema,server)
	dbw = CaloCondTools.openDbConn(oschema,('UPDATE' if update else 'RECREATE'))
	folderTag = TileCalibTools.getFolderTag(dbr, folderPath, tag )
	spec = cool.RecordSpecification()
tuple	multiVersion = (len(folderTag)>0)
	folderMode = cool.FolderVersioning.MULTI_VERSION
	folderSpec = cool.FolderSpecification(folderMode, spec)
	folderDescr = CaloCondTools.getAthenaFolderDescr()
	folderR = dbr.getFolder(folderPath)
	folderW = dbw.getFolder(folderPath)
	newval1 = float(value)
	newval2 = int(value2)
str	newiov = "[%d,%d] - infinity" % (run, lumi)
	since = CaloCondTools.iovFromRunLumi( run, lumi )
	until = CaloCondTools.iovFromRunLumi( CaloCondTools.MAXRUN, CaloCondTools.MAXLBK )
	obj = folderR.findObject( since, chan, folderTag )
	sinceRun
	sinceLum
	untilRun
	untilLum
	val1 = obj.payload()[0]
	val2 = obj.payload()[1]
str	oldiov = "[%d,%d] - (%d,%d)" % (sinceRun,sinceLum,untilRun,untilLum)
	data = cool.Record( spec )

Function Documentation

◆ usage()

WriteLumiToCool.usage ( )

Definition at line 14 of file WriteLumiToCool.py.

def usage():
    print ("Usage: ",sys.argv[0]," [OPTION] ... ")
    print ("Prepare sqlite file with Lumi values for CALO database")
    print ("")
    print ("-h, --help      shows this help")
    print ("-i, --infile=   specify the input sqlite file for comparison or full schema string")
    print ("-o, --outfile=  specify the output sqlite file")
    print ("-t, --tag=      specify the tag")
    print ("-f, --folder=   specify folder to use e.g. /CALO/Ofl/Noise/PileUpNoiseLumi ")
    print ("-d, --dbname=   specify the database name e.g. OFLP200")
    print ("-S, --server=   specify server - ORACLE or FRONTIER, default is FRONTIER")
    print ("-v, --value=    specify new lumi value")
    print ("-V, --value2=   specify new valid flag")
    print ("-c, --channel=  specify COOL channel, by default COOL channels 0 and 1 are used")
    print ("-r, --run=      specify run number for start of IOV")
    print ("-l, --lumi=     specify lumiblock number for start of IOV, default is 0")
    print ("-u  --update    set this flag if output sqlite file should be updated, otherwise it'll be recreated")
 

Variable Documentation

◆ a

WriteLumiToCool.a = a.strip()

Definition at line 57 of file WriteLumiToCool.py.

◆ channels

list WriteLumiToCool.channels = [0,1]

Definition at line 54 of file WriteLumiToCool.py.

◆ data

WriteLumiToCool.data = cool.Record( spec )

Definition at line 197 of file WriteLumiToCool.py.

◆ dbName

WriteLumiToCool.dbName = 'CONDBR2'

Definition at line 47 of file WriteLumiToCool.py.

◆ dbr

WriteLumiToCool.dbr = CaloCondTools.openDbConn(ischema,server)

Definition at line 128 of file WriteLumiToCool.py.

◆ dbw

WriteLumiToCool.dbw = CaloCondTools.openDbConn(oschema,('UPDATE' if update else 'RECREATE'))

Definition at line 130 of file WriteLumiToCool.py.

◆ extraparams

WriteLumiToCool.extraparams

Definition at line 36 of file WriteLumiToCool.py.

◆ folderDescr

WriteLumiToCool.folderDescr = CaloCondTools.getAthenaFolderDescr()

Definition at line 163 of file WriteLumiToCool.py.

◆ folderMode

WriteLumiToCool.folderMode = cool.FolderVersioning.MULTI_VERSION

Definition at line 156 of file WriteLumiToCool.py.

◆ folderPath

str WriteLumiToCool.folderPath = ''

Definition at line 46 of file WriteLumiToCool.py.

◆ folderR

WriteLumiToCool.folderR = dbr.getFolder(folderPath)

Definition at line 164 of file WriteLumiToCool.py.

◆ folderSpec

WriteLumiToCool.folderSpec = cool.FolderSpecification(folderMode, spec)

Definition at line 157 of file WriteLumiToCool.py.

◆ folderTag

str WriteLumiToCool.folderTag = TileCalibTools.getFolderTag(dbr, folderPath, tag )

Definition at line 140 of file WriteLumiToCool.py.

◆ folderW

WriteLumiToCool.folderW = dbw.getFolder(folderPath)

Definition at line 167 of file WriteLumiToCool.py.

◆ inFile

WriteLumiToCool.inFile = 'COOLOFL_CALO/CONDBR2'

Definition at line 43 of file WriteLumiToCool.py.

◆ ischema

str WriteLumiToCool.ischema = 'sqlite://;schema='+inFile+';dbname='+dbName

Definition at line 119 of file WriteLumiToCool.py.

◆ keywords

list WriteLumiToCool.keywords = ["help","infile=","outfile=","tag=","folder=","dbname=","server=","value=","value2=","channel=","run=","lumi=","update"]

Definition at line 33 of file WriteLumiToCool.py.

◆ letters

str WriteLumiToCool.letters = "hi:o:t:f:d:S:v:V:c:r:l:u"

Definition at line 32 of file WriteLumiToCool.py.

◆ log

WriteLumiToCool.log = CaloCondLogger.getLogger("WriteLumi")

Definition at line 109 of file WriteLumiToCool.py.

◆ lumi

WriteLumiToCool.lumi = 0

Definition at line 52 of file WriteLumiToCool.py.

◆ multiVersion

tuple WriteLumiToCool.multiVersion = (len(folderTag)>0)

Definition at line 153 of file WriteLumiToCool.py.

◆ newiov

str WriteLumiToCool.newiov = "[%d,%d] - infinity" % (run, lumi)

Definition at line 175 of file WriteLumiToCool.py.

◆ newval1

WriteLumiToCool.newval1 = float(value)

Definition at line 173 of file WriteLumiToCool.py.

◆ newval2

WriteLumiToCool.newval2 = int(value2)

Definition at line 174 of file WriteLumiToCool.py.

◆ obj

WriteLumiToCool.obj = folderR.findObject( since, chan, folderTag )

Definition at line 181 of file WriteLumiToCool.py.

◆ oldiov

str WriteLumiToCool.oldiov = "[%d,%d] - (%d,%d)" % (sinceRun,sinceLum,untilRun,untilLum)

Definition at line 186 of file WriteLumiToCool.py.

◆ opts

WriteLumiToCool.opts

Definition at line 36 of file WriteLumiToCool.py.

◆ oschema

str WriteLumiToCool.oschema = 'sqlite://;schema='+outFile+';dbname='+dbName

Definition at line 127 of file WriteLumiToCool.py.

◆ outFile

WriteLumiToCool.outFile = 'caloSqlite.db'

Definition at line 44 of file WriteLumiToCool.py.

◆ run

WriteLumiToCool.run = -1

Definition at line 51 of file WriteLumiToCool.py.

◆ server

WriteLumiToCool.server = ''

Definition at line 48 of file WriteLumiToCool.py.

◆ since

WriteLumiToCool.since = CaloCondTools.iovFromRunLumi( run, lumi )

Definition at line 176 of file WriteLumiToCool.py.

◆ sinceLum

WriteLumiToCool.sinceLum

Definition at line 182 of file WriteLumiToCool.py.

◆ sinceRun

WriteLumiToCool.sinceRun

Definition at line 182 of file WriteLumiToCool.py.

◆ spec

WriteLumiToCool.spec = cool.RecordSpecification()

Definition at line 149 of file WriteLumiToCool.py.

◆ tag

str WriteLumiToCool.tag = ''

Definition at line 45 of file WriteLumiToCool.py.

◆ until

WriteLumiToCool.until = CaloCondTools.iovFromRunLumi( CaloCondTools.MAXRUN, CaloCondTools.MAXLBK )

Definition at line 177 of file WriteLumiToCool.py.

◆ untilLum

WriteLumiToCool.untilLum

Definition at line 183 of file WriteLumiToCool.py.

◆ untilRun

WriteLumiToCool.untilRun