def get_recipes(search_query): with recipe_db() as db: query = db.query(GET_RECIPES_QUERY) query.bind('$query', search_query or '') recipes = query.execute() return recipes.encode('utf8')
def get_menuplan_display(pk): with recipe_db() as db: q = db.query(GET_MENUPLAN_DISPLAY_QUERY) q.bind('$pk', pk) menuplans = q.execute() return menuplans.encode('utf8')
def get_menuplan_display(pk): with recipe_db() as db: q = db.query(GET_MENUPLAN_DISPLAY_QUERY) q.bind('$pk', pk) menuplans = q.execute() return menuplans.encode('utf8')
def get_recipes(search_query): with recipe_db() as db: query = db.query(GET_RECIPES_QUERY) query.bind('$query', search_query or '') recipes = query.execute() return recipes.encode('utf8')
def get_random_recipes(number_of_recipes=7, rating='Good'): with recipe_db() as db: query = db.query(GET_RANDOM_RECIPES_QUERY) query.bind('$num', str(number_of_recipes)) query.bind('$rating', str(rating or '')) recipes = query.execute() return recipes.encode('utf-8')
def get_random_recipes(number_of_recipes=7, rating='Good'): with recipe_db() as db: query = db.query(GET_RANDOM_RECIPES_QUERY) query.bind('$num', str(number_of_recipes)) query.bind('$rating', str(rating or '')) recipes = query.execute() return recipes.encode('utf-8')
def get_menuplans(query=None, offset=0, limit=500): with recipe_db() as db: q = db.query(GET_MENUPLANS_QUERY) q.bind('$offset', str(offset)) q.bind('$limit', str(limit)) q.bind('$query', str(query or '')) menuplans = q.execute() return menuplans.encode('utf8')
def get_recipe(pk): path = recipe_path(pk) with recipe_db() as db: query = db.query(GET_RECIPE_QUERY) query.bind('$path', path) recipe = query.execute() return recipe.encode('utf8')
def get_recipe(pk): path = recipe_path(pk) with recipe_db() as db: query = db.query(GET_RECIPE_QUERY) query.bind('$path', path) recipe = query.execute() return recipe.encode('utf8')
def get_menuplans(query=None, offset=0, limit=500): with recipe_db() as db: q = db.query(GET_MENUPLANS_QUERY) q.bind('$offset', str(offset)) q.bind('$limit', str(limit)) q.bind('$query', str(query or '')) menuplans = q.execute() return menuplans.encode('utf8')
def add_recipe(data): pk = str(uuid4()) recipe_xml = create_recipe_xml(pk, data['name'], data['people'], data['rating']) # Create a new document with recipe_db() as db: db.add(recipe_path(pk), et.tostring(recipe_xml)) return pk
def add_recipe(data): pk = str(uuid4()) recipe_xml = create_recipe_xml(pk, data['name'], data['people'], data['rating']) # Create a new document with recipe_db() as db: db.add(recipe_path(pk), et.tostring(recipe_xml)) return pk
def get_units(): with recipe_db() as db: query = db.query(GET_UNITS_QUERY) return query.execute().encode('utf8')
def detail(request, pk): with recipe_db() as db: recipe = et.fromstring(get_recipe(pk)) ingredient_options = get_ingredient_options() unit_options = get_unit_options() comment_options = get_comment_options() ingredients_data = [] for ing in recipe.findall('.//ingredient'): ingredients_data.append({ 'amount': ing.findtext('amount/value'), 'unit': ing.findtext('amount/unit'), 'name': ing.findtext('name'), 'comment': ing.findtext('comment'), }) instructions_data = [] for inst in recipe.findall('.//instruction'): instructions_data.append({ 'instruction': inst.findtext('text') }) form_kwargs = {'db': db} ingredients = IngredientFormSet(prefix='ingredient', initial=ingredients_data, form_kwargs=form_kwargs) instructions = InstructionFormSet(prefix='instruction', initial=instructions_data, form_kwargs=form_kwargs) if request.method == 'POST': form = RecipeDetailForm(request.POST) cp = request.POST.copy() if 'add_ingredient' in request.POST: cp['ingredient-TOTAL_FORMS'] = int(cp['ingredient-TOTAL_FORMS']) + 1 elif 'add_instruction' in request.POST: cp = request.POST.copy() cp['instruction-TOTAL_FORMS'] = int(cp['instruction-TOTAL_FORMS']) + 1 elif 'save' in request.POST: ingredients = IngredientFormSet(request.POST, prefix='ingredient', form_kwargs=form_kwargs) instructions = InstructionFormSet(request.POST, prefix='instruction', form_kwargs=form_kwargs) if form.is_valid() and ingredients.is_valid(): data = form.cleaned_data ingredient_data = [f.cleaned_data for f in ingredients.forms if f not in ingredients.deleted_forms] instruction_data = [f.cleaned_data for f in instructions.forms if f not in instructions.deleted_forms] with recipe_db() as db: db.replace(recipe_path(pk), et.tostring( create_recipe_xml( pk, data['name'], data['people'], data['rating'], ingredients=ingredient_data, instructions=instruction_data))) messages.add_message(request, messages.SUCCESS, 'Recipe %s saved' % data['name']) return redirect('recipes.detail', pk=pk) instructions = InstructionFormSet(cp, prefix='instruction', form_kwargs=form_kwargs) ingredients = IngredientFormSet(cp, prefix='ingredient', form_kwargs=form_kwargs) else: form = RecipeDetailForm({ 'name': recipe.findtext('name'), 'people': recipe.findtext('people'), 'rating': recipe.findtext('rating'), }) return render(request, 'recipes/detail.html', {'form': form, 'ingredients': ingredients, 'ingredients_helper': IngredientInlineHelper(), 'instructions': instructions, 'instructions_helper': InstructionInlineHelper(), 'pk': pk, 'ingredient_options': ingredient_options, 'unit_options': unit_options, 'comment_options': comment_options, })
def detail(request, pk): with recipe_db() as db: recipe = et.fromstring(get_recipe(pk)) ingredient_options = get_ingredient_options() unit_options = get_unit_options() comment_options = get_comment_options() ingredients_data = [] for ing in recipe.findall('.//ingredient'): ingredients_data.append({ 'amount': ing.findtext('amount/value'), 'unit': ing.findtext('amount/unit'), 'name': ing.findtext('name'), 'comment': ing.findtext('comment'), }) instructions_data = [] for inst in recipe.findall('.//instruction'): instructions_data.append({'instruction': inst.findtext('text')}) form_kwargs = {'db': db} ingredients = IngredientFormSet(prefix='ingredient', initial=ingredients_data, form_kwargs=form_kwargs) instructions = InstructionFormSet(prefix='instruction', initial=instructions_data, form_kwargs=form_kwargs) if request.method == 'POST': form = RecipeDetailForm(request.POST) cp = request.POST.copy() if 'add_ingredient' in request.POST: cp['ingredient-TOTAL_FORMS'] = int( cp['ingredient-TOTAL_FORMS']) + 1 elif 'add_instruction' in request.POST: cp = request.POST.copy() cp['instruction-TOTAL_FORMS'] = int( cp['instruction-TOTAL_FORMS']) + 1 elif 'save' in request.POST: ingredients = IngredientFormSet(request.POST, prefix='ingredient', form_kwargs=form_kwargs) instructions = InstructionFormSet(request.POST, prefix='instruction', form_kwargs=form_kwargs) if form.is_valid() and ingredients.is_valid(): data = form.cleaned_data ingredient_data = [ f.cleaned_data for f in ingredients.forms if f not in ingredients.deleted_forms ] instruction_data = [ f.cleaned_data for f in instructions.forms if f not in instructions.deleted_forms ] with recipe_db() as db: db.replace( recipe_path(pk), et.tostring( create_recipe_xml( pk, data['name'], data['people'], data['rating'], ingredients=ingredient_data, instructions=instruction_data))) messages.add_message(request, messages.SUCCESS, 'Recipe %s saved' % data['name']) return redirect('recipes.detail', pk=pk) instructions = InstructionFormSet(cp, prefix='instruction', form_kwargs=form_kwargs) ingredients = IngredientFormSet(cp, prefix='ingredient', form_kwargs=form_kwargs) else: form = RecipeDetailForm({ 'name': recipe.findtext('name'), 'people': recipe.findtext('people'), 'rating': recipe.findtext('rating'), }) return render( request, 'recipes/detail.html', { 'form': form, 'ingredients': ingredients, 'ingredients_helper': IngredientInlineHelper(), 'instructions': instructions, 'instructions_helper': InstructionInlineHelper(), 'pk': pk, 'ingredient_options': ingredient_options, 'unit_options': unit_options, 'comment_options': comment_options, })
def get_units(): with recipe_db() as db: query = db.query(GET_UNITS_QUERY) return query.execute().encode('utf8')
def get_ingredients(): with recipe_db() as db: query = db.query(GET_INGREDIENTS_QUERY) return query.execute().encode('utf8')
def get_comments(): with recipe_db() as db: query = db.query(GET_COMMENTS_QUERY) return query.execute().encode('utf8')
def get_ingredients(): with recipe_db() as db: query = db.query(GET_INGREDIENTS_QUERY) return query.execute().encode('utf8')
def add_menuplan(pk, menuplan): with recipe_db() as db: db.add(menuplan_path(pk), menuplan)
def get_comments(): with recipe_db() as db: query = db.query(GET_COMMENTS_QUERY) return query.execute().encode('utf8')
def add_menuplan(pk, menuplan): with recipe_db() as db: db.add(menuplan_path(pk), menuplan)