I'm working on a tkinter/customtkinter app to load data to MySQL. Below are the relevant classes. When I run this code to load a single file, I have no issues. The problem comes when I click self.load_another_button in the class loading_window. It properly brings me back to file_select, but when I click self.fd_button and select a file, it doesn't return anything. Is there a nuance with filedialog in tkinter? I set self.filedialog to None on __init__ wondering if I needed to clear the variable for some reason, but that didn't work either. Happy to clarify anything if there are questions. This is my first tkinter/customtkinter app, so have no real clue what I'm doing. class base_window(ctk.CTk): def __init__(self,title = None, **kwargs): super().__init__(**kwargs) self.title(title) self.geometry('500x400') self.grid_columnconfigure(0,weight=1) class table_selector(base_window): def __init__(self): super().__init__(title='Select Table') self.queries = queries() self.frame = ctk.CTkFrame(self,corner_radius=0,fg_color='transparent') self.val = ctk.StringVar() self.table_list = self.get_tables_from_schema() self.ts_label = ctk.CTkLabel(self.frame,text='Select Table to Load') self.combo = ttk.Combobox(self.frame,textvariable=self.val,values=self.table_list) self.combo.set(self.table_list[0]) self.frame.columnconfigure((0,1),weight=1) self.combo.grid(row=1,column=0,padx=5,pady=5) self.ts_label.grid(row=0,column=0,padx=5,pady=5,sticky='ew',columnspan=2) self.frame.grid(row=0,column=0,padx=5,pady=5) self.select_btn = ctk.CTkButton(self.frame,text='Select',command=self.select_btn_clicked) self.select_btn.grid(row=1,column=1,padx=5,pady=5) def run(self): self.mainloop() def get_tables_from_schema(self): sql = self.queries.get_tables_from_schema_sql() df = run_query(sql,user=user,password=password,database=schema) table_list = df.iloc[:,0].to_list() return table_list def select_btn_clicked(self): global table_to_load table_to_load = self.combo.get() self.fs = file_select() self.destroy() self.fs.run() class file_select(base_window): def __init__(self): super().__init__(title='Select File to Load') self.filedialog = None self.entry_text = None self.file_to_load = None self.queries = queries() self.frame = ctk.CTkFrame(self,corner_radius=0,fg_color='transparent') self.fs_label = ctk.CTkLabel(self.frame,text='Select File to Load (Only CSV is currently supported)') self.entry_text = ctk.StringVar() self.entry = ctk.CTkEntry(self.frame,textvariable=self.entry_text,width=50) self.fd_button = ctk.CTkButton(self.frame,text='Click to Select File',command=self.fd_btn_clicked) self.load_btn = ctk.CTkButton(self.frame,text='Click to Load File',command=self.load_btn_clicked) self.frame.columnconfigure((0,1),weight=1) self.fs_label.grid(row=0,column=0,padx=5,pady=5,sticky='new',columnspan=2) self.entry.grid(row=1,column=0,padx=5,pady=5,sticky='ew',columnspan=2) self.fd_button.grid(row=2,column=0,padx=5,pady=5,sticky='ew') self.load_btn.grid(row=2,column=1,padx=5,pady=5,sticky='ew') self.frame.grid(row=0,column=0,sticky='ew',padx=5,pady=5) def run(self): self.mainloop() def fd_btn_clicked(self): self.filedialog = filedialog.askopenfilename(parent=self,initialdir=os.path.join(os.path.expanduser('~'),'Desktop')) self.entry_text.set(self.filedialog) def load_btn_clicked(self): self.file_to_load = self.entry_text.get() if self.file_to_load[-3:].lower() != 'csv': self.error_window = error_window(message='File selected is not a csv. Please select a new file that is a csv, or exit the program') self.error_window.add_restart_button('file_select') self.error_window.run() else: self.check_load_file() def check_load_file(self): self.loading_window = loading_window(file_to_load=self.file_to_load) self.destroy() self.loading_window.run() class loading_window(base_window): def __init__(self, title='Loading File',file_to_load='', **kwargs): super().__init__(title=title, **kwargs) self.file_to_load = file_to_load self.frame = ctk.CTkFrame(self,corner_radius=0,fg_color='transparent') self.label = ctk.CTkLabel(self.frame,text=f'Validating and Loading File {file_to_load}') self.progress = ctk.CTkProgressBar(self.frame,mode='indeterminate',indeterminate_speed=1) self.progress.set(0) self.label.grid(row=0,column=0,padx=5,pady=5,sticky='new') self.progress.grid(row=1,column=0,padx=5,pady=5,sticky='ew') self.frame.grid(row=0,column=0,padx=5,pady=5,sticky='ew') self.load_file() def load_file(self): self.progress.start() df = pd.read_csv(self.file_to_load) df.columns = [i.strip() for i in df.columns] l_table_columns = run_query(queries().get_columns_from_table(),format='list',user=user,password=password,database=schema) if l_table_columns is not None: d = {} for i in l_table_columns: d[i[0]] = i[1] cols_to_load = [] for col in df.columns: if col in d.keys(): cols_to_load.append(col) if d[col] not in ['datetime','date','timestamp']: df.loc[:,col] = df.loc[:,col].fillna(fillna_map()[d[col]]).astype(dtype_map()[d[col]]) df_to_load = df.loc[:,cols_to_load] success_fail = df_to_db(df_to_load,table=table_to_load,user=user,password=password,database=schema) self.complete_load(text=success_fail) def complete_load(self,text): self.progress.set(1) self.progress.stop() self.complete_label = ctk.CTkLabel(self.frame,text=text) self.end_button = ctk.CTkButton(self.frame,text='Click to Exit Program',command=sys.exit) self.load_another_button = ctk.CTkButton(self.frame,text='Click to Load Another File',command=self.load_another_btn_clicked) self.complete_label.grid(row=2,column=0,padx=5,pady=5,sticky='ew') self.end_button.grid(row=3,column=0,padx=5,pady=5,sticky='ew') self.load_another_button.grid(row=4,column=0,padx=5,pady=5,sticky='ew') self.frame.grid(row=0,column=0,padx=5,pady=5,sticky='ew') def run(self): self.mainloop() def load_another_btn_clicked(self): self.ts = table_selector() self.destroy() self.ts.run() Continue reading...
