WriteBchToCool Namespace Reference

Functions
	usage ()
	compare (item1, item2)

Variables
str	letters = "hr:l:b:e:L:AM:m:S:s:i:o:t:f:x:c:C:U:npvu"
list	keywords = ["help","run=","lumi=","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	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()

WriteBchToCool.compare	(		item1,
			item2 )

Definition at line 191 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()

WriteBchToCool.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 ("-l, --lumi=     specify lumi block number, 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 81 of file WriteBchToCool.py.

adjust

bool WriteBchToCool.adjust = False

Definition at line 73 of file WriteBchToCool.py.

author

list WriteBchToCool.author = user

Definition at line 376 of file WriteBchToCool.py.

beg

WriteBchToCool.beg = 0

Definition at line 69 of file WriteBchToCool.py.

begin

tuple WriteBchToCool.begin = since

Definition at line 236 of file WriteBchToCool.py.

blobReader

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

Definition at line 173 of file WriteBchToCool.py.

comm

WriteBchToCool.comm = blobReader.getComment(since)

Definition at line 302 of file WriteBchToCool.py.

Comment

WriteBchToCool.Comment = None

Definition at line 65 of file WriteBchToCool.py.

comment

str WriteBchToCool.comment = ""

Definition at line 64 of file WriteBchToCool.py.

comments

list WriteBchToCool.comments = []

Definition at line 297 of file WriteBchToCool.py.

commentsSplit

list WriteBchToCool.commentsSplit = []

Definition at line 300 of file WriteBchToCool.py.

curSchema

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

Definition at line 419 of file WriteBchToCool.py.

curSuffix

str WriteBchToCool.curSuffix = ""

Definition at line 61 of file WriteBchToCool.py.

dbR

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

Definition at line 426 of file WriteBchToCool.py.

dbr

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

Definition at line 164 of file WriteBchToCool.py.

dbW

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

Definition at line 433 of file WriteBchToCool.py.

dbw

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

Definition at line 338 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 315 of file WriteBchToCool.py.

emptyChannelLongBarrel

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

Definition at line 314 of file WriteBchToCool.py.

end

WriteBchToCool.end = 2147483647

Definition at line 70 of file WriteBchToCool.py.

endlumi

WriteBchToCool.endlumi = 0

Definition at line 71 of file WriteBchToCool.py.

execFile

WriteBchToCool.execFile = "bch.py"

Definition at line 63 of file WriteBchToCool.py.

extraparams

WriteBchToCool.extraparams

Definition at line 44 of file WriteBchToCool.py.

folder

WriteBchToCool.folder = dbr.getFolder(folderPath)

Definition at line 423 of file WriteBchToCool.py.

folderOnl

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

Definition at line 455 of file WriteBchToCool.py.

folderPath

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

Definition at line 59 of file WriteBchToCool.py.

folderTag

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

Definition at line 165 of file WriteBchToCool.py.

folderTagOnl

str WriteBchToCool.folderTagOnl = ""

Definition at line 456 of file WriteBchToCool.py.

folderTagUPD4

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

Definition at line 414 of file WriteBchToCool.py.

ib

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

Definition at line 202 of file WriteBchToCool.py.

ie

int WriteBchToCool.ie = ib+1

Definition at line 214 of file WriteBchToCool.py.

inSchema

str WriteBchToCool.inSchema = oraSchema

Definition at line 57 of file WriteBchToCool.py.

inSchemaOnl

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

Definition at line 458 of file WriteBchToCool.py.

iov

bool WriteBchToCool.iov = False

Definition at line 68 of file WriteBchToCool.py.

iovList

list WriteBchToCool.iovList = []

Definition at line 168 of file WriteBchToCool.py.

iovListCMT

WriteBchToCool.iovListCMT = []

Definition at line 171 of file WriteBchToCool.py.

iovListMOD

list WriteBchToCool.iovListMOD = []

Definition at line 170 of file WriteBchToCool.py.

iovUntil

list WriteBchToCool.iovUntil = []

Definition at line 169 of file WriteBchToCool.py.

iovUntilCMT

list WriteBchToCool.iovUntilCMT = []

Definition at line 172 of file WriteBchToCool.py.

keywords

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

Definition at line 41 of file WriteBchToCool.py.

letters

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

Definition at line 40 of file WriteBchToCool.py.

log

WriteBchToCool.log = getLogger("WriteBchToCool")

Definition at line 160 of file WriteBchToCool.py.

lumi

int WriteBchToCool.lumi = 0

Definition at line 52 of file WriteBchToCool.py.

mgr

list WriteBchToCool.mgr = TileBchTools.TileBchMgr()

Definition at line 307 of file WriteBchToCool.py.

mgrOnl

WriteBchToCool.mgrOnl = TileBchTools.TileBchMgr()

Definition at line 471 of file WriteBchToCool.py.

mgrWriters

list WriteBchToCool.mgrWriters = []

Definition at line 298 of file WriteBchToCool.py.

mList

list WriteBchToCool.mList = ['CMT']

Definition at line 352 of file WriteBchToCool.py.

mode

int WriteBchToCool.mode = 0

Definition at line 53 of file WriteBchToCool.py.

modName

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

Definition at line 180 of file WriteBchToCool.py.

moduleList

list WriteBchToCool.moduleList = []

Definition at line 72 of file WriteBchToCool.py.

nvalUpdated

list WriteBchToCool.nvalUpdated = []

Definition at line 299 of file WriteBchToCool.py.

onl

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

Definition at line 137 of file WriteBchToCool.py.

onlSchema

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

Definition at line 573 of file WriteBchToCool.py.

onlSuffix

str WriteBchToCool.onlSuffix = ""

Definition at line 60 of file WriteBchToCool.py.

opts

WriteBchToCool.opts

Definition at line 44 of file WriteBchToCool.py.

oraSchema

str WriteBchToCool.oraSchema = 'COOLOFL_TILE/CONDBR2'

Definition at line 56 of file WriteBchToCool.py.

outSchema

str WriteBchToCool.outSchema = schema

Definition at line 58 of file WriteBchToCool.py.

p

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

Definition at line 247 of file WriteBchToCool.py.

prbs

WriteBchToCool.prbs = statlo.getPrbs()

Definition at line 497 of file WriteBchToCool.py.

reader

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

Definition at line 404 of file WriteBchToCool.py.

run

tuple WriteBchToCool.run = -1

Definition at line 51 of file WriteBchToCool.py.

schema

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

Definition at line 55 of file WriteBchToCool.py.

server

WriteBchToCool.server = ''

Definition at line 54 of file WriteBchToCool.py.

since

list WriteBchToCool.since = (beg,lumi)

Definition at line 201 of file WriteBchToCool.py.

stathi

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

Definition at line 486 of file WriteBchToCool.py.

statlo

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

Definition at line 485 of file WriteBchToCool.py.

tag

WriteBchToCool.tag = "UPD1"

Definition at line 62 of file WriteBchToCool.py.

until

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

Definition at line 157 of file WriteBchToCool.py.

untilCmt

list WriteBchToCool.untilCmt = iovUntilCMT[io]

Definition at line 344 of file WriteBchToCool.py.

update

bool WriteBchToCool.update = False

Definition at line 67 of file WriteBchToCool.py.

user

str WriteBchToCool.user = os.getlogin()

Definition at line 76 of file WriteBchToCool.py.

verbose

bool WriteBchToCool.verbose = False

Definition at line 66 of file WriteBchToCool.py.