Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- self.query_headers = "([ac_serial_reg_key],[activity_date],
- [aircraft_delivery_date],[activity_name],[activity_remark],
- [aircraft_category],[aircraft_financial_status],[aircraft_group],
- [aircraft_model],[aircraft_operational_status],[aircraft_registration_number], [aircraft_serial_number],
- [aircraft_type],[engine_model],[engine_type],[operator_name]
- )"
- self.query_values = ''
- for idx, set in enumerate(self.response.json()['results'], start=1):
- self.query_values += "("
- self.query_values += "'"+str(set['aircraft_registration_number'])+"_"+str(set['aircraft_serial_number'])+"',"
- self.query_values += self.validate_date(set['activity_date'])+","
- self.query_values += self.validate_date(set['aircraft_delivery_date'])+","
- self.query_values += "'"+str(set['activity_name'])+"',"
- self.query_values += "'"+str(set['activity_remark'])+"',"
- self.query_values += "'"+str(set['aircraft_category'])+"',"
- self.query_values += "'"+str(set['aircraft_financial_status'])+"',"
- self.query_values += "'"+str(set['aircraft_group'])+"',"
- self.query_values += "'"+str(set['aircraft_model'])+"',"
- self.query_values += "'"+str(set['aircraft_operational_status'])+"',"
- self.query_values += "'"+str(set['aircraft_registration_number'])+"',"
- self.query_values += "'"+str(set['aircraft_serial_number'])+"',"
- self.query_values += "'"+str(set['aircraft_type_lar'])+"',"
- self.query_values += "'"+str(set['engine_model'])+"',"
- self.query_values += "'"+str(set['engine_type'])+"',"
- self.query_values += "'"+str(set['operator_name'])+"'"
- self.query_values += ")"
- if idx < self.response.json()['results_this_page']:
- self.query_values += ","
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement