import requests from previous import json_with_dates PORT = 8000 response = requests.get( "http://localhost:8000/chinook/items/invoices/customers") table = json_with_dates.loads(response.text) for row in table: print(row)
import requests from previous.json_with_dates import loads PORT = 54321 r = requests.get("http://localhost:{}/chinook/customer".format(PORT)) customers = loads(r.text) #print(customers) for customer_row in customers: cust_id = customer_row[0] # print(cust_id) r = requests.get("http://localhost:{}/chinook/invoice/customer/{}".format( PORT, cust_id)) invoices = loads(r.text) # print(invoices) total_invoice = 0 num_tracks = 0 for invoice_row in invoices: total_invoice += invoice_row[8] r = requests.get( "http://localhost:{}/chinook/invoice-item/invoice/{}".format( PORT, invoice_row[0])) invoice_items = loads(r.text) for invoiceItem_row in invoice_items: num_tracks += 1 template = "{:3} {:15} {:15} {:3} {:8.2f}"
import requests from previous.json_with_dates import loads PORT = 54321 r = requests.get("http://localhost:{}/chinook/customer".format(PORT)) customers = loads(r.text) #print(customers) for customer_row in customers: cust_id = customer_row[0] # print(cust_id) r = requests.get( "http://localhost:{}/chinook/invoice-item/invoice/customer/{}".format( PORT, cust_id)) inv_ii = loads(r.text) # print(invoices) num_tracks = len(inv_ii) total_invoice = 0 for i in range(num_tracks): if i == 0: total_invoice += inv_ii[i][0] elif inv_ii[i][1] != inv_ii[i - 1][0]: total_invoice += inv_ii[i][0] else: pass # do nothing template = "{:3} {:15} {:15} {:3} {:8.2f}" line = template.format(cust_id, customer_row[2], customer_row[1],
import requests from previous.json_with_dates import loads PORT = 21212 area_request = requests.get("http://localhost:21212/measures/area") areas = loads(area_request.text) count = 1 for area in areas: area_id = area[0] location_request = requests.get( "http://localhost:21212/measures/area/location/{}".format(area_id)) num_location = loads(location_request.text) for i in num_location: print(i) #print("all areas:") #for area in areas: #print(area)
import requests from previous.json_with_dates import loads PORT = 8000 r = requests.get("http://localhost:8000/chinook/items/invoices/customers") rows = loads(r.text) last_cust_id = -1 last_invoice_id = -1 last_fname = None last_lname = None running_tot = None running_count = None for (cust_id, fname, lname, inv_id, inv_tot) in rows: if cust_id != last_cust_id: if last_cust_id >= 0: template = "{:3} {:15} {:15} {:3} {:8.2f}" line = template.format(last_cust_id, last_fname, last_lname, running_count, running_tot) print(line) running_tot = 0 running_count = 0 last_cust_id = cust_id last_fname = fname last_lname = lname elif inv_id != last_invoice_id: running_tot += inv_tot last_invoice_id = inv_id running_count += 1
import requests from previous import json_with_dates PORT = 8000 custResponse = requests.get("http://localhost:8000/chinook/customer") # print(custResponse.text) # print(custResponse.text[0]) customers = json_with_dates.loads(custResponse.text) # print(customers) # print(customers[0]) for customer in customers: cust_id = customer[0] invoiceResponse = requests.get( "http://localhost:{}/chinook/invoice/customer/{}".format( PORT, cust_id)) invoices = json_with_dates.loads(invoiceResponse.text) # print(invoices) # print(invoices[0]) total = 0 for invoice in invoices: invoice_id = invoice[0] total += invoice[8] item_response = requests.get( "http://localhost:{}/chinook/invoice-item/invoice/{}".format( PORT, invoice_id))