54def createMDTConditionDBNoisy():
55 import os
56 from PyCool import cool
57
58
59 dbSvc = cool.DatabaseSvcFactory.databaseService()
60
61
62 dbstring = 'sqlite://;schema=MDTDQMFOFFLINE_NOISY.db;dbname=MDT_DQA'
63
64 if os.access('MDTDQMFOFFLINE_NOISY.db', os.R_OK):
65 try:
66 os.unlink('MDTDQMFOFFLINE_NOISY.db')
67 except Exception as e:
68 print(
'Unable to remove existing db file, reason', e)
69 try:
70 db = dbSvc.createDatabase(dbstring)
71 except Exception as e:
72 print(
'Problem creating database', e)
73 return
74
75
76 spec2 = cool.RecordSpecification()
77 spec2.extend("Chamber_Name", cool.StorageType.String255)
78 spec2.extend("Noisy_multilayer", cool.StorageType.String255)
79 spec2.extend("Noisy_layer", cool.StorageType.String255)
80 spec2.extend("Noisy_mezz", cool.StorageType.String255)
81 spec2.extend("Noisy_asd", cool.StorageType.String255)
82 spec2.extend("Noisy_tube", cool.StorageType.String4k)
83
84 desc = "<timeStamp>run-lumi</timeStamp><addrHeader><address_header service_type=\"71\" clid=\"1238547719\" /></addrHeader><typeName>CondAttrListCollection</typeName>"
85
86
87
88
89
90
91 folderSpec = cool.FolderSpecification(
92 cool.FolderVersioning.MULTI_VERSION, spec2)
93 db.createFolder(
94 "/OFFLINE/DQMFOFFLINE/DQMFOFFLINE_NOISY", folderSpec, desc, True)
95 db.closeDatabase()