How to Refresh Data on Table when DB table is updated.

[jdavid18]

I am trying to refresh the table from a database that is being updated every few seconds. I am able to display the table but it is refreshing the data from database. New records are not displayed on the table.

I put the data into a JSON file to be able to displayed on the table. I used .after to refresh to call the function that gets the data from DB. Tried many procedures to refresh to no avail. I appreciate any help.

class Gappers(tk.Tk):
def init(self):
super().init()
self.geometry('250x380')

def data():
    my_conn = create_engine('mysql+mysqldb://root:''@localhost/stock_market', echo=False)
    results = "SELECT * FROM gappers_day"
    df_table_runner = pd.DataFrame(my_conn.connect().execute(text(results)))
    df_table_runner1 = df_table_runner.sort_values('Gapper_Percentage')
    df_table_runner3 = df_table_runner3.sort_values(by='Gapper_Percentage', ascending=False) 

    df_table_runner_final = df_table_runner3.reset_index()
    new_cols = ["Time","key", "Gapper_Percentage"]
    df_table_runner_final = df_table_runner_final[new_cols]
    df_table_runner_final = df_table_runner_final.reindex(columns=new_cols)    
    json_str = df_table_runner_final.to_json(orient='values') 
    rowdata = json.loads(json_str)
    coldata = ["Time", "key", "Gapper_Percentage"]

    self.dt = Tableview(
    	master=root,
    	coldata=coldata,
    	rowdata=rowdata,
    	paginated=True,
    	searchable=True,
    	bootstyle=PRIMARY,
    	stripecolor=(colors.light, None),
    	pagesize=42,
    	height=42,
		)
    self.dt.pack(fill=BOTH, expand=YES, padx=10, pady=10)
    self.dt.after(5000, self.update_data)

def update_data(self):  
    self.data()
    self.dt.after(5000, self.update_data)

if name == "main":
clock = Gappers()
clock.mainloop()