def get_client_recipes(client_id):
client_recipes_schema = models.RecipeSchema(many=True)
recipes = db.session.query(models.Recipe) \
.join(models.client_recipes) \
.join(models.Client) \
.filter(models.Client.id == client_id, models.Client.id == models.client_recipes.c.client_id).all()
return client_recipes_schema.dump(recipes).data
def get_client_recipe(client_id, recipe_id):
recipe_schema = models.RecipeSchema()
# recipe = models.Recipe.query.filter(models.Client.id == client_id, models.Recipe.id == recipe_id).one()
recipe = db.session.query(models.Recipe) \
.join(models.client_recipes) \
.join(models.Client) \
.filter(models.Client.id == client_id, models.Client.id == models.client_recipes.c.client_id,
models.client_recipes.c.recipe_id == recipe_id).one()
return recipe_schema.dump(recipe).data
def create_recipe(name, description=None, style=None, type=None):
recipe = models.Recipe()
recipe.name = name or None
recipe.description = description or None
recipe.style = style or None
recipe.type = type or None
db.session.add(recipe)
db.session.commit()
recipe_schema = models.RecipeSchema()
recipe_tuple = collections.namedtuple('RecipeData', ['id', 'data'])
result = recipe_tuple(id=recipe.id, data=recipe_schema.dump(recipe).data)
return result
def edit_recipe(recipe_id, recipe_name, description=None, style=None, type=None):
recipe = models.Recipe.query.filter(models.Recipe.id == recipe_id).one()
recipe.name = recipe_name or recipe.name
recipe.description = description or recipe.description
recipe.style = style or recipe.style
recipe.type = type or recipe.type
db.session.commit()
recipe_schema = models.RecipeSchema()
recipe_tuple = collections.namedtuple('RecipeData', ['id', 'data'])
result = recipe_tuple(id=recipe.id, data=recipe_schema.dump(recipe).data)
return result
def create_client_recipe(client_id, recipe_name, description=None, style=None, type=None):
client = models.Client.query.filter(models.Client.id == client_id).one()
recipe = models.Recipe()
recipe.name = recipe_name
recipe.description = description
recipe.style = style
recipe.type = type
client.add_recipe(recipe)
db.session.commit()
recipe_schema = models.RecipeSchema()
recipe_tuple = collections.namedtuple('RecipeData', ['id', 'data'])
result = recipe_tuple(id=recipe.id, data=recipe_schema.dump(recipe).data)
return result
def get_recipes():
recipes_schema = models.RecipeSchema(many=True)
recipes = models.Recipe.query.all()
return recipes_schema.dump(recipes).data
def get_recipe(recipe_id):
recipe_schema = models.RecipeSchema()
recipe = models.Recipe.query.filter(models.Recipe.id == recipe_id).one()
print(recipe)
return recipe_schema.dump(recipe).data
def get_menu_recipes(menu_id):
client_recipes_schema = models.RecipeSchema(many=True)
recipes = db.session.query(models.Recipe) \
.join(models.MenuRecipe) \
.filter(models.MenuRecipe.menu_id == menu_id).all()
return client_recipes_schema.dump(recipes).data
def get_menu_recipe(menu_id, recipe_id):
recipe_schema = models.RecipeSchema()
recipe = db.session.query(models.Recipe) \
.join(models.MenuRecipe) \
.filter(models.MenuRecipe.menu_id == menu_id, models.MenuRecipe.recipe_id == models.Recipe.id).one()
return recipe_schema.dump(recipe).data
