WriteBchToCool Namespace Reference

Functions
	usage ()
	compare (item1, item2)

Variables
str	letters = "hr:l:N:B:b:e:L:AM:m:S:s:i:o:t:f:x:c:C:U:npvu"
list	keywords = ["help","run=","lumi=","run1=","lumi1=","begin=","end=","endlumi=","adjust","module=","mode=","server=","schema=","inschema=","outschema=","tag=","folder=","execfile=","comment=","Comment=","user=","online","upd4","verbose","update"]
	opts
	extraparams
int	run = -1
int	lumi = 0
int	run1 = -1
int	lumi1 = 0
int	mode = 0
str	server = ''
str	schema = 'sqlite://;schema=tileSqlite.db;dbname=CONDBR2'
str	oraSchema = 'COOLOFL_TILE/CONDBR2'
str	inSchema = oraSchema
str	outSchema = schema
str	folderPath = "/TILE/OFL02/STATUS/ADC"
str	onlSuffix = ""
str	curSuffix = ""
str	tag = "UPD1"
str	execFile = "bch.py"
str	comment = ""
	Comment = None
bool	verbose = False
bool	update = False
bool	iov = False
int	beg = 0
int	end = 2147483647
int	endlumi = 0
list	moduleList = []
bool	adjust = False
	user = os.getlogin()
	a = a.strip()
tuple	onl = ("/TILE/ONL01" in folderPath)
tuple	until = (TileCalibTools.MAXRUN,TileCalibTools.MAXLBK)
	log = getLogger("WriteBchToCool")
	dbr = TileCalibTools.openDbConn(inSchema,server)
	folderTag = TileCalibTools.getFolderTag(dbr, folderPath, tag)
list	iovList = []
list	iovUntil = []
list	iovListMOD = []
list	iovListCMT = []
list	iovUntilCMT = []
	blobReader = TileCalibTools.TileBlobReader(dbr,folderPath, folderTag)
	modName = TileCalibUtils.getDrawerString(ros,mod)
tuple	since = (beg,lumi)
int	ib = bisect.bisect(iovList,since)-1
int	ie = ib+1
tuple	begin = since
	p = bisect.bisect(iovListCMT,since)
list	comments = []
list	mgrWriters = []
list	nvalUpdated = []
list	commentsSplit = []
	comm = blobReader.getComment(since)
	mgr = TileBchTools.TileBchMgr()
tuple	emptyChannelLongBarrel = (30, 31, 43)
tuple	emptyChannelExtendedBarrel = (18, 19, 24, 25, 26, 27, 28, 29, 33, 34, 42, 43, 44, 45, 46, 47)
	dbw = TileCalibTools.openDbConn(outSchema,('UPDATE' if update else 'RECREATE'))
list	untilCmt = iovUntilCMT[io]
list	mList = ['CMT']
	author = user
	reader = TileCalibTools.TileBlobReader(dbr, folderPath, folderTag)
	folderTagUPD4 = TileCalibTools.getFolderTag(dbr, folderPath, "UPD4" )
str	curSchema = outSchema.replace(".db","_upd1.db")
	folder = dbr.getFolder(folderPath)
	dbR = TileCalibTools.openDbConn(oraSchema,server)
	dbW = TileCalibTools.openDbConn(curSchema,('UPDATE' if update else 'RECREATE'))
str	folderOnl = "/TILE/ONL01/STATUS/ADC"
str	folderTagOnl = ""
str	inSchemaOnl = inSchema.replace("COOLOFL", "COOLONL")
	mgrOnl = TileBchTools.TileBchMgr()
	statlo = mgr.getAdcStatus(ros, mod, chn, 0)
	stathi = mgr.getAdcStatus(ros, mod, chn, 1)
	prbs = statlo.getPrbs()
str	onlSchema = outSchema.replace(".db", onlSuffix + ".db")

Function Documentation

compare()

compare	(		item1,
			item2 )

Definition at line 199 of file WriteBchToCool.py.

    def compare(item1,item2):
        if item1[0]!=item2[0]:
            return item1[0]-item2[0]
        else:
            return item1[1]-item2[1]

usage()

usage

(

)

Definition at line 12 of file WriteBchToCool.py.

def usage():
    print ("Usage: ", sys.argv[0]," [OPTION] ... ")
    print ("Update TileCal bad channels in COOL")
    print ("")
    print ("-h, --help      shows this help")
    print ("-f, --folder=   specify folder to use, default is /TILE/OFL02/STATUS/ADC")
    print ("-t, --tag=      specify tag to use, default is RUN2-HLT-UPD1-00")
    print ("-r, --run=      specify run  number, default is 0")
    print ("-N, --run1=     specify run  number at which new IOV should be ended")
    print ("-l, --lumi=     specify lumi block number, default is 0")
    print ("-B, --lumi1=    specify lumi block number at which new IOV should be eneded, default is 0")
    print ("-b, --begin=    specify run number of first iov in multi-iov mode, by default uses very first iov")
    print ("-e, --end=      specify run number of last iov in multi-iov mode, by default uses latest iov")
    print ("-L, --endlumi=  specify lumi block number for last iov in multi-iov mode, default is 0")
    print ("-A, --adjust    in multi-iov mode adjust iov boundaries to nearest iov available in DB, default is False")
    print ("-M, --module=   specify module to use in multi-IOV update, default is all")
    print ("-m, --mode=     specify update mode: 1 or 2; if not set - choosen automatically, depending on schema")
    print ("-c, --comment=    specify comment which should be written to DB, in multi-iov mode it is appended to old comment")
    print ("-C, --Comment=    specify comment which should be written to DB, in mutli-iov mode it overwrites old comment")
    print ("-U, --user=       specify username for comment")
    print ("-x, --execfile=   specify python file which should be executed, default is bch.py")
    print ("-i, --inschema=   specify the input schema to use, default is 'COOLOFL_TILE/CONDBR2'")
    print ("-o, --outschema=  specify the output schema to use, default is 'sqlite://;schema=tileSqlite.db;dbname=CONDBR2'")
    print ("-n, --online      write additional sqlite file with online bad channel status")
    print ("-p, --upd4        write additional sqlite file with CURRENT UPD4 tag")
    print ("-v, --verbose     verbose mode")
    print ("-s, --schema=     specify input/output schema to use when both input and output schemas are the same")
    print ("-S, --server=     specify server - ORACLE or FRONTIER, default is FRONTIER")
    print ("-u  --update      set this flag if output sqlite file should be updated, otherwise it'll be recreated")
 

Variable Documentation

a

WriteBchToCool.a = a.strip()

Definition at line 85 of file WriteBchToCool.py.

adjust

bool adjust = False

Definition at line 77 of file WriteBchToCool.py.

author

list author = user

Definition at line 386 of file WriteBchToCool.py.

beg

WriteBchToCool.beg = 0

Definition at line 73 of file WriteBchToCool.py.

begin

tuple begin = since

Definition at line 244 of file WriteBchToCool.py.

blobReader

WriteBchToCool.blobReader = TileCalibTools.TileBlobReader(dbr,folderPath, folderTag)

Definition at line 181 of file WriteBchToCool.py.

comm

WriteBchToCool.comm = blobReader.getComment(since)

Definition at line 312 of file WriteBchToCool.py.

Comment

WriteBchToCool.Comment = None

Definition at line 69 of file WriteBchToCool.py.

comment

str comment = ""

Definition at line 68 of file WriteBchToCool.py.

comments

list WriteBchToCool.comments = []

Definition at line 307 of file WriteBchToCool.py.

commentsSplit

list WriteBchToCool.commentsSplit = []

Definition at line 310 of file WriteBchToCool.py.

curSchema

str curSchema = outSchema.replace(".db","_upd1.db")

Definition at line 429 of file WriteBchToCool.py.

curSuffix

str curSuffix = ""

Definition at line 65 of file WriteBchToCool.py.

dbR

WriteBchToCool.dbR = TileCalibTools.openDbConn(oraSchema,server)

Definition at line 436 of file WriteBchToCool.py.

dbr

WriteBchToCool.dbr = TileCalibTools.openDbConn(inSchema,server)

Definition at line 172 of file WriteBchToCool.py.

dbW

WriteBchToCool.dbW = TileCalibTools.openDbConn(curSchema,('UPDATE' if update else 'RECREATE'))

Definition at line 443 of file WriteBchToCool.py.

dbw

WriteBchToCool.dbw = TileCalibTools.openDbConn(outSchema,('UPDATE' if update else 'RECREATE'))

Definition at line 348 of file WriteBchToCool.py.

emptyChannelExtendedBarrel

tuple WriteBchToCool.emptyChannelExtendedBarrel = (18, 19, 24, 25, 26, 27, 28, 29, 33, 34, 42, 43, 44, 45, 46, 47)

Definition at line 325 of file WriteBchToCool.py.

emptyChannelLongBarrel

tuple WriteBchToCool.emptyChannelLongBarrel = (30, 31, 43)

Definition at line 324 of file WriteBchToCool.py.

end

WriteBchToCool.end = 2147483647

Definition at line 74 of file WriteBchToCool.py.

endlumi

WriteBchToCool.endlumi = 0

Definition at line 75 of file WriteBchToCool.py.

execFile

WriteBchToCool.execFile = "bch.py"

Definition at line 67 of file WriteBchToCool.py.

extraparams

WriteBchToCool.extraparams

Definition at line 46 of file WriteBchToCool.py.

folder

WriteBchToCool.folder = dbr.getFolder(folderPath)

Definition at line 433 of file WriteBchToCool.py.

folderOnl

str WriteBchToCool.folderOnl = "/TILE/ONL01/STATUS/ADC"

Definition at line 465 of file WriteBchToCool.py.

folderPath

WriteBchToCool.folderPath = "/TILE/OFL02/STATUS/ADC"

Definition at line 63 of file WriteBchToCool.py.

folderTag

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

Definition at line 173 of file WriteBchToCool.py.

folderTagOnl

str WriteBchToCool.folderTagOnl = ""

Definition at line 466 of file WriteBchToCool.py.

folderTagUPD4

WriteBchToCool.folderTagUPD4 = TileCalibTools.getFolderTag(dbr, folderPath, "UPD4" )

Definition at line 424 of file WriteBchToCool.py.

ib

int ib = bisect.bisect(iovList,since)-1

Definition at line 210 of file WriteBchToCool.py.

ie

int ie = ib+1

Definition at line 222 of file WriteBchToCool.py.

inSchema

str inSchema = oraSchema

Definition at line 61 of file WriteBchToCool.py.

inSchemaOnl

str inSchemaOnl = inSchema.replace("COOLOFL", "COOLONL")

Definition at line 468 of file WriteBchToCool.py.

iov

bool iov = False

Definition at line 72 of file WriteBchToCool.py.

iovList

list iovList = []

Definition at line 176 of file WriteBchToCool.py.

iovListCMT

WriteBchToCool.iovListCMT = []

Definition at line 179 of file WriteBchToCool.py.

iovListMOD

list iovListMOD = []

Definition at line 178 of file WriteBchToCool.py.

iovUntil

list iovUntil = []

Definition at line 177 of file WriteBchToCool.py.

iovUntilCMT

list iovUntilCMT = []

Definition at line 180 of file WriteBchToCool.py.

keywords

list WriteBchToCool.keywords = ["help","run=","lumi=","run1=","lumi1=","begin=","end=","endlumi=","adjust","module=","mode=","server=","schema=","inschema=","outschema=","tag=","folder=","execfile=","comment=","Comment=","user=","online","upd4","verbose","update"]

Definition at line 43 of file WriteBchToCool.py.

letters

str WriteBchToCool.letters = "hr:l:N:B:b:e:L:AM:m:S:s:i:o:t:f:x:c:C:U:npvu"

Definition at line 42 of file WriteBchToCool.py.

log

WriteBchToCool.log = getLogger("WriteBchToCool")

Definition at line 168 of file WriteBchToCool.py.

lumi

int lumi = 0

Definition at line 54 of file WriteBchToCool.py.

lumi1

WriteBchToCool.lumi1 = 0

Definition at line 56 of file WriteBchToCool.py.

mgr

list mgr = TileBchTools.TileBchMgr()

Definition at line 317 of file WriteBchToCool.py.

mgrOnl

WriteBchToCool.mgrOnl = TileBchTools.TileBchMgr()

Definition at line 481 of file WriteBchToCool.py.

mgrWriters

list WriteBchToCool.mgrWriters = []

Definition at line 308 of file WriteBchToCool.py.

mList

list mList = ['CMT']

Definition at line 362 of file WriteBchToCool.py.

mode

int mode = 0

Definition at line 57 of file WriteBchToCool.py.

modName

WriteBchToCool.modName = TileCalibUtils.getDrawerString(ros,mod)

Definition at line 188 of file WriteBchToCool.py.

moduleList

list WriteBchToCool.moduleList = []

Definition at line 76 of file WriteBchToCool.py.

nvalUpdated

list WriteBchToCool.nvalUpdated = []

Definition at line 309 of file WriteBchToCool.py.

onl

tuple WriteBchToCool.onl = ("/TILE/ONL01" in folderPath)

Definition at line 145 of file WriteBchToCool.py.

onlSchema

str WriteBchToCool.onlSchema = outSchema.replace(".db", onlSuffix + ".db")

Definition at line 583 of file WriteBchToCool.py.

onlSuffix

str onlSuffix = ""

Definition at line 64 of file WriteBchToCool.py.

opts

WriteBchToCool.opts

Definition at line 46 of file WriteBchToCool.py.

oraSchema

str oraSchema = 'COOLOFL_TILE/CONDBR2'

Definition at line 60 of file WriteBchToCool.py.

outSchema

str outSchema = schema

Definition at line 62 of file WriteBchToCool.py.

p

WriteBchToCool.p = bisect.bisect(iovListCMT,since)

Definition at line 255 of file WriteBchToCool.py.

prbs

WriteBchToCool.prbs = statlo.getPrbs()

Definition at line 507 of file WriteBchToCool.py.

reader

WriteBchToCool.reader = TileCalibTools.TileBlobReader(dbr, folderPath, folderTag)

Definition at line 414 of file WriteBchToCool.py.

run

tuple run = -1

Definition at line 53 of file WriteBchToCool.py.

run1

WriteBchToCool.run1 = -1

Definition at line 55 of file WriteBchToCool.py.

schema

str schema = 'sqlite://;schema=tileSqlite.db;dbname=CONDBR2'

Definition at line 59 of file WriteBchToCool.py.

server

WriteBchToCool.server = ''

Definition at line 58 of file WriteBchToCool.py.

since

list since = (beg,lumi)

Definition at line 209 of file WriteBchToCool.py.

stathi

WriteBchToCool.stathi = mgr.getAdcStatus(ros, mod, chn, 1)

Definition at line 496 of file WriteBchToCool.py.

statlo

WriteBchToCool.statlo = mgr.getAdcStatus(ros, mod, chn, 0)

Definition at line 495 of file WriteBchToCool.py.

tag

WriteBchToCool.tag = "UPD1"

Definition at line 66 of file WriteBchToCool.py.

until

tuple until = (TileCalibTools.MAXRUN,TileCalibTools.MAXLBK)

Definition at line 165 of file WriteBchToCool.py.

untilCmt

list WriteBchToCool.untilCmt = iovUntilCMT[io]

Definition at line 354 of file WriteBchToCool.py.

update

bool update = False

Definition at line 71 of file WriteBchToCool.py.

user

str user = os.getlogin()

Definition at line 80 of file WriteBchToCool.py.

verbose

bool verbose = False

Definition at line 70 of file WriteBchToCool.py.