def request_handler(request): info = [] if internet_on(): # ===================[ CONNECTION INQUIRIES] ============= if request[0] == 'ci': # Ask if api connected to 10. network if request[1] == 'inet': print "\n\tRequest to test server connection\n" if internet_on(): info.append("y") else: info.append("n") # Ask if api running at all if request[1] == 'ira': print "\n\tRequest to rest api connection\n" info.append("y") # ===================[ SELECT QUERIES ]=================== if request[0] == 's': # Select All future deliveries if request[1] == 'fd': info = SELECT.select_future_deliveries() if request[1] == 'pd': info = SELECT.select_past_deliveries() if request[1] == 'lnks': info = SELECT.select_links() if request[1] == 'inv': info = SELECT.select_inventory() if request[1] == 'sch': info = SELECT.select_schedule() if request[1] == 'rms': info = SELECT.select_rooms() if request[1] == 'rbi': info = SELECT.select_reservation_by_id(request[2]) ################## [EDITING] ################################### if request[1] == 'inir': info = SELECT.select_reserved_items_not_returned() # ===================[ UPDATE QUERIES ]=================== if request[0] == 'u': if request[1] == "rls": SQLS.output_update_to_screen("URLS") if request[1] == "spe": info = UPDATE.update_reservation_for_pickup(request) if request[1] == "sde": info = UPDATE.update_delivery_set_delivered(request) if request[1] == "eds": info = UPDATE.update_delivery_series(request) # ===================[ INSERT QUERIES ]=================== if request[0] == 'i': if request[1] == "rn": info = INSERT.insert_new_delivery_location(request[2]) if request[1] == "newr": info = INSERT.insert_new_delivery(request) # Update existing record SQLS.output_update_to_screen("Insert Requested") # ====================[ ADMIN QUERIES ]==================== if request[0] == 'a': if request[1] == 'lgn': info = ADMIN.admin_check_login(request) if request[1] == 'udbi': info = ADMIN.admin_edit_device_by_id(request[2]) if request[1] == 'add': info = ADMIN.admin_add_device(request[2]) if request[1] == 'rem': info = ADMIN.admin_remove_device(request[2]) if request[1] == 'frem': info = ADMIN.admin_do_remove_device(request[2]) if request[1] == 'chng': info = ADMIN.change_user_password(request) if request[1] == "fdel": info = ADMIN.proxy_select_future_reservations(request[2]) # Used to show the end of transfer reply = ''.join(info).replace('\n', ' ') reply += '\n' return reply else: print "NOT ABLE TO CONTACT SQL" return "NC\n"
def request_handler(request): info = [] # ===================[ SELECT QUERIES ]=================== if request[0] == 's': # Select All Receipts if request[1] == 'ar': info = SELECT.select_receipts_by_descriptor(request[2], request[3]) # Select Inventory if request[1] == 'ai': info = SELECT.select_inventory() if request[1] == 'inf': info = SELECT.select_sales_information() if request[1] == "dinf": info = SELECT.select_department_information() if request[1] == "lgn": info = SELECT.check_user_information(request) if request[1] == "rbmy": info = SELECT.select_receipt_for_report_by_month_year(request[2]) if request[1] == "rfdc": info = SELECT.select_receipts_for_drawer_close() if request[1] == "cbdr": info = SELECT.select_closings_by_date_range(request[2]) if request[1] == "rbi": info = SELECT.select_receipts_by_id_range(request[2]) # ===================[ INSERT QUERIES ]=================== if request[0] == 'i': if request[1] == 'nr': info = INSERT.new_receipt(request[2]) if request[1] == 'nii': info = INSERT.new_inventory_item(request[2]) if request[1] == 'inc': info = INSERT.insert_new_closing(request[2]) # ====================[ UPDATE QUERIES ]================== # precision if request[0] == 'u': if request[1] == 'rbi': info = UPDATE.update_receipt_by_id(request) if request[1] == 'ibi': info = UPDATE.update_item_by_id(request[2]) if request[1] == 'dibi': info = UPDATE.delete_item_by_id(request[2]) if request[1] == 'rdel': info = UPDATE.delete_receipt_by_id(request[2]) if request[1] == "cbi": info = UPDATE.closing_by_id(request) data_send = [] for el in info: data_send.append(el.replace('\n', '')) # Used to show the end of transfer data_send.append('\n') return ''.join(data_send)