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
