def recent_recipes(): page = request.args.get('page', default=1, type=int) limit = 8 recipes, page_count, recipe_count = Recipe.load_recipes(g.current_user, page=page, limit=limit) return render_template('recipes.html', recipes=recipes, page_count=page_count, page=page, current_query_params={})
def favorites(): page = request.args.get('page', default=1, type=int) limit = 16 recipes, page_count, recipe_count = Recipe.load_recipes(g.current_user, page=page, limit=limit, order_by='saved.saved_at DESC', join=['saved']) return render_template('recipes.html', recipes=recipes, page_count=page_count, page=page, current_query_params={})
def highest_rated_recipes(): page = request.args.get('page', default=1, type=int) limit = 8 recipes, page_count, recipe_count = Recipe.load_recipes(g.current_user, page=page, limit=limit, order_by='avg_ratings.avg_rating DESC', join=['avg_ratings'], where=['avg_ratings.avg_rating IS NOT NULL', 'avg_ratings.avg_rating >=3']) return render_template('recipes.html', recipes=recipes, page_count=page_count, page=page, current_query_params={})
def search_results(query=''): page = request.args.get('page', default=1, type=int) limit = 8 where_clause = "recipes.name ILIKE '%%%%%s%%%%'" % adapt(str(query.replace('+','%%'))).getquoted()[1:-1] start_time = timer() recipes, page_count, recipe_count = Recipe.load_recipes(g.current_user, page=page, limit=limit, where=[where_clause]) end_time = timer() natural_search_string = ' '.join(query.split('+')) return render_template('recipes.html', recipes=recipes, page_count=page_count, page=page, current_query_params={'query':query}, search_string=natural_search_string, success="We found %i result%s for '%s' (%.4f seconds)" % (recipe_count, ('s' if recipe_count != 1 else ''), natural_search_string, end_time - start_time))