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'