Beispiel #1
0
    def Create_box_modification(self):
        sev = DB.Convert_Data(self.DB.GET_severity())
        typ = DB.Convert_Data(self.DB.GET_type())
        tim = DB.Convert_Data(self.DB.GET_timezone())
        air = DB.Convert_Data(self.DB.GET_airport())

        self.StartTime = tk.Entry(self.window)
        self.EndTime = tk.Entry(self.window)
        self.col_severity = ttk.Combobox(self.window, values=sev)
        self.col_typ = ttk.Combobox(self.window, values=typ)
        self.col_tim = ttk.Combobox(self.window, values=tim)
        self.col_air = ttk.Combobox(self.window, values=air)

        self.StartTime.insert(0, str(self.info[0]))
        self.EndTime.insert(0, str(self.info[1]))
        self.col_severity.current(int(self.info[6]))
        self.col_typ.current(int(self.info[7]))
        self.col_tim.current(int(self.info[8]))
        self.col_air.current(int(self.info[9]))

        self.StartTime.grid(row=1, column=2)
        self.EndTime.grid(row=2, column=2)
        self.col_tim.grid(row=3, column=2)
        self.col_severity.grid(row=4, column=2)
        self.col_typ.grid(row=5, column=2)
        self.col_air.grid(row=6, column=2)
        tk.Button(self.window, text='Modification',
                  command=self.MODIFY).grid(row=8,
                                            column=1,
                                            sticky=tk.W,
                                            pady=4)
Beispiel #2
0
 def Create_Box(self):
     # Import Data Categorie
     sev = DB.Convert_Data(self.DB.GET_severity())
     typ = DB.Convert_Data(self.DB.GET_type())
     tim = DB.Convert_Data(self.DB.GET_timezone())
     air = DB.Convert_Data(self.DB.GET_airport())
     # Create Boxes
     self.StartTime = tk.Entry(self.window)
     self.EndTime = tk.Entry(self.window)
     self.col_severity = ttk.Combobox(self.window, values=sev)
     self.col_typ = ttk.Combobox(self.window, values=typ)
     self.col_tim = ttk.Combobox(self.window, values=tim)
     self.col_air = ttk.Combobox(self.window, values=air)
Beispiel #3
0
def Ploter():
    Lat_Long = []
    for i in DB.DATABASE().GET_airport():
        Lat_Long.append(i[1:4])
    Data = pandas.DataFrame(numpy.array(Lat_Long),
                            columns=['Code', 'Lat', 'Lng'])
    fig = go.Figure()
    fig.add_trace(
        go.Scattergeo(locationmode='USA-states',
                      lon=Data['Lng'],
                      lat=Data['Lat'],
                      hoverinfo='text',
                      text=Data['Code'],
                      mode='markers',
                      marker=dict(size=5, color='rgb(255, 0, 0)')))
    fig.update_layout(title_text=' Visualisation des Airoports ',
                      showlegend=True,
                      geo=dict(
                          scope='usa',
                          showland=True,
                          landcolor='rgb(0, 0, 0)',
                          countrycolor='rgb(204, 204, 204)',
                      ))
    fig.show()
    fig.write_image("plot.png")
Beispiel #4
0
 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 ")
Beispiel #5
0
 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 ")
Beispiel #6
0
 def __init__(self, fenetre, ID):
     self.window = fenetre
     self.window.geometry("500x200")
     self.window.title(' Projet GLPOO')
     self.DB = DB.DATABASE()
     self.ID = ID
     self.info = self.DB.GET_data_by_ID(self.ID)[0]
     self.Tableau()
     self.Print_Ligne()
     self.Create_BOX_Delete()
     self.Create_box_modification()
Beispiel #7
0
 def __init__(self, fenetre):
     self.window = fenetre
     self.window.geometry("400x200")
     self.window.title(' Projet GLPOO')
     self.DB = DB.DATABASE()
     self.Create_Label()
     self.Create_Box()
     self.Select()
     self.GRID()
     tk.Button(self.window, text='Insertion',
               command=self.Insertion_DB).grid(row=8,
                                               column=1,
                                               sticky=tk.W,
                                               pady=4)