def truncate_table(session, argsql):
db = Database()
flag = True
count = 0
while flag and count <= 3 :
try:
for ite in argsql:
time.sleep(1)
db.execute_nonquery(session, ite)
session.commit()
flag = False
count +=1
logger = getLog('Sync_Data')
logger.info('Complete truncate table')
print "completed"
return 1
except Exception as e:
logerr = getLog('Error_Sync_Data')
logerr.error('Truncate table %s'%(e))
flag = True
count += 1
finally:
logger = getLog('Sync_Data')
logger.info('Final truncate table')
return 0
def truncate_table(self, argsql):
db = Database()
flag = True
count = 0
while flag and count <= 3 :
try:
for ite in argsql:
time.sleep(1)
db.execute_nonquery(self.session, ite)
self.session.commit()
flag = False
count +=1
return 1
except Exception as e:
self.logerr.error('Truncate table %s'%(e))
flag = True
count += 1
finally:
self.logger.info('Final truncate table')
return 0