Untitled

import sqlite3, sys

db = sqlite3.connect("db_tools.db")

cursor = db.cursor()

#Display all tables in DB
##cursor.execute("SELECT name FROM sqlite_master WHERE type='table'")
##rows = cursor.fetchall()
##for row in rows:
##   print(row)

#Display all fields in table
##cursor.execute("SELECT * FROM customer")
##col_names = cursor.description
##for col_name in col_names:
##   print(col_name[0])

#sys.exit()

#cursor.execute("SELECT a.item_id, description FROM invoice_item AS a, item AS b WHERE a.item_id = b.item_id AND invoice_id = 3401")
cursor.execute("SELECT first_name, last_name, customer.customer_id, invoice.invoice_id, item.item_id, description FROM customer, invoice, invoice_item, item WHERE first_name = 'Alice' AND customer.customer_id = invoice.customer_id AND invoice.invoice_id = invoice_item.invoice_id AND invoice_item.item_id = item.item_id")
rows = cursor.fetchall()
for row in rows:
    print(row)