def getOrders(username): db = sqlite3.connect("users.db") c = db.cursor() c.execute("SELECT isbn,quantity FROM orders WHERE username = ?", (username,)) books = [] for isbn, quantity in c.fetchall(): book = bookhelper.getBook(isbn) book["quantity"] = quantity books.append(book) return books
def bookDetail(isbn): if bookhelper.getBook(isbn) != None: bookDetailFile = open("bookDetail.html", "r") bookDetail = bookDetailFile.read() bookDetailFile.close() book = bookhelper.getBook(isbn) book["header"] = getHeader() book["releasedate"] = fancyDate(book["releasedate"]) if userhelper.isLoggedIn(): book["disabled"] = "" book["cartmessage"] = "Add to Cart" else: book["disabled"] = "disabled" book["cartmessage"] = "Login to purchase" book["username"] = userhelper.getCurrentUser() return bookDetail % book else: return error()
def getOrdersPrice(username): db = sqlite3.connect("users.db") c = db.cursor() c.execute("SELECT isbn,quantity FROM orders WHERE username = ?", (username,)) price = 0.0 for isbn, quantity in c.fetchall(): book = bookhelper.getBook(isbn) bookPrice = float(book["price"][1:]) price += bookPrice*quantity if price == 0: return "" return "${0:.2f}".format(round(price,2))