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('----------------------------------------------------------------------------------')
