val_businesstriporder = row[1]['Business trip order'] val_purchaseorder = row[1]['Purchase order'] val_cct = row[1]['CCT'] val_emp = row[1]['EMP'] val_dpt = row[1]['DPT'] val_projectcode = row[1]['Project Code'] val_email = row[1]['e-mail Заказчика'] val_tst = row[1]['TST'] if val_customer == 'Client L': cubeSelect = 'clientl' if val_customer == 'Client P': continue if val_customer == 'Client C': continue if val_customer == 'Client D': continue #---------------------------------------- id_airline = id.detectid('Airline', 'Airline_name', val_airline, cursor, connection) id_class = id.detectid('Class', 'Class_name', val_class, cursor, connection) id_destination = id.detectid('Destination', 'Destination_name', val_dest, cursor, connection) id_region = id.detectid('Region', 'Region_name', val_region, cursor, connection) id_route = id.detectid('Route', 'Route_name', val_route, cursor, connection) id_state = id.detectid('State', 'State_name', val_state, cursor, connection)
val_businesstriporder = row[1]['Business trip order'] val_purchaseorder = row[1]['Purchase order'] val_cct = row[1]['CCT'] val_emp = row[1]['EMP'] val_dpt = row[1]['DPT'] val_projectcode = row[1]['Project Code'] val_email = row[1]['e-mail Заказчика'] val_tst = row[1]['TST'] if val_customer == 'Client L': continue if val_customer == 'Client P': cubeSelect = 'clientp' if val_customer == 'Client C': continue if val_customer == 'Client D': continue #---------------------------------------- id_airline = id.detectid('Airline', 'Airline_name', val_airline, cursor, connection) id_class = id.detectid('Class', 'Class_name', val_class, cursor, connection) id_destination = id.detectid('Destination', 'Destination_name', val_dest, cursor, connection) id_region = id.detectid('Region', 'Region_name', val_region, cursor, connection) id_route = id.detectid('Route', 'Route_name', val_route, cursor, connection) id_state = id.detectid('State', 'State_name', val_state, cursor, connection)
val_personalid = row[1]['Personal ID'] val_msp = row[1]['MSP'] val_departmentcode = row[1]['DEPARTMENT CODE'] val_purposeofthetrip = row[1]['Purpose of the trip'] val_apn = row[1]['APN'] val_businesstriporder = row[1]['Business trip order'] val_purchaseorder = row[1]['Purchase order'] val_cct = row[1]['CCT'] val_emp = row[1]['EMP'] val_dpt = row[1]['DPT'] val_projectcode = row[1]['Project Code'] val_email = row[1]['e-mail Заказчика'] val_tst = row[1]['TST'] #---------------------------------------- id_airline = id.detectid('Airline', 'Airline_name', val_airline, cursor, connection) id_class = id.detectid('Class', 'Class_name', val_class, cursor, connection) id_customer = id.detectid('Customer', 'Customer_name', val_customer, cursor, connection) id_destination = id.detectid('Destination', 'Destination_name', val_dest, cursor, connection) id_region = id.detectid('Region', 'Region_name', val_region, cursor, connection) id_route = id.detectid('Route', 'Route_name', val_route, cursor, connection)