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"
