def get_Reservation(User) : cur.execute=(""" SELECT * FROM EnsReservation WHERE user_id = ? """, (Reservation.get_user_id())) result = cur.fetchall() for ReservationCur in result : ReservationCur = Reservation(ReservationCur[0],ReservationCur[1],ReservationCur[2],ReservationCur[3],ReservationCur[4],ReservationCur[5],ReservationCur[6])
def supprimer_Reservation(Reservation): #Supprime une reservation try: cur.execute=(""" DELETE FROM EnsReservation WHERE Reservation_id = ?""", (Reservation.get_user_id())) conn.commit() except: print "Erreur lors de la suppression de la Reservation"
def Reservation_to_table(Reservation): # Reservation -> List ReservationTable=(Reservation.get_Reservation_id(),Reservation.get_user_id(),Reservation.get_Jeu_id(),Reservation.get_Exemplaire_id(),Reservation.get_date_Reservation()) return ReservationTable
def Ajouter_Reservation(Reservation): #Ajouter_Reservation : Reservation x Utilisateur x EnsReservation -> EnsReservation if (not(Reservation_EnCours(User))): try: cur.execute=(""" INSERT INTO EnsReservation(Reservation_id, Jeu_id, user_id, Exemplaire_id, date_Reservation) VALUES(?, ?, ?, ?, ?) """, (Reservation.get_Reservation_id(), Reservation.get_Jeu_id(), Reservation.get_user_id(), Extension.get_date_Reservation() )) conn.commit() print(" Reservation ajoutée !") except: print ("Erreur lors de l'ajout d'une reservation") else: print ("Une reservation est deja en cours " )
def Reservation_EnCours(User) : cur.execute=(""" SELECT user_id FROM EnsReservation WHERE user_id = ? """, (Reservation.get_user_id())) result=cur.fetchone() return result != None