db = Database(server)
except:
LOGGER.error('Error: Check connection to database server')
file_skeleton(OUTFILE)
sys.exit()
try:
analysis_sid = db.analysis_sid(analysis_name)
LOGGER.info('Analysis SID: ' + str(analysis_sid))
except:
LOGGER.error('Error: Failed to extract the analysis SID from analysis name')
file_skeleton(OUTFILE)
sys.exit()
try:
analysis_information = db.analysis_option(analysis_sid)
except:
LOGGER.error('Error: Unable to fetch analysis option details')
file_skeleton(OUTFILE)
sys.exit()
if analysis_information['AnalysisTypeCode'].values[0] in ['LGRP', 'IMPACT']:
try:
get_analysis = db.get_analysis(analysis_sid)
analyses = get_analysis.iloc[:, 0].values
for i in range (len(analyses)):
analysis_sid = db.analysis_sid(analyses[i])
analysis_information = pd.concat([analysis_information, db.analysis_option(analysis_sid)], axis=0)
except:
LOGGER.error('Error: Failed to append secondary analysis')
file_skeleton(OUTFILE)
except:
LOGGER.error('Error: Check connection to database server')
file_skeleton(OUTFILE)
sys.exit()
try:
analysis_sid = db.analysis_sid(analysis_name)
LOGGER.info('Analysis SID: ' + str(analysis_sid))
except:
LOGGER.error(
'Error: Failed to extract the analysis SID from analysis name')
file_skeleton(OUTFILE)
sys.exit()
try:
analysis_information = db.analysis_option(analysis_sid)
except:
LOGGER.error('Error: Unable to fetch analysis option details')
file_skeleton(OUTFILE)
sys.exit()
if analysis_information['AnalysisTypeCode'].values[0] in [
'LGRP', 'IMPACT'
]:
try:
get_analysis = db.get_analysis(analysis_sid)
analyses = get_analysis.iloc[:, 0].values
for i in range(len(analyses)):
analysis_sid = db.analysis_sid(analyses[i])
analysis_information = pd.concat([
analysis_information,
