def user_login():
db_connection = connect_to_database()
if request.method == 'GET':
return render_template('landing.html')
elif request.method == 'POST':
userName = request.form['username']
userPassword = request.form['password']
try:
userquery = 'SELECT * FROM Users where userName = %s and userPassword = %s'
# login info matches an existing account
if userquery:
data = (userName, userPassword)
result = execute_query(db_connection, userquery,
data).fetchall()
recipequery = 'SELECT * FROM Recipes'
recipesresult = execute_query(db_connection,
recipequery).fetchall()
flash('Login successful. Welcome back!', 'success')
# Note: keeps saying UndefinedError: tuple object has no element 0
except:
flash(
'Incorrect login/password. Account not found, please try again.',
'warning')
return render_template('login.html')
return render_template('index_user.html',
user=result,
recipes=recipesresult)
def save_recipe(recipe_id, user_id):
db_connection = connect_to_database()
dup_verify = 'SELECT count(*) FROM Recipes_Users WHERE userID = %i and recipeID = %i' % (
user_id, recipe_id)
dup_result = execute_query(db_connection, dup_verify).fetchone()
if dup_result[0] == 0:
add_recipe_query = 'insert into Recipes_Users VALUES (%i, %i)' % (
user_id, recipe_id)
execute_query(db_connection, add_recipe_query)
flash(
'This recipe has been added for future lookup from your recipe book!',
'success')
else:
flash('This recipe is already in your recipe book!', 'warning')
ingredients_query = "SELECT i.ingredientID, i.ingredientName, i.ethicalIssue, i.ethicalDescription, ei.ingredientName FROM Ingredients as i LEFT JOIN Ingredients_EthicalIngredients as ie ON ie.ingredientID = i.ingredientID LEFT JOIN EthicalIngredients as ei ON ie.ethicalIngredientID = ei.ethicalIngredientID INNER JOIN Recipes_Ingredients as ri ON i.ingredientID = ri.ingredientID WHERE ri.recipeID = %i" % recipe_id
ingredients_result = execute_query(db_connection,
ingredients_query).fetchall()
recipe_query = "select * from Recipes where recipeID = %i" % recipe_id
recipe_result = execute_query(db_connection, recipe_query).fetchall()
return render_template('ingredients_user.html',
ingredients=ingredients_result,
recipe=recipe_result,
userid=user_id)
def ingredients(recipe_id):
db_connection = connect_to_database()
ingredients_query = "SELECT i.ingredientID, i.ingredientName, i.ethicalIssue, i.ethicalDescription, ei.ingredientName FROM Ingredients as i LEFT JOIN Ingredients_EthicalIngredients as ie ON ie.ingredientID = i.ingredientID LEFT JOIN EthicalIngredients as ei ON ie.ethicalIngredientID = ei.ethicalIngredientID INNER JOIN Recipes_Ingredients as ri ON i.ingredientID = ri.ingredientID WHERE ri.recipeID = %i" % recipe_id
ingredients_result = execute_query(db_connection,
ingredients_query).fetchall()
recipe_query = "select * from Recipes where recipeID = %i" % recipe_id
recipe_result = execute_query(db_connection, recipe_query).fetchall()
return render_template('ingredients.html',
ingredients=ingredients_result,
recipe=recipe_result)
def new_user_login():
db_connection = connect_to_database()
if request.method == 'GET':
return render_template('landing.html')
elif request.method == 'POST':
userName = request.form['username']
userPassword = request.form['password']
userEmail = request.form['email']
try:
usernameExists = 'SELECT userName FROM Users WHERE userName = %s'
if len(userName) < 4:
flash('Username too short. Please try again.', 'warning')
return render_template("createAccount.html")
elif len(userPassword) < 4:
flash('Password too short. Please try again.', 'warning')
return render_template("createAccount.html")
elif ('@' not in userEmail) and ('.' not in userEmail):
flash('Email entry invalid. Please try again.', 'warning')
return render_template("createAccount.html")
elif usernameExists is not None:
acctQuery = 'INSERT INTO Users (userName, userPassword, userEmail) VALUES (%s,%s,%s)'
data = (userName, userPassword, userEmail)
result = execute_query(db_connection, acctQuery,
data).fetchall()
testuserquery = 'SELECT * FROM Users where userName = %s and userPassword = %s'
testdata = (userName, userPassword)
testresult = execute_query(db_connection, testuserquery,
testdata).fetchall()
recipequery = 'SELECT * FROM Recipes'
recipesresult = execute_query(db_connection,
recipequery).fetchall()
flash(
'Your account has been successfully registered. Welcome!',
'success')
# if there is still an error after all requirements are met, the username must already exist in the database
except:
flash('User already exists. Please try again.', 'warning')
return render_template("createAccount.html")
# TO DO LIST: for creating an account, query for the user ID and send it as a variable in the flask render
return render_template('index_new_user.html',
user=testresult,
recipes=recipesresult)
def recipebook(user_id):
db_connection = connect_to_database()
query = "SELECT * from Recipes where recipeID in (select recipeID from Recipes_Users where userID = %i)" % user_id
result = execute_query(db_connection, query).fetchall()
user_query = 'SELECT * FROM Users where userID = %i' % user_id
user_result = execute_query(db_connection, user_query).fetchall()
return render_template('recipebook.html',
recipes=result,
userid=user_id,
user=user_result)
def user(user_id):
db_connection = connect_to_database()
userID = user_id
userquery = 'SELECT * FROM Users WHERE userID = %i' % user_id
result = execute_query(db_connection, userquery).fetchall()
recipequery = 'SELECT * FROM Recipes'
recipesresult = execute_query(db_connection, recipequery).fetchall()
return render_template('index_user.html',
user=result,
recipes=recipesresult)
def index():
db_connection = connect_to_database()
query = "SELECT * from Recipes"
result = execute_query(db_connection, query).fetchall()
return render_template('index.html', recipes=result)
