def beers(): token = request.headers.get('token') if (verifyToken(token)): conn = connection.db_connection() cursor = conn.cursor() if request.method == 'GET': cursor.execute("SELECT * FROM beer") beers = [ dict(id=row[0], name=row[1], percentageAlcohol=row[2], category=row[3], stock=row[4], image=row[5]) for row in cursor.fetchall() ] if beers is not None: cursor.close() conn.close() return jsonify(beers) if request.method == 'POST': data = request.get_json() new_name = data['name'] new_percentageAlcohol = data['percentageAlcohol'] new_category = data['category'] new_stock = data['stock'] new_image = data['image'] sql = """INSERT INTO beer (name,percentageAlcohol,category,stock,image) VALUES (?,?,?,?,?) """ cursor.execute(sql, (new_name, new_percentageAlcohol, new_category, new_stock, new_image)) conn.commit() cursor.close() conn.close() return f"Beer with the id {cursor.lastrowid} created successful" else: return "Your token is expired"
def changePanier(beer_id, user_id): token = request.headers.get('token') if (verifyToken(token)): conn = connection.db_connection() cursor = conn.cursor() if request.method == 'DELETE': sqllist = """DELETE FROM beerlist where user_id = ? and beer_id=? """ cursor.execute(sqllist, (int(user_id), int(beer_id))) conn.commit() cursor.close() conn.close() return f"Beer {int(beer_id)} remove from your favlist" if request.method == 'PUT': sql = """UPDATE beerlist SET quantite = ? WHERE user_id=? and beer_id=? """ data = request.get_json() quantite = data["quantite"] updated_beer_quantite = { 'user_id': int(user_id), 'beer_id': int(beer_id), 'quantite': quantite, } cursor.execute(sql, (quantite, int(user_id), int(beer_id))) conn.commit() cursor.close() conn.close() return jsonify(updated_beer_quantite) else: return "Your token is expired"
def search(name): token = request.headers.get('token') if (verifyToken(token)): conn = connection.db_connection() cursor = conn.cursor() if request.method == 'GET': cursor.execute("SELECT * FROM beer where name = ?", (str(name), )) rows = cursor.fetchall() if (len(rows) > 0): for r in rows: beer = r if beer is not None: cursor.close() conn.close() return jsonify(beer), 200 else: cursor.close() conn.close() return "Something wrong", 404 else: cursor.close() conn.close() return "Something wrong", 404 else: return "Your token is expired"
def remove_from_favorite(beer_id, user_id): token = request.headers.get('token') if (verifyToken(token)): conn = connection.db_connection() cursor = conn.cursor() if request.method == 'DELETE': sqllist = """DELETE FROM beerlist where user_id = ? and beer_id=? """ cursor.execute(sqllist, (int(user_id), int(beer_id))) conn.commit() cursor.close() conn.close() return f"Beer {beer_id} remove from your favlist" else: return "Your token is expired"
def single_beer(id): token = request.headers.get('token') if(verifyToken(token)) : conn = connection.db_connection() cursor = conn.cursor() beer = None if request.method == 'GET': cursor.execute("SELECT * FROM beer WHERE id =?",(int(id),)) rows = cursor.fetchall() for r in rows : beer = r if beer is not None : cursor.close() conn.close() return jsonify(beer),200 else : cursor.close() conn.close() return "Something wrong",404 if request.method == 'PUT' : sql = """UPDATE beer SET name = ?, percentageAlcohol=?, category=? WHERE id=? """ data = request.get_json() name= data["name"] percentageAlcohol = data["percentageAlcohol"] category = data["category"] updated_beer = { 'id':id, 'name' : name, 'percentageAlcohol' : percentageAlcohol, 'category' : category } cursor.execute(sql,(name,percentageAlcohol,category,int(id))) conn.commit() cursor.close() conn.close() return jsonify(updated_beer) if request.method == 'DELETE': sql = """ DELETE FROM beer WHERE id=? """ cursor.execute(sql,(int(id),)) conn.commit() cursor.close() conn.close() return "Beer with the id {} has been deleted".format(id),200 else : return "Your token is expired"
def favorite(): token = request.headers.get('token') if (verifyToken(token)): conn = connection.db_connection() cursor = conn.cursor() if request.method == 'POST': data = request.get_json() beer_id = data['beer_id'] user_id = data['user_id'] sqllist = """INSERT INTO beerlist (user_id,beer_id) VALUES (?,?) """ cursor.execute(sqllist, (user_id, beer_id)) conn.commit() cursor.close() conn.close() return f"Beer {beer_id} add to your favlist" else: return "Your token is expired"
def beer_by_user(user_id): token = request.headers.get('token') if (verifyToken(token)): conn = connection.db_connection() cursor = conn.cursor() if request.method == 'GET': cursor.execute( "SELECT beer_id,quantite from beerlist where user_id = ?", (int(user_id), )) beers = [ dict(beer_id=row[0], quantite=row[1]) for row in cursor.fetchall() ] cursor.close() conn.close() return jsonify(beers) else: return "Your token is expired"
def beer_by_user(user_id): token = request.headers.get('token') if (verifyToken(token)): conn = connection.db_connection() cursor = conn.cursor() if request.method == 'GET': cursor.execute( "SELECT * FROM beer WHERE id in (SELECT beer_id from beerlist where user_id=?)", (str(user_id), )) beers = [ dict(id=row[0], name=row[1], percentageAlcohol=row[2], category=row[3]) for row in cursor.fetchall() ] cursor.close() conn.close() return jsonify(beers) else: return "Your token is expired"