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 getUserInformation(user_id): user_id = int(user_id) result = database.performQueryOne('SELECT id, email, full_name FROM users WHERE id=%d' % user_id) email = result['email'] full_name = result['full_name'] return jsonify({'id': user_id, 'email': email, 'full_name': full_name})
def loginUser(): if request.method == "POST": user_email = request.json['user_email'] password = request.json['password'] entered_password = database.performQueryOne('SELECT md5("%s") AS password' % password )['password'] user_result = database.performQueryOne('SELECT id, full_name, password FROM users WHERE email="%s"' % user_email) correct_password = user_result['password'] user_id = user_result['id'] full_name = user_result['full_name'] if entered_password == correct_password: resp = make_response(jsonify({'success': True})) resp.set_cookie('user_email', user_email) resp.set_cookie('full_name', full_name) resp.set_cookie('user_id', user_id) return resp return jsonify({'success': False})