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})