Utilities/test/caloL1Dump.py

0001 # select CALOL1_KEY from CMS_TRG_L1_CONF.L1_TRG_CONF_KEYS where ID='collisions2016_TSC/v206' ;
0002 import re
0003 import os, sys, shutil
0004 import subprocess
0005 """
0006 A simple helper script that provided with no arguments dumps a list of
0007 top-level keys, and provided with any key from this list as an argument,
0008 dumps a list of sub-keys and saves corresponding configuration to local
0009 files.
0010 """
0011
0012 # connection string
0013 sqlplusCmd = ['env',
0014               'sqlplus',
0015               '-S',
0016               'cms_trg_r/X3lmdvu4@cms_omds_adg'
0017              ]
0018
0019 if hash( sqlplusCmd[-1] ) != 1687624727082866629:
0020     print('Do not forget to plug password to this script')
0021     print('Exiting.')
0022     exit(0)
0023
0024 myre = re.compile(r'(ID)|(-{80})')
0025
0026 # if no arguments are given, query the top level keys only and exit
0027 if len(sys.argv) == 1:
0028     sqlplus = subprocess.Popen(sqlplusCmd, shell=False, stdout=subprocess.PIPE, stdin=subprocess.PIPE)
0029     print('No args specified, querying and printing only top-level keys:')
0030     for line in re.split('\n',sqlplus.communicate('select unique ID from CMS_TRG_L1_CONF.CALOL2_KEYS;')[0]):
0031         if myre.search(line) == None :
0032             print(line)
0033     print('Pick any of these keys as an argument next time you run this script')
0034     exit(0)
0035
0036 # if an argument is given query the whole content of the key
0037 key = sys.argv[1]
0038
0039 sqlplus = subprocess.Popen(sqlplusCmd,
0040                            shell=False,
0041                            stdout=subprocess.PIPE,
0042                            stdin=subprocess.PIPE
0043                           )
0044
0045 queryKey = "select CALOL1_KEY from CMS_TRG_L1_CONF.L1_TRG_CONF_KEYS where ID='{0}'".format(key)
0046
0047 for line in re.split('\n',sqlplus.communicate(queryKey+';')[0]):
0048     print(line)
0049     if re.search('/v',line) :
0050         key=line
0051
0052 print(key)
0053
0054 queryKeys = """
0055             select
0056                 HW, ALGO, INFRA
0057             from
0058                 CMS_TRG_L1_CONF.CALOL1_KEYS
0059             where
0060                 ID = '{0}'
0061             """.format(key)
0062
0063 # write results for specific configs to the following files
0064 batch = {
0065          'HW'    : 'hw.xml',
0066          'ALGO'  : 'algo.xml',
0067          'INFRA' : 'infra.xml'
0068         }
0069
0070 # do the main job here
0071 for config,fileName in batch.items():
0072     sqlplus = subprocess.Popen(sqlplusCmd, shell=False, stdout=subprocess.PIPE, stdin=subprocess.PIPE)
0073
0074     with open(fileName,'w') as f:
0075         query = """
0076                 select
0077                     CONF.CONF
0078                 from
0079                     CMS_TRG_L1_CONF.CALOL1_CLOBS CONF, ({0}) KEY
0080                 where
0081                     CONF.ID = KEY.{1}
0082                 """.format(queryKeys, config)
0083
0084         for line in re.split('\n',sqlplus.communicate('\n'.join(['set linesize 200', 'set longchunksize 2000000 long 2000000 pages 0',query+';']))[0]):
0085             f.write('\n')
0086             f.write(line)
0087         f.close()
0088
0089 sqlplus = subprocess.Popen(sqlplusCmd, shell=False, stdout=subprocess.PIPE, stdin=subprocess.PIPE)
0090 print('Following keys were found:')
0091 for line in re.split('\n',sqlplus.communicate(queryKeys+';')[0]):
0092     print(line)
0093
0094
0095 print('Results are saved in ' + ' '.join(batch.values()) + ' files')
0096
0097