def addRecipe(img_file, title, description, cat_code, servings, cooktime,
skillLevel, cuisine, ingredients, steps, user):
""" It adds a recipe, ingredients, recipe steps, recipe_user"""
try:
# Saves the img file in the directory
filename = img_file
print "IMG_FILE", img_file
# If img is not from a website
# if img_file and allowed_file(img_file.filename) and 'http' not in img_file:
# filename = secure_filename(img_file.filename)
# print "FILENAME" , filename
# img_file.save(os.path.join(UPLOAD_FOLDER, filename))
# Add recipe in 'recipes' Table
Recipe.addRecipe(title, description, filename, cat_code, servings,
cooktime, skillLevel, cuisine)
# Finds the recipe_id
recipeIds = db.session.query(func.max(Recipe.recipe_id)).one()
recipeFk = recipeIds[0]
print "RECIPE ID: ", recipeFk
# ingredients = ingredients
print "INGREDIENTS LIST", ingredients
for ingredient in ingredients:
name = ingredient["name"]
qty = ingredient["qty"]
unit = ingredient["unit"]
print "INGREDIENT UNICODE", ingredient
# Add ingredients in 'RecipeIngredient'
RecipeIngredient.addIngredients(recipeFk, name, qty, unit)
# Add ingredients in 'Ingredients'
Ingredient.addIngredients(name)
for i in range(len(steps)):
print "STEP%d" % i
print "step value: ", steps[i]
# Add steps in 'recipe_step'
RecipeStep.addRecipeStep(recipeFk, i + 1, steps[i])
if 'User' in session:
RecipeUser.addRecipeForUser(recipeFk, session['User'])
db.session.commit()
# Recipe.updateRecipeImg(title=title, cat_code=cat_code)
message = {'msg': "Recipe successfully added", 'recipeid': recipeFk}
return recipeFk
except Exception, error:
return "Error: %s" % error
def addRecipe(img_file, title, description, cat_code, servings,
cooktime, skillLevel, cuisine, ingredients, steps, user):
""" It adds a recipe, ingredients, recipe steps, recipe_user"""
try:
# Saves the img file in the directory
filename = img_file
print "IMG_FILE" ,img_file
# If img is not from a website
# if img_file and allowed_file(img_file.filename) and 'http' not in img_file:
# filename = secure_filename(img_file.filename)
# print "FILENAME" , filename
# img_file.save(os.path.join(UPLOAD_FOLDER, filename))
# Add recipe in 'recipes' Table
Recipe.addRecipe(title, description, filename, cat_code,
servings, cooktime, skillLevel,cuisine)
# Finds the recipe_id
recipeIds= db.session.query(func.max(Recipe.recipe_id)).one()
recipeFk = recipeIds[0]
print "RECIPE ID: ",recipeFk
# ingredients = ingredients
print "INGREDIENTS LIST", ingredients
for ingredient in ingredients:
name = ingredient["name"]
qty = ingredient["qty"]
unit = ingredient["unit"]
print "INGREDIENT UNICODE", ingredient
# Add ingredients in 'RecipeIngredient'
RecipeIngredient.addIngredients(recipeFk, name, qty, unit)
# Add ingredients in 'Ingredients'
Ingredient.addIngredients(name)
for i in range(len(steps)):
print "STEP%d" % i
print "step value: ", steps[i]
# Add steps in 'recipe_step'
RecipeStep.addRecipeStep(recipeFk,i+1,steps[i])
if 'User' in session:
RecipeUser.addRecipeForUser(recipeFk,session['User'])
db.session.commit()
# Recipe.updateRecipeImg(title=title, cat_code=cat_code)
message = {
'msg': "Recipe successfully added",
'recipeid': recipeFk
}
return recipeFk
except Exception, error:
return "Error: %s" % error
