def deleteCategory(id):
req = "DELETE FROM categorie WHERE id='%s'"
cursor = getCursor()
cursor.execute(req % str(id))
connection = getConnection()
connection.commit()
return "Deleted"
def updateCategory(id):
libelle = request.json['libelle']
req = "UPDATE categorie SET categories='%s' WHERE id='%s'"
cursor = getCursor()
cursor.execute(req % (libelle, str(id)))
connection = getConnection()
connection.commit()
return "Updated"
def addCategory():
libelle = request.json['libelle']
req = "INSERT INTO categorie (categories) VALUES (%s)"
cursor = getCursor()
cursor.execute(
req, (libelle, )
) #On est oblige de mettre la virgule car le format doit être tuple i.e
connection = getConnection()
connection.commit()
#Mettre des try catch
return "Inserted"
def updateNiche(id, request):
hour = request.json['hour']
nicheDate = request.json['nicheDate']
title = request.json['title']
description = request.json['description']
price = request.json['price']
category = request.json['category']
company = request.json['company']
reqNiche = "UPDATE entreprise SET heure='%s',datecreneau='%s',titre='%s',description='%s',prix='%s',idcategorie='%s',identreprise='%s' WHERE id='%s'"
cursor = getCursor()
cursor.execute(reqNiche % (hour, nicheDate, title, description, price, category, company, id))
connection.commit()
return "Updated"
def addNiche(request):
#Depuis request, on recupere les données avant de les inserer
hour = request.json['hour']
nicheDate = request.json['nicheDate']
title = request.json['title']
description = request.json['description']
price = request.json['price']
category = request.json['category']
company = request.json['company']
reqNiche = "INSERT INTO entreprise (heure, datecreneau, titre, description, prix, idcategorie, identreprise) VALUES (%s, %s, %s, %s, %s, %s, %s)"
cursor = getCursor()
cursor.execute(reqNiche, (hour, nicheDate, title, description, price, category, company))
connection.commit()
return 'Inserted'
def getNicheFromId(id):
reqNiche = "SELECT * FROM creneau WHERE idc = '%s' "
cursor = getCursor()
cursor.execute(reqNiche % str(id))
resNiche = cursor.fetchall()
print(resNiche[0][0])
niche={
"id": resNiche[0][0],
"hour": str(resNiche[0][1]),
"date": str(resNiche[0][2]),
"title": resNiche[0][3],
"description": resNiche[0][4],
"price": resNiche[0][5],
"idCategory": resNiche[0][6],
"idCompany": resNiche[0][7],
"reserve": resNiche[0][8]
}
return jsonify(niche)
def getAllNiches():
reqNiches = "SELECT * FROM creneau"
cursor = getCursor()
cursor.execute(reqNiches)
resNiches = cursor.fetchall()
listNiche=[]
for date in resNiches:
listNiche.append({
"id": date[0],
"hour": str(date[1]),
"date": str(date[2]),
"title": date[3],
"description": date[4],
"price": date[5],
"idCategory": date[6],
"idCompany": date[7],
"reserve": date[8]
})
#On met les resultats en json pour les manipuler coté front
return jsonify(listNiche)
def getAllCategories():
req = "SELECT * FROM categorie"
cursor = getCursor()
cursor.execute(req)
res = cursor.fetchall()
return jsonify(res)
def getCategoryFromId(id):
req = "SELECT * FROM categorie WHERE id = '%s' "
cursor = getCursor()
cursor.execute(req % str(id))
res = cursor.fetchall()
return jsonify(res)
def deleteNiche(id):
req = "DELETE FROM creneau WHERE id='%s'"
cursor = getCursor()
cursor.execute(req % str(id))
connection.commit()
return "Deleted"
