def delete_alt_ingredient(ingredient_id, alt_ingredient_id):
alt_ingredient = models.IngredientAlternative.query \
.filter(models.IngredientAlternative.ingredient_id == ingredient_id,
models.IngredientAlternative.alt_ingredient_id == alt_ingredient_id).one()
db.session.delete(alt_ingredient)
db.session.commit()
ingredients_schema = models.IngredientSchema(
many=True, exclude=['alternatives', 'ingredient_alternative'])
ingredient = models.Ingredient.query.filter(
models.Ingredient.id == ingredient_id).one()
alt_ingredients = ingredient.alternatives.all()
return ingredients_schema.dump(alt_ingredients).data
def edit_ingredient(id, name=None, description=None, nutrition=None, is_allergen=None, type=None):
ingredient = models.Ingredient.query.filter(models.Ingredient.id == id).one()
ingredient.name = name or ingredient.name
ingredient.description = description or ingredient.description
ingredient.nutrition = description or ingredient.nutrition
ingredient.is_allergen = is_allergen or ingredient.is_allergen
ingredient.type = type or ingredient.type
db.session.commit()
ingredient_schema = models.IngredientSchema()
ingredient_tuple = collections.namedtuple('IngredientData', ['id', 'data'])
result = ingredient_tuple(id=ingredient.id, data=ingredient_schema.dump(ingredient).data)
return result
def get_ingredients():
ingredients_schema = models.IngredientSchema(many=True)
ingredients = models.Ingredient.query.all()
return ingredients_schema.dump(ingredients).data
def get_ingredient(_id):
ingredient_schema = models.IngredientSchema()
ingredient = models.Ingredient.query.filter(models.Ingredient.id == _id).one()
return ingredient_schema.dump(ingredient).data
def get_alt_ingredients(_id):
ingredients_schema = models.IngredientSchema(
many=True, exclude=['alternatives', 'ingredient_alternative'])
ingredient = models.Ingredient.query.filter(
models.Ingredient.id == _id).one()
return ingredients_schema.dump(ingredient.alternatives.all()).data