def get_favourites():
if request.method == 'GET':
favourites = Favourite.get_all()
results = []
for fav in favourites:
obj = {
'id': fav.id,
'user_id': fav.user_id,
'product_id': fav.product_id
}
results.append(obj)
Response = jsonify(results)
Response.status_code = 200
return Response
def get_top5_favourites():
if request.method == 'GET':
favourites = Favourite.get_all()
result = []
for fav in favourites:
count = db.session.query(Favourite).filter(
Favourite.product_id == fav.product_id).count()
result.append((fav.product_id, count))
result = set(result)
result = list(result)
result = sorted(result, key=itemgetter(1), reverse=True)
result = result[:5]
res = []
for item in result:
product = db.session.query(Product).get(item[0])
obj = {
'id': product.id,
'name': product.name,
'description': product.description,
'category_id': product.category_id,
'proof': str(product.proof),
'country': product.country,
'available': product.available,
'price': str(product.price),
'picture': product.picture,
'count': item[1]
}
res.append(obj)
Response = jsonify(res)
Response.status_code = 200
return Response
