10def createRPCDQMFDB():
11 import os
12 from PyCool import cool
13
14
15 dbSvc = cool.DatabaseSvcFactory.databaseService()
16
17 dbstring = 'sqlite://;schema=RPCDQMFOFFLINE.db;dbname=RPC_DQA'
18 if os.access('RPCDQMFOFFLINE.db', os.R_OK):
19 try:
20 os.unlink('RPCDQMFOFFLINE.db')
21 except Exception as e:
22 print(
'Unable to remove existing db file, reason', e)
23 try:
24 db = dbSvc.createDatabase(dbstring)
25 except Exception as e:
26 print(
'Problem creating database', e)
27 return
28 print(
"Created database", dbstring)
29
30 spec2 = cool.RecordSpecification()
31 spec2.extend("recEta", cool.StorageType.String4k)
32 spec2.extend("detEta", cool.StorageType.String4k)
33 spec2.extend("recPhi1", cool.StorageType.String4k)
34 spec2.extend("recPhi2", cool.StorageType.String4k)
35 spec2.extend("detPhi1", cool.StorageType.String4k)
36 spec2.extend("detPhi2", cool.StorageType.String4k)
37
38
39 desc = "<timeStamp>run-lumi</timeStamp><addrHeader><address_header service_type=\"71\" clid=\"1238547719\" /></addrHeader><typeName>CondAttrListCollection</typeName>"
40
41
42
43
44
45 folderSpec = cool.FolderSpecification(
46 cool.FolderVersioning.MULTI_VERSION, spec2)
47 db.createFolder('/OFFLINE/OFFLINE_DQMF', folderSpec, desc, True)
48 db.closeDatabase()
49
50