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))
