Python DB.Correction_Date Examples

Example #1

File: modif_delete.py Project: Haaamzaa/GLPOO_Projet

 def MODIFY(self):
     if DB.Validation_Date(
             self.StartTime.get()) == 1 and DB.Validation_Date(
                 self.EndTime.get()):
         ST = DB.Correction_Date(self.StartTime.get())
         ET = DB.Correction_Date(self.EndTime.get())
         query = " UPDATE Event_ SET StartTime = '" + str(
             ST) + "' , EndTime = '" + str(ET) + "' , SeverityID = '" + str(
                 self.col_severity.current()) + "' ,TypeID = '" + str(
                     self.col_typ.current()) + "' ,TimeZoneID = '" + str(
                         self.col_tim.current()
                     ) + "' ,AirportID  = '" + str(self.col_air.current(
                     )) + "' where EventID = " + str(self.ID) + ";"
         self.DB.Run_Query(query)
         self.CALL_Principal()
     else:
         tk.messagebox.showinfo(" Echec ", " La Date saisie est erronée ")

Example #2

File: Insertion.py Project: Haaamzaa/GLPOO_Projet

 def Insertion_DB(self):
     if DB.Validation_Date(
             self.StartTime.get()) == 1 and DB.Validation_Date(
                 self.EndTime.get()):
         ST = DB.Correction_Date(self.StartTime.get())
         ET = DB.Correction_Date(self.EndTime.get())
         new_id = self.DB.GET_new_index_event()
         query = "INSERT INTO Event_(EventID , StartTime ,  EndTime , SeverityID , TypeID ,TimeZoneID ,AirportID ) VALUES (" + str(
             new_id) + ", '" + str(ST) + "', '" + str(ET) + "', '" + str(
                 self.col_severity.current()) + "', '" + str(
                     self.col_typ.current()) + "','" + str(
                         self.col_tim.current()) + "','" + str(
                             self.col_air.current()) + "');"
         self.DB.Run_Query(query)
         self.window.destroy()
         new_window = tk.Tk()
         Modif(new_window, new_id)
     else:
         tk.messagebox.showinfo(" Echec", " La Date saisie est erronée ")