# start with the sql query, þetta er rett hit var misskilningur
import sqlite3

# get connection to the database
con = sqlite3.connect('/Path/To/data/northwind.db')

#sql did not support utf-8
con.text_factory = str

# open the database
with con:

    # Get the cursor object
    cur = con.cursor()

    # make a query search
    cur.execute("""
    SELECT CustomerID, COUNT(Orders.OrderID), SUM(ODE.Quantity)
        FROM  Orders
        INNER JOIN "Order Details" Ode on Orders.OrderID = Ode.OrderID
        GROUP BY CustomerID
        ORDER BY COUNT(Orders.OrderID) desc
        LIMIT 10
    """)

    # Fetch the resulting data
    data = cur.fetchall()

# Print the result in a nice way
print "Results for exercise 4.3 (Make your own) Sql lite"
print
print "{CustomerID: <12} {TotalOrders: <14} {TotalQty: <14}".format(
    CustomerID = "Customer Id",TotalOrders = "Total orders", TotalQty = "Total quantity")
print "------------------------------------------"
for d in data:
    print "{CustomerID: <12} {TotalOrders: <14} {TotalQty: <14}".format(
        CustomerID = d[0],TotalOrders = d[1], TotalQty = d[2])

print
print "Total number of lines: {}".format(len(data))