43def createSqliteForAvg(sqliteName,folderName="/TDAQ/OLC/LHC/LBDATA3"):
44
45 dbSvc = cool.DatabaseSvcFactory.databaseService()
46
47 if os.access(sqliteName,os.R_OK):
48 msg.debug("UPDATING existing sqlite file %s" , sqliteName)
49 db=dbSvc.openDatabase("sqlite://;schema="+sqliteName+";dbname=CONDBR2",False)
50 else:
51 msg.debug("Creating new sqlite file %s" , sqliteName)
52 db=dbSvc.createDatabase("sqlite://;schema="+sqliteName+";dbname=CONDBR2")
53 pass
54
55
56
57 spec = cool.RecordSpecification()
58 spec.extend("Beam1Intensity",cool.StorageType.Float)
59 spec.extend("Beam2Intensity",cool.StorageType.Float)
60
61 spec.extend("Beam1IntensityAll",cool.StorageType.Float)
62 spec.extend("Beam2IntensityAll",cool.StorageType.Float)
63 spec.extend("Beam1IntensityStd",cool.StorageType.Float)
64 spec.extend("Beam2IntensityStd",cool.StorageType.Float)
65 spec.extend("Beam1IntensityAllStd",cool.StorageType.Float)
66 spec.extend("Beam2IntensityAllStd",cool.StorageType.Float)
67
68 spec.extend("RunLB",cool.StorageType.UInt63)
69 spec.extend("Valid",cool.StorageType.UInt32)
70
71
72
73 descr='<timeStamp>time</timeStamp><addrHeader><address_header service_type="71" clid="1238547719" /></addrHeader><typeName>CondAttrListCollection</typeName>'
74
75 if db.existsFolder(folderName):
76 msg.debug("folder exist")
77 folder=db.getFolder(folderName)
78 else:
79 msg.debug("Creating COOL folder/tag %s" , (folderName))
80 folderSpec = cool.FolderSpecification(cool.FolderVersioning.MULTI_VERSION, spec)
81 folder = db.createFolder(folderName, folderSpec, descr, True)
82 pass
83
84 return db,folder
85
86
87