def popular_product(): sales = spaza_shop.get_sales() most_pop = spaza_shop.get_most_pop_item(sales) cursor.execute("SELECT * FROM product_sold ORDER BY no_sold DESC LIMIT 0,1") data = cursor.fetchall() if len(data) is 0: return render_template("popular_product.html", result=most_pop) return render_template("popular_product.html", result2=data)
def test_get_most_pop_item(self): sales = spaza_shop.get_sales("Nelisa.csv") most_pop = spaza_shop.get_most_pop_item(sales) expected = {"Milk 1l" : 30} self.assertEquals(expected, most_pop)