count_waiting = 0 main_flag = 0 else: print "waiting for Text and Excel" time.sleep(30) count_waiting = count_waiting+1 if count_waiting >30: count_waiting = 0 count_waiting1 = count_waiting1+1 if count_waiting1>5: main_flag = 0 #----------------- Start To Insert Data Into MYSQL Database---------------------- try: Insert_To_Sql(pdf_files,company,Request_id) convert_error =1 except Exception,e: print "Error in inserting to sql",str(e) #----------------- End To Insert Data Into MYSQL Database---------------------- time.sleep(5) listpath_converting = listpath.replace('_New','_Converted') if convert_error == 1: os.rename(listpath,listpath_converting) # if os.path.isfile(bat_xlsx):
start_date = datetime.now() status = 'Start External insert text in sql' Process_Head = 'Db Insert' Process_Name = 'Test Db Insert' Process_Time = '0' Current_Status = status Time_Stamp = str(start_date) # cal_end = end_date - start_date # Process_Time = str(cal_end.total_seconds()) call_log_new(Request_id, Process_Type, Process_Head, Process_Name, Process_Time, Current_Status, Time_Stamp) #------------------------ End Log Files ---------------------------------# #----------------- Start To Insert Data Into MYSQL Database---------------------- try: Insert_To_Sql(pdf_files, Request_id) convert_error = 1 except Exception, e: print "Error in inserting to sql", str(e) with open(test_error_log, 'a') as er: er.write(Request_id + '|' + 'Error in inserting Text to sql ' + str(e) + '|' + str(datetime.now()) + '\n') #----------------- End To Insert Data Into MYSQL Database---------------------- #------------------------ Start Log Files ---------------------------------# end_date = datetime.now() status = 'End External insert text in sql' Process_Head = 'Db Insert' Process_Name = 'Test Db Insert'