My codes are as following…
Line 42 is starting with “system.db.runUpdateQuery”… Also line 15 already called to “APIcall” function.
Thank you for your interest…
def APIcall (last_updated):
#create param dictionary
L2Lparams = dict()
L2Lparams['offset'] = 0
L2Lparams['lastupdated__gte'] = last_updated
database_name = system.tag.read('[.]SQL Database Name').value
updated = False
while True:
return_value = L2LTR.getKaizen(L2Lparams)
if return_value['success']:
if len(return_value['data']) > 0 :
kaizens = return_value['data']
for kaizen in kaizens:
record = system.db.runQuery("select L2L_id from L2L_Kaizens where L2L_id='%s'" %kaizen['id'], database_name)
kaizen['line_ids'] = (str(kaizen['line_ids'])[1:-1]).replace('L','')
kaizen['area_ids'] = (str(kaizen['area_ids'])[1:-1]).replace('L','')
kaizen['machine_ids'] = (str(kaizen['machine_ids'])[1:-1]).replace('L','')
if record.getRowCount() > 0:
system.db.runUpdateQuery("update L2L_Kaizens set L2L_number='%(number)s', L2L_category='%(category)s', L2L_status='%(status)s', L2L_status_date='%(status_date)s', L2L_owner='%(owner)s', L2L_owner_assigned_date='%(owner_assigned_date)s', L2L_priority='%(priority)s', L2L_complete='%(complete)s', L2L_complete_date='%(complete_date)s', L2L_closed='%(closed)s', L2L_closed_date='%(closed_date)s', L2L_created='%(created)s', L2L_createdby='%(createdby)s', L2L_machine_ids='%(machine_ids)s', L2L_line_ids='%(line_ids)s', L2L_area_ids='%(area_ids)s', L2L_submittedby='%(submittedby)s' where L2L_id='%(id)s'" %kaizen, database_name)
else:
system.db.runUpdateQuery("INSERT INTO L2L_Kaizens VALUES ('%(id)s','%(number)s','%(category)s','%(status)s','%(status_date)s','%(owner)s','%(owner_assigned_date)s','%(priority)s','%(complete)s','%(complete_date)s','%(closed)s','%(closed_date)s','%(created)s','%(createdby)s', '%(machine_ids)s', '%(line_ids)s', '%(area_ids)s', '%(submittedby)s')" %kaizen, database_name)
if int(return_value['limit']) == len(return_value['data']):
L2Lparams['offset'] += int(return_value['limit'])
else:
updated = True
break
else:
break
return updated