AFPAlignDBCreate Namespace Reference

Classes
class	AFPDBDict
class	folderBulk

Functions
def	runLBtoDB (run, lb)
def	makeFolderAndSpec (db, folderName, tag)
def	main ()

Function Documentation

main()

def AFPAlignDBCreate.main

(

)

Definition at line 158 of file AFPAlignDBCreate.py.

def main():
    dbFile = "Example.db"
    dbName = "CONDBR2" 
    
    # remove the old db file so that we can write the new one
    try:
        import os
        os.remove(dbFile)
    except IOError:
        pass
 
    # get database service and open database
    dbSvc = cool.DatabaseSvcFactory.databaseService()
 
    # database accessed via physical name
    dbString = "sqlite://;schema=%s;dbname=%s" % (dbFile, dbName)
    try:
        db = dbSvc.createDatabase(dbString)
    except Exception as e:
        print ('Problem creating database', e)
        sys.exit(-1)
    print ("Created database", dbString)
    
    # define the folder in the database, its specification and its tag
    folderBlkLoc_03=makeFolderAndSpec(db,folderName="/FWD/Onl/AFP/Align/Local", tag="AFPAlignLoc-03")
    folderBlkGlob_03=makeFolderAndSpec(db,folderName="/FWD/Onl/AFP/Align/Global", tag="AFPAlignGlob-03")
    
    # copy everything from the xml file here
    # https://gitlab.cern.ch/afp/AfpAnalysisToolbox/-/blob/master/AfpAnalysisTools/share/align.xml
    # zeros for Run3; RP constants from https://indico.cern.ch/event/1138072/contributions/4774895/attachments/2405515/4114924/Trzebinski_ARP_Run3_Optics.pdf
    # "toRun" is not used but it's kept here for better clarity 
 
 
    # update July 30, 2021
    fromRun = 203302
    myDict = AFPDBDict(folderBlk=folderBlkLoc_03)
    myDict.savePayload(folderBlk=folderBlkLoc_03, fromRun=fromRun)
 
    fromRun = 329484
    myDict = AFPDBDict(folderBlkLoc_03)
    myDict.append(stationID=0, layerID=1, shiftX=17.1313e-3,  shiftY=-46.7438e-3, shiftZ=0.0000, alpha=2.9785e-3,  beta=0.0000, gamma=0.0000)
    myDict.append(stationID=0, layerID=2, shiftX=15.7960e-3,  shiftY=-53.7707e-3, shiftZ=0.0000, alpha=3.3048e-3,  beta=0.0000, gamma=0.0000)
    myDict.append(stationID=0, layerID=3, shiftX=0.0000,      shiftY=0.0000,      shiftZ=0.0000, alpha=0.0000,     beta=0.0000, gamma=0.0000)
    myDict.append(stationID=1, layerID=1, shiftX=138.0070e-3, shiftY=6.0528e-3,   shiftZ=0.0000, alpha=-1.4420e-3, beta=0.0000, gamma=0.0000)
    myDict.append(stationID=1, layerID=2, shiftX=-80.6720e-3, shiftY=24.1310e-3,  shiftZ=0.0000, alpha=-3.6605e-3, beta=0.0000, gamma=0.0000)
    myDict.append(stationID=1, layerID=3, shiftX=-51.5111e-3, shiftY=-32.9151e-3, shiftZ=0.0000, alpha=1.0762e-3,  beta=0.0000, gamma=0.0000)
    myDict.append(stationID=2, layerID=1, shiftX=149.6927e-3, shiftY=103.5674e-3, shiftZ=0.0000, alpha=-3.9565e-3, beta=0.0000, gamma=0.0000)
    myDict.append(stationID=2, layerID=2, shiftX=144.1316e-3, shiftY=88.0891e-3,  shiftZ=0.0000, alpha=3.3219e-3,  beta=0.0000, gamma=0.0000)
    myDict.append(stationID=2, layerID=3, shiftX=47.8090e-3,  shiftY=153.5737e-3, shiftZ=0.0000, alpha=5.1961e-3,  beta=0.0000, gamma=0.0000)
    myDict.append(stationID=3, layerID=1, shiftX=0.0000,      shiftY=0.0000,      shiftZ=0.0000, alpha=0.0000,     beta=0.0000, gamma=0.0000)
    myDict.append(stationID=3, layerID=2, shiftX=-153.0397e-3,shiftY=132.8483e-3, shiftZ=0.0000, alpha=-3.9787e-3, beta=0.0000, gamma=0.0000)
    myDict.append(stationID=3, layerID=3, shiftX=13.9500e-3,  shiftY=136.9500e-3, shiftZ=0.0000, alpha=0.3829e-3,  beta=0.0000, gamma=0.0000)
    myDict.savePayload(folderBlk=folderBlkLoc_03, fromRun=fromRun)
 
    fromRun = 413300
    myDict = AFPDBDict(folderBlk=folderBlkLoc_03)
    myDict.savePayload(folderBlk=folderBlkLoc_03, fromRun=fromRun)
 
 
    # fromRun, toRun = 203302, 203302
    fromRun = 203302
    myDict = AFPDBDict(folderBlk=folderBlkGlob_03)
    myDict.append(stationID=0, alignType="RP", shiftX=-2.34, shiftY=-13.22)
    myDict.append(stationID=1, alignType="RP", shiftX=-3.68, shiftY=-13.28)
    myDict.append(stationID=2, alignType="RP", shiftX=-3.61, shiftY=-10.09)
    myDict.append(stationID=3, alignType="RP", shiftX=-2.39, shiftY=-10.53)
    myDict.savePayload(folderBlk=folderBlkGlob_03, fromRun=fromRun)
  
    # fromRun, toRun = 329484, 330470
    fromRun = 329484
    myDict = AFPDBDict(folderBlk=folderBlkGlob_03)
    myDict.append(stationID=0, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=1, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=2, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=3, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=0, alignType="beam", shiftX=-1.045)
    myDict.append(stationID=1, alignType="beam", shiftX=-0.864)
    myDict.append(stationID=2, alignType="beam", shiftX=-1.155)
    myDict.append(stationID=3, alignType="beam", shiftX=-0.891)
    myDict.append(stationID=0, alignType="RP", shiftX=-3.16)
    myDict.append(stationID=1, alignType="RP", shiftX=-4.07)
    myDict.append(stationID=2, alignType="RP", shiftX=-4.26)
    myDict.append(stationID=3, alignType="RP", shiftX=-2.93)
    myDict.append(stationID=0, alignType="correction", shiftX=-0.420)
    myDict.append(stationID=1, alignType="correction", shiftX=-0.320)
    myDict.append(stationID=2, alignType="correction", shiftX=-0.220)
    myDict.append(stationID=3, alignType="correction", shiftX=-0.320)
    myDict.savePayload(folderBlk=folderBlkGlob_03, fromRun=fromRun)
 
    # fromRun, toRun = 331020, 335302
    fromRun = 331020
    myDict = AFPDBDict(folderBlk=folderBlkGlob_03)
    myDict.append(stationID=0, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=1, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=2, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=3, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=0, alignType="beam", shiftX=-1.045)
    myDict.append(stationID=1, alignType="beam", shiftX=-0.864)
    myDict.append(stationID=2, alignType="beam", shiftX=-1.155)
    myDict.append(stationID=3, alignType="beam", shiftX=-0.891)
    myDict.append(stationID=0, alignType="RP", shiftX=-2.65)
    myDict.append(stationID=1, alignType="RP", shiftX=-3.57)
    myDict.append(stationID=2, alignType="RP", shiftX=-3.76)
    myDict.append(stationID=3, alignType="RP", shiftX=-2.43)
    myDict.append(stationID=0, alignType="correction", shiftX=-0.420)
    myDict.append(stationID=1, alignType="correction", shiftX=-0.320)
    myDict.append(stationID=2, alignType="correction", shiftX=-0.220)
    myDict.append(stationID=3, alignType="correction", shiftX=-0.320)
    myDict.savePayload(folderBlk=folderBlkGlob_03, fromRun=fromRun)
 
    # fromRun, toRun = 336288, 341692
    fromRun = 336288
    myDict = AFPDBDict(folderBlk=folderBlkGlob_03)
    myDict.append(stationID=0, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=1, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=2, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=3, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=0, alignType="beam", shiftX=-1.045)
    myDict.append(stationID=1, alignType="beam", shiftX=-0.864)
    myDict.append(stationID=2, alignType="beam", shiftX=-1.155)
    myDict.append(stationID=3, alignType="beam", shiftX=-0.891)
    myDict.append(stationID=0, alignType="RP", shiftX=-2.38)
    myDict.append(stationID=1, alignType="RP", shiftX=-3.60)
    myDict.append(stationID=2, alignType="RP", shiftX=-3.87)
    myDict.append(stationID=3, alignType="RP", shiftX=-2.23)
    myDict.append(stationID=0, alignType="correction", shiftX=-0.420)
    myDict.append(stationID=1, alignType="correction", shiftX=-0.320)
    myDict.append(stationID=2, alignType="correction", shiftX=-0.220)
    myDict.append(stationID=3, alignType="correction", shiftX=-0.320)
    myDict.savePayload(folderBlk=folderBlkGlob_03, fromRun=fromRun)
 
    # fromRun, toRun = 347955, 348002
    fromRun = 347955
    myDict = AFPDBDict(folderBlk=folderBlkGlob_03)
    myDict.append(stationID=0, alignType="RP", shiftX=-2.34, shiftY=-13.22)
    myDict.append(stationID=1, alignType="RP", shiftX=-3.68, shiftY=-13.28)
    myDict.append(stationID=2, alignType="RP", shiftX=-6.46, shiftY=-5.47)
    myDict.append(stationID=3, alignType="RP", shiftX=-6.79, shiftY=-5.03)
    myDict.savePayload(folderBlk=folderBlkGlob_03, fromRun=fromRun)
    
    fromRun = 413300
    myDict = AFPDBDict(folderBlk=folderBlkGlob_03)
    myDict.append(stationID=0, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=1, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=2, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=3, alignType="tracker", shiftX=-0.5)
    myDict.append(stationID=0, alignType="RP", shiftX=-1.509)
    myDict.append(stationID=1, alignType="RP", shiftX=-2.315)
    myDict.append(stationID=2, alignType="RP", shiftX=-2.325)
    myDict.append(stationID=3, alignType="RP", shiftX=-1.5)
    myDict.savePayload(folderBlk=folderBlkGlob_03, fromRun=fromRun)
 
    print ("\nClose database")
    db.closeDatabase()
 
 

makeFolderAndSpec()

def AFPAlignDBCreate.makeFolderAndSpec	(		db,
			folderName,
			tag
	)

A function that will ensure a folder is in the database, it creates it if necessary. Also defines content of the folders. There are two folders: one for local constants and one for global constants. They both contain single entry of a long string

Definition at line 38 of file AFPAlignDBCreate.py.

def makeFolderAndSpec(db,folderName,tag):
    """A function that will ensure a folder is in the database, it creates it if necessary. Also defines content of the folders. There are two folders: one for local constants and one for global constants. They both contain single entry of a long string"""
    
    spec=cool.RecordSpecification()
 
    # each folder contain just a single entry, this string will be JSON entry
    spec.extend("data",cool.StorageType.String64k)
 
    runLumi=True
 
    # if there are more channels, use "CondAttrListCollection"; if there is only one channel, use "AthenaAttributeList"
    # it's also possible to use "CondAttrListCollection" if there's only one channel
    folder=AtlCoolLib.ensureFolder(db,folderName,spec,AtlCoolLib.athenaDesc(runLumi,'CondAttrListCollection'),cool.FolderVersioning.MULTI_VERSION)
 
    if(folder is None):
        sys.exit(1)
    
    return folderBulk(folder, folderName, spec, tag)
 

runLBtoDB()

def AFPAlignDBCreate.runLBtoDB	(		run,
			lb
	)

Turns run number and lumibock into integrer needed by the database

Definition at line 34 of file AFPAlignDBCreate.py.

def runLBtoDB(run,lb):
    """Turns run number and lumibock into integrer needed by the database"""
    return (run<<32) + lb