try: start = time.time() LOGGER.info('********************************') LOGGER.info('** Touchstone v.3.0 **') LOGGER.info('********************************') LOGGER.info('\n********** Log header **********\n') LOGGER.info('Description: Disaggregation 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) disaggregation = Disaggregation(server) LOGGER.info('Server: ' + str(server)) except: LOGGER.error('Error: Check connection to database server') 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))
LOGGER.info('********************************') LOGGER.info('** Touchstone v.3.0 **') LOGGER.info('********************************') LOGGER.info('\n********** Log header **********\n') LOGGER.info('Description: Import Log Validation') LOGGER.info('Time Submitted: ' + str(datetime.datetime.now())) LOGGER.info('Status: Completed') LOGGER.info(OUTFILE) LOGGER.info(import_log) LOGGER.info('\n********** Log Import Options **********\n') parse_log_files(import_log, (OUTFILE[:-4] + '-Errors.txt')) data = pd.read_csv(OUTFILE[:-4] + '-Errors.txt', header=None, error_bad_lines=False, sep='|') data.columns = ['ContractID', 'LocationID', 'ErrorType', 'ErrorCode', 'Error'] db = Database('QA-TS-CI3-DB\SQL2012') for i in range(len(data)): try: script = 'SELECT ValidationErrorCode as ErrorCode, ValidationErrorMessage ' \ 'FROM [AIRReference].[dbo].[tValidationError] WHERE ValidationErrorCode = ' + str( data.ErrorCode[i]) db_data = copy.deepcopy(pd.read_sql(script, db.connection)) data.loc[i, 'ValidationErrorMessage'] = db_data.ValidationErrorMessage[0] except: pass data.to_csv(OUTFILE, index=False) LOGGER.info('----------------------------------------------------------------------------------') LOGGER.info(' Import Log Completed Successfully ') LOGGER.info('----------------------------------------------------------------------------------')