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"