try: loc_info = db.location_info_disagg(exposure_db, exposure_name) loc_info['ExchangeRate_Original'] = copy.deepcopy( loc_info['ExchangeRate']) loc_info.loc[loc_info['CurrencyCode'] == 'USD', 'ExchangeRate'] = 1.0 LOGGER.info('Exposure DB: ' + str(exposure_db)) LOGGER.info('Exposure Name: ' + str(exposure_name)) except: LOGGER.error('Error: Check the exposure db or exposure name') 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: staging_output = disaggregation.staging_table( analysis_sid, exposure_db) staging_output.to_csv(OUTFILE[:-4] + '-StagingTable.csv') except: LOGGER.error('Error: Failed to extract staging locations table') file_skeleton(OUTFILE) sys.exit()
LOGGER.info('\n********** Log header **********\n') LOGGER.info('Description: Analysis Option Validation') LOGGER.info('Time Submitted: ' + str(datetime.datetime.now())) LOGGER.info('Status: Completed') LOGGER.info('\n********** Log Import Options **********\n') # Initialize the connection with the server try: 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:
file_skeleton(OUTFILE) sys.exit() try: loc_info = db.location_info_disagg(exposure_db, exposure_name) loc_info['ExchangeRate_Original'] = copy.deepcopy(loc_info['ExchangeRate']) loc_info.loc[loc_info['CurrencyCode'] == 'USD', 'ExchangeRate'] = 1.0 LOGGER.info('Exposure DB: ' + str(exposure_db)) LOGGER.info('Exposure Name: ' + str(exposure_name)) except: LOGGER.error('Error: Check the exposure db or exposure name') 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: staging_output = disaggregation.staging_table(analysis_sid, exposure_db) staging_output.to_csv(OUTFILE[:-4] + '-StagingTable.csv') except: LOGGER.error('Error: Failed to extract staging locations table') file_skeleton(OUTFILE) sys.exit() try:
LOGGER.info('\n********** Log header **********\n') LOGGER.info('Description: Analysis Option Validation') LOGGER.info('Time Submitted: ' + str(datetime.datetime.now())) LOGGER.info('Status: Completed') LOGGER.info('\n********** Log Import Options **********\n') # Initialize the connection with the server try: 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 [