Functions
	usage ()

Variables
str	letters = "hi:o:t:f:d:S:x:v:V:c:r:l:u"
list	keywords = ["help","infile=","outfile=","tag=","folder=","dbname=","server=","txtfile=","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 = ''
str	txtFile = ''
	value = None
	value2 = None
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)
str	newiov = "[%d,%d] - infinity" % (run, lumi)
	since = CaloCondTools.iovFromRunLumi( run, lumi )
	until = CaloCondTools.iovFromRunLumi( CaloCondTools.MAXRUN, CaloCondTools.MAXLBK )
dict	input = {}
	allData = f.readlines()
	fields = line.strip().split()
int	ind = 0
	ch = int(fields[0])
	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)
	newval1 = abs(float(input[chan][0]))
	newval2 = abs(int(float(input[chan][1])))
	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 ("-x, --txtfile=  specify the text file with the new lumi constants")
    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 59 of file WriteLumiToCool.py.

◆ allData

WriteLumiToCool.allData = f.readlines()

Definition at line 185 of file WriteLumiToCool.py.

◆ ch

WriteLumiToCool.ch = int(fields[0])

Definition at line 199 of file WriteLumiToCool.py.

◆ channels

list WriteLumiToCool.channels = [0,1]

Definition at line 56 of file WriteLumiToCool.py.

◆ data

WriteLumiToCool.data = cool.Record( spec )

Definition at line 234 of file WriteLumiToCool.py.

◆ dbName

WriteLumiToCool.dbName = 'CONDBR2'

Definition at line 48 of file WriteLumiToCool.py.

◆ dbr

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

Definition at line 132 of file WriteLumiToCool.py.

◆ dbw

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

Definition at line 134 of file WriteLumiToCool.py.

◆ extraparams

WriteLumiToCool.extraparams

Definition at line 37 of file WriteLumiToCool.py.

◆ fields

WriteLumiToCool.fields = line.strip().split()

Definition at line 191 of file WriteLumiToCool.py.

◆ folderDescr

WriteLumiToCool.folderDescr = CaloCondTools.getAthenaFolderDescr()

Definition at line 160 of file WriteLumiToCool.py.

◆ folderMode

WriteLumiToCool.folderMode = cool.FolderVersioning.MULTI_VERSION

Definition at line 153 of file WriteLumiToCool.py.

◆ folderPath

str WriteLumiToCool.folderPath = ''

Definition at line 47 of file WriteLumiToCool.py.

◆ folderR

WriteLumiToCool.folderR = dbr.getFolder(folderPath)

Definition at line 161 of file WriteLumiToCool.py.

◆ folderSpec

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

Definition at line 154 of file WriteLumiToCool.py.

◆ folderTag

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

Definition at line 143 of file WriteLumiToCool.py.

◆ folderW

WriteLumiToCool.folderW = dbw.getFolder(folderPath)

Definition at line 164 of file WriteLumiToCool.py.

◆ ind

int WriteLumiToCool.ind = 0

Definition at line 198 of file WriteLumiToCool.py.

◆ inFile

WriteLumiToCool.inFile = 'COOLOFL_CALO/CONDBR2'

Definition at line 44 of file WriteLumiToCool.py.

◆ input

dict WriteLumiToCool.input = {}

Definition at line 174 of file WriteLumiToCool.py.

◆ ischema

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

Definition at line 123 of file WriteLumiToCool.py.

◆ keywords

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

Definition at line 34 of file WriteLumiToCool.py.

◆ letters

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

Definition at line 33 of file WriteLumiToCool.py.

◆ log

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

Definition at line 113 of file WriteLumiToCool.py.

◆ lumi

WriteLumiToCool.lumi = 0

Definition at line 54 of file WriteLumiToCool.py.

◆ multiVersion

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

Definition at line 150 of file WriteLumiToCool.py.

◆ newiov

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

Definition at line 170 of file WriteLumiToCool.py.

◆ newval1

float WriteLumiToCool.newval1 = abs(float(input[chan][0]))

Definition at line 222 of file WriteLumiToCool.py.

◆ newval2

int WriteLumiToCool.newval2 = abs(int(float(input[chan][1])))

Definition at line 226 of file WriteLumiToCool.py.

◆ obj

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

Definition at line 209 of file WriteLumiToCool.py.

◆ oldiov

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

Definition at line 214 of file WriteLumiToCool.py.

◆ opts

WriteLumiToCool.opts

Definition at line 37 of file WriteLumiToCool.py.

◆ oschema

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

Definition at line 131 of file WriteLumiToCool.py.

◆ outFile

WriteLumiToCool.outFile = 'caloSqlite.db'

Definition at line 45 of file WriteLumiToCool.py.

◆ run

WriteLumiToCool.run = -1

Definition at line 53 of file WriteLumiToCool.py.

◆ server

WriteLumiToCool.server = ''

Definition at line 49 of file WriteLumiToCool.py.

◆ since

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

Definition at line 171 of file WriteLumiToCool.py.

◆ sinceLum

WriteLumiToCool.sinceLum

Definition at line 210 of file WriteLumiToCool.py.

◆ sinceRun

WriteLumiToCool.sinceRun

Definition at line 210 of file WriteLumiToCool.py.

◆ spec

WriteLumiToCool.spec = cool.RecordSpecification()

Definition at line 146 of file WriteLumiToCool.py.

◆ tag

str WriteLumiToCool.tag = ''

Definition at line 46 of file WriteLumiToCool.py.

◆ txtFile

WriteLumiToCool.txtFile = ''

Definition at line 50 of file WriteLumiToCool.py.

◆ until

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

Definition at line 172 of file WriteLumiToCool.py.

◆ untilLum

WriteLumiToCool.untilLum

Definition at line 211 of file WriteLumiToCool.py.

◆ untilRun

WriteLumiToCool.untilRun