コード例 #1
0
def newIngredient():
    if request.method == 'POST':
        newIngredient = Ingredient(name = request.form['name'])
        session.add(newIngredient)
        session.commit()
        flash("new ingredient item created!")
        return redirect(url_for('showIngredients'))
    else:
        return render_template('newIngredient.html')
コード例 #2
0
    jsondata=json.loads(data)


# Add Fake User
User1 = User(name="Admin", email="*****@*****.**",
             picture='https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png')
session.add(User1)
session.commit()



for obj in jsondata:
    if session.query(Category).filter_by(name=obj['category']).one_or_none() is None:
        cat1 = Category(name=obj['category'], user_id=User1.id)
        session.add(cat1)
        session.commit()
    cat1= session.query(Category).filter_by(name=obj['category']).one()
    if session.query(Menu).filter_by(name=obj['name']).one_or_none() is None:
        menu1 = Menu(name=obj['name'], category_id=cat1.id, picture=obj['picture'], servings=obj['servings'], calories=obj['cal/serv'], user_id=cat1.user_id, hour=obj['time']['hour'], minute=obj['time']['minute'])
        session.add(menu1)
        session.commit()
        menu1 = session.query(Menu).filter_by(name=obj['name']).one()
        for ingre in obj['ingredients']:
            ingredient = Ingredient(amount=ingre['amount'], description=ingre['description'], menu_id=menu1.id)
            session.add(ingredient)
            session.commit()
        for direction in obj['directions']:
            direct = Direction(direction=direction, menu_id=menu1.id)
            session.add(direct)
            session.commit()
コード例 #3
0
ファイル: project.py プロジェクト: joshbriand/html
def editRecipe(recipe_id):
    '''handler to edit an existing recipe'''
    # change first list elements of cuisines and meals to 'choose one' from
    # 'all'
    cuisines[0] = "Choose One"
    meals[0] = "Choose One"
    if recipeExists(recipe_id):
        # if recipe if exists in database
        # query author, ingredients and process recipe from database
        author = session.query(Recipe).filter_by(id=recipe_id).one().user
        recipeToEdit = session.query(Recipe).filter_by(id=recipe_id).one()
        oldIngredients = session.query(
            Ingredient).filter_by(recipe_id=recipe_id).all()
        oldProcesses = session.query(Process).filter_by(
            recipe_id=recipe_id).all()
        if 'username' in login_session:
            if author.id == login_session['user_id']:
                # if author and user have the same user id
                # essentially the same process as used in creating a recipe
                if request.method == "POST":
                    error = ""
                    if request.form['cuisine'] == "Choose One":
                        error = "You must choose a cuisine type!"
                    elif request.form['meal'] == "Choose One":
                        error = "You must choose a meal type!"
                    cuisine = request.form['cuisine']
                    meal = request.form['meal']
                    name = request.form['name']
                    ingredients = request.form['ingredients']
                    ingredientList = ingredients.split("\n")
                    process = request.form['process']
                    processList = process.split("\n")
                    picture = request.form['picture']
                    if picture == "":
                        # generic food image in case user does not include one
                        picture = "https://upload.wikimedia.org/wikipedia/commons/thumb/6/6d/Good_Food_Display_-_NCI_Visuals_Online.jpg/1024px-Good_Food_Display_-_NCI_Visuals_Online.jpg"
                    user_id = login_session['user_id']
                    date = datetime.now()
                    if error != "":
                        flash(error)
                        return render_template(
                            'editrecipe.html',
                            name=name,
                            ingredients=ingredients,
                            process=process,
                            picture=picture,
                            cuisine=cuisine,
                            meal=meal,
                            meals=meals,
                            cuisines=cuisines)
                    recipeToEdit.name = name
                    recipeToEdit.cuisine = cuisine
                    recipeToEdit.meal = meal
                    recipeToEdit.date = date
                    recipeToEdit.picture = picture
                    # update values of recipe to new values
                    session.add(recipeToEdit)
                    session.commit()
                    # delete old ingredients from database
                    for ingredient in oldIngredients:
                        session.delete(ingredient)
                        session.commit()
                    # add new ingredients to database
                    for ingredient in ingredientList:
                        newIngredient = Ingredient(
                            ingredient=ingredient, recipe_id=recipe_id)
                        session.add(newIngredient)
                        session.commit()
                    # delete old process from database
                    for process in oldProcesses:
                        session.delete(process)
                        session.commit()
                    # add new process to database
                    for process in processList:
                        newProcess = Process(
                            process=process, recipe_id=recipe_id)
                        session.add(newProcess)
                        session.commit()
                    flash(
                        'New Recipe %s Successfully Editted' %
                        recipeToEdit.name)
                    return redirect(url_for('showRecipe', recipe_id=recipe_id))
                else:
                    ingredientString = ""
                    for ingredient in oldIngredients:
                        ingredientString += ingredient.ingredient + "\n"
                    processString = ""
                    for process in oldProcesses:
                        processString += process.process + "\n"
                    return render_template(
                        'editrecipe.html',
                        recipe=recipeToEdit,
                        ingredientString=ingredientString,
                        processString=processString,
                        meals=meals,
                        cuisines=cuisines)
            else:
                # redirect and error if user id is not equal to author id
                flash('You are not authorized to edit this recipe')
                return redirect(url_for('showRecipe', recipe_id=recipe_id))
        else:
            # redirect and error if user is not logged in
            flash('User not logged in')
            return redirect(url_for('showRecipe', recipe_id=recipe_id))
    else:
        # redirect and error if recipe does not exist
        flash('Recipe does not exist')
    return redirect('/')
コード例 #4
0
ファイル: project.py プロジェクト: joshbriand/html
def addRecipe():
    '''handler for adding a new recipe'''
    # change first list elements of cuisines and meals to 'choose one' from
    # 'all'
    cuisines[0] = "Choose One"
    meals[0] = "Choose One"
    if request.method == 'POST':
        error = ""
        if request.form['cuisine'] == "Choose One":
            # error is user submits a recipe and doesn't choose a cuisine type
            error = "You must choose a cuisine type!"
        elif request.form['meal'] == "Choose One":
            # error is user submits a recipe and doesn't choose a meal type
            error = "You must choose a meal type!"
        cuisine = request.form['cuisine']
        meal = request.form['meal']
        name = request.form['name']
        ingredients = request.form['ingredients']
        '''splits ingredient list into individual elements, not useful in this
        iteration of the web app, but included in case the ability to look up
        recipes by ingredient is introduced in a future version'''
        ingredientList = ingredients.split("\n")
        process = request.form['process']
        processList = process.split("\n")
        picture = request.form['picture']
        if picture == "":
            # generic food image in case user does not include one
            picture = "https://upload.wikimedia.org/wikipedia/commons/thumb/6/6d/Good_Food_Display_-_NCI_Visuals_Online.jpg/1024px-Good_Food_Display_-_NCI_Visuals_Online.jpg"
        user_id = login_session['user_id']
        date = datetime.now()
        if error != "":
            '''if there is an error, rerender webpage with prefilled out form and
            error message'''
            flash(error)
            return render_template(
                'addrecipe.html',
                name=name,
                ingredients=ingredients,
                process=process,
                picture=picture,
                cuisine=cuisine,
                meal=meal,
                meals=meals,
                cuisines=cuisines)
        # commit new recipe to database
        newRecipe = Recipe(
            name=name,
            cuisine=cuisine,
            meal=meal,
            date=date,
            picture=picture,
            user_id=user_id)
        session.add(newRecipe)
        session.commit()
        recipe_id = session.query(Recipe).filter_by(name=name).one().id
        for ingredient in ingredientList:
            # commit individual ingredients to database
            newIngredient = Ingredient(
                ingredient=ingredient, recipe_id=recipe_id)
            session.add(newIngredient)
            session.commit()
        for process in processList:
            # commit individual method steps to database
            newProcess = Process(process=process, recipe_id=recipe_id)
            session.add(newProcess)
            session.commit()
        # redirect user to newly created recipe webpage and success message
        flash('New Recipe %s Successfully Created' % newRecipe.name)
        return redirect(url_for('showRecipe', recipe_id=recipe_id))
        # return to recipe (no s!)
    else:
        if 'username' not in login_session:
            # redirect to '/' if user not logged in, error message
            flash('User not logged in')
            return redirect('/')
        else:
            return render_template(
                'addrecipe.html',
                meals=meals,
                cuisines=cuisines)
コード例 #5
0
newUser = User(name="Sean Casey", email="*****@*****.**")
session.add(newUser)
session.commit()
print "Added users"
newRecipe = Recipe(
    name="Panko Fish",
    cuisine="Japanese",
    meal="Dinner",
    date=datetime.now(),
    picture=
    "https://www.takemefishing.org/tmf/assets/images/fish/albacore-464x170.png",
    user_id=2)
session.add(newRecipe)
session.commit()
recipe_id = session.query(Recipe).filter_by(user_id=2).first().id
newIngredient = Ingredient(ingredient="3/4 cup Japanese panko breadcrumbs",
                           recipe_id=recipe_id)
session.add(newIngredient)
session.commit()
newIngredient = Ingredient(ingredient="3/4 cup Parmesan cheese finely grated",
                           recipe_id=recipe_id)
session.add(newIngredient)
session.commit()
newIngredient = Ingredient(
    ingredient="3 tablespoons unsalted butter room temperature",
    recipe_id=recipe_id)
session.add(newIngredient)
session.commit()
newIngredient = Ingredient(ingredient="3 tablespoons mayonnaise",
                           recipe_id=recipe_id)
session.add(newIngredient)
session.commit()
コード例 #6
0
def editMenu(category_id, menu_id):
    category = session.query(Category).filter_by(id=category_id).one()
    item = session.query(Menu).filter_by(id=menu_id).one()
    ingredients = session.query(Ingredient).filter_by(menu_id=item.id).first()
    directions = session.query(Direction).filter_by(menu_id=item.id).first()
    # The user has to be the one who created this menu.
    if item.user_id != login_session.get('user_id'):
        return "<script>function myFunction() {" \
               "alert('You are not authorized to edit this menu.');}" \
               "</script><body onload='myFunction()'>"

    if directions is not None:
        directions = session.query(Direction).filter_by(menu_id=item.id).all()
    else:
        directions = []
    if ingredients is not None:
        ingredients = session.query(Ingredient)\
            .filter_by(menu_id=item.id).all()
    else:
        ingredients = []
    if request.method == 'POST':
        item.name = request.form['name']
        item.picture = request.form['picture']
        item.servings = request.form['servings']
        item.calories = request.form['calories']
        item.hour = request.form['hour']
        item.minute = request.form['minute']
        session.add(item)
        session.commit()

        amount = request.form.getlist('amount')
        descriptions = request.form.getlist('description')

        # Store ingredients
        for i in range(0, len(descriptions)):
            description = descriptions[i]
            amt = amount[i]
            # amt = amt.encode("utf-8")
            description = description.replace('\u00b0', '')
            description = description.replace('\u00a0', '')
            # If the description is empty while amt is filled
            if len(description) == 0 and len(amount[i]) != 0:
                abort(400,
                      description="You only entered "
                                  "the amount of ingredient: "
                                  "description is missing.")
            # If the description is empty, ignore it.
            elif len(description) == 0:
                del amount[i]
                del descriptions[i]
            # If the description is filled.
            else:
                ingredient = session.query(Ingredient)\
                    .filter_by(description=description).first()
                if ingredient is None:
                    ingredient = Ingredient(amount=amt,
                                            description=description,
                                            menu_id=menu_id)
                    session.add(ingredient)
                    session.commit()
                else:
                    # Update amount
                    if ingredient.amount != amt:
                        ingredient.amount = amt
                        session.add(ingredient)
                        session.commit()

        # Ignore all ingredients that a user clicked 'delete'
        amounts = request.form.getlist('delete-amount')
        descriptions = request.form.getlist('delete-description')
        for description in descriptions:
            if len(description) > 0:
                ingredient = session.query(Ingredient)\
                    .filter_by(description=description).one()
                session.delete(ingredient)
                session.commit()

        # Add directions in database
        directions = request.form.getlist('direction')

        for direction in directions:
            # Make sure direction is filled
            if len(direction) > 0:
                valid = session.query(Direction)\
                    .filter_by(direction=direction).first()
                # Prevent from making a duplicate
                if valid is None:
                    direction = Direction(menu_id=menu_id,
                                          direction=direction)
                    session.add(direction)
                    session.commit()
        # Delete the directions from our database
        directions = request.form.getlist('delete-dir')
        for direction in directions:
            if len(direction) > 0:
                valid = session.query(Direction)\
                    .filter_by(direction=direction).first()
                # If the data was stored in our database
                if valid is not None:
                    session.delete(valid)
                    session.commit()

        ingredients = session.query(Ingredient)\
            .filter_by(menu_id=menu_id).all()
        directions = session.query(Direction)\
            .filter_by(menu_id=menu_id).all()
        return redirect(url_for('menuDetails',
                                category_id=category.id,
                                menu_id=menu_id,
                                ingredients=ingredients,
                                directions=directions))
    else:
        return render_template('editMenu.html',
                               ingredients=ingredients,
                               category=category,
                               item=item,
                               directions=directions,
                               user=login_session)
コード例 #7
0
def newMenu(category_id):
    category = session.query(Category).filter_by(id=category_id).one()
    if request.method == 'POST':
        valid = session.query(Menu)\
            .filter_by(name=request.form['name']).one_or_none()
        # Prevent from making a duplicate
        if valid is None:
            menu = Menu(user_id=login_session['user_id'],
                        name=request.form['name'],
                        picture=request.form['picture'],
                        servings=request.form['servings'],
                        calories=request.form['calories'],
                        hour=request.form['hour'],
                        minute=request.form['minute'],
                        category_id=category_id)
            session.add(menu)
            session.commit()
            addedmenu = session.query(Menu)\
                .filter_by(name=request.form['name']).one()

            amount = request.form.getlist('amount')
            descriptions = request.form.getlist('description')

            # Store ingredients
            for i in range(0, len(descriptions)):
                description = descriptions[i]
                amt = amount[i]
                # amt = amt.encode("utf-8")
                description = description.replace('\u00b0', '')
                description = description.replace('\u00a0', '')
                # If the description is empty while amt is filled
                if len(description) == 0 and len(amount[i]) != 0:
                    abort(400,
                          description="You only entered "
                                      "the amount of ingredient: "
                                      "description is missing.")
                # If the description is empty, ignore it.
                elif len(description) == 0:
                    del amount[i]
                    del descriptions[i]
                # If the description is filled.
                else:
                    ingredient = session.query(Ingredient) \
                        .filter_by(description=description).first()
                    if ingredient is None:
                        ingredient = Ingredient(amount=amt,
                                                description=description,
                                                menu_id=addedmenu.id)
                        session.add(ingredient)
                        session.commit()
                    else:
                        # Update amount
                        if ingredient.amount != amt:
                            ingredient.amount = amt
                            session.add(ingredient)
                            session.commit()

            # Ignore all ingredients that a user clicked 'delete'
            amounts = request.form.getlist('delete-amount')
            descriptions = request.form.getlist('delete-description')
            for description in descriptions:
                if len(description) > 0:
                    ingredient = session.query(Ingredient) \
                        .filter_by(description=description).one()
                    session.delete(ingredient)
                    session.commit()

            # Add directions in database
            directions = request.form.getlist('direction')

            for direction in directions:
                # Make sure direction is filled
                if len(direction) > 0:
                    valid = session.query(Direction) \
                        .filter_by(direction=direction).first()
                    # Prevent from making a duplicate
                    if valid is None:
                        direction = Direction(menu_id=addedmenu.id,
                                              direction=direction)
                        session.add(direction)
                        session.commit()
            # Delete the directions from our database
            directions = request.form.getlist('delete-dir')
            for direction in directions:
                if len(direction) > 0:
                    valid = session.query(Direction) \
                        .filter_by(direction=direction).first()
                    # If the data was stored in our database
                    if valid is not None:
                        session.delete(valid)
                        session.commit()

            ingredients = session.query(Ingredient) \
                .filter_by(menu_id=addedmenu.id).all()
            directions = session.query(Direction) \
                .filter_by(menu_id=addedmenu.id).all()
            return redirect(url_for('menuList', category_id=category.id))

        else:
            abort(400,
                  description="The menu name you "
                              "entered is already being used.")
    else:
        return render_template('newMenu.html',
                               category=category,
                               user=login_session)
コード例 #8
0
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

from database_setup import Ingredient, Base, RecipeItem

engine = create_engine('sqlite:///ingredientrecipe.db')
Base.metadata.bind = engine

DBSession = sessionmaker(bind=engine)

session = DBSession()

# Recipe for beef
ingredient1 = Ingredient(name="Beef")

session.add(ingredient1)
session.commit()

recipeItem1 = RecipeItem(
    name="Quick Beef Stir Fry",
    method=
    "Heat vegetable oil in a large wok or skillet over medium-high heat; cook and stir beef until browned, 3 to 4 minutes. Move beef to the side of the wok and add broccoli, bell pepper, carrots, green onion, and garlic to the center of the wok. Cook and stir vegetables for 2 minutes. Stir beef into vegetables and season with soy sauce and sesame seeds. Continue to cook and stir until vegetables are tender, about 2 more minutes.",
    time_needed="25m",
    ingredient=ingredient1)

session.add(recipeItem1)
session.commit()

recipeItem2 = RecipeItem(
    name="Mushroom Slow Cooker Roast Beef",
    method=
コード例 #9
0
session.add(aliment01)
session.add(aliment02)
session.add(aliment03)
session.add(aliment04)
session.add(aliment05)
session.add(aliment06)
session.add(aliment07)
session.add(aliment08)
session.add(aliment09)
session.add(aliment10)
session.commit()

# Fill recipes and ingredients
recipe01 = Recipe(name="Spanish tortilla")
ingredient01 = Ingredient(recipe=recipe01,
                          aliment=aliment01,
                          amount=6,
                          units="units")
ingredient02 = Ingredient(recipe=recipe01,
                          aliment=aliment02,
                          amount=1,
                          units="nibbe")  # = pellizco
ingredient03 = Ingredient(recipe=recipe01,
                          aliment=aliment03,
                          amount=4,
                          units="units")
ingredient04 = Ingredient(recipe=recipe01,
                          aliment=aliment04,
                          amount=2,
                          units="units")
session.add(recipe01)
session.add(ingredient01)