def saveRecipe():
if request.method == "POST":
recipe = request.json['recipe']
user_id = int(request.json['user_id'])
name = recipe['name']
ingredients = recipe['ingredients']
directions = recipe['directions']
recipe_id = database.performDo('INSERT INTO recipes (name, directions, user_owner) VALUES ("%s", "%s", %d)' % (name, directions, user_id))
for item in ingredients:
ingredient_name = item['name']
quantity = int(item['quantity'])
units_id = int(item['units_id'])
ingredient_result = database.performQueryOne('SELECT id FROM ingredients WHERE name="%s"' % ingredient_name)
if ingredient_result == None:
ingredient_id = database.performDo('INSERT INTO ingredients (name) VALUES ("%s")' % ingredient_name)
else:
ingredient_id = int(ingredient_result['id'])
database.performDo('INSERT INTO l_recipes_to_ingredients (recipe_id, ingredient_id, quantity, units) VALUES (%d,%d,%d,%d)' % (recipe_id, ingredient_id, quantity, units_id))
return jsonify({'success': True})
return jsonify({'success': False})
def createUser():
if request.method == "POST":
user_email = request.json['user_email']
full_name = request.json['full_name']
password = request.json['password']
database.performDo('INSERT INTO users (email, full_name, password) VALUES ("%s", "%s", md5("%s"))' % (user_email, full_name, password))
return jsonify({'success': True})
return jsonify({'success': False})
