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)
