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