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))
