How to refresh MySQL data in Treeview Tkinter?

Question

Code

I have this function:

#Refresh MySQL data to Treeview
    def refresh(self):
        self.table.delete(*self.table.get_children())

        cursor = mydb.cursor()
        cursor.execute("select * from requested order by done")
        for row in cursor:
            self.table.insert('','end', values = (row[8], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[9], row[10], row[12]))

If I insert a record or update one - using workbench. When I press refresh in Tkinter, it does not show any new or amended data. Just stays as it is.

But - If I quit Tkinter app - re-open it - click refresh it will show new amended data.

If the tkinter app is running - If I try to run the following query: truncate table using workbench - MySQL will not complete the query the action until I close the tkinter app

What it should do

When I activate the function refresh - it should remove all the current data in treeview and update it with existing values within MySQL.

Quesiton

How can I achieve this?

Have you verfied your .execute(... yields new or even any data? — stovfl
– stovfl, Commented Dec 11, 2019 at 16:18
@stovfl not sure what you mean. But here is an additional information - If the tkinter app is running - If I try to truncate from workbench - it will not do anything until I close the tkinter app — DeveloperLV
– DeveloperLV, Commented Dec 11, 2019 at 16:20
First step, add print('in refresh') inside def refresh(...) to verify it get called at "I press refresh". — stovfl
– stovfl, Commented Dec 11, 2019 at 16:23
You probably have an issue with MySQL transaction isolation level — bruno desthuilliers
– bruno desthuilliers, Commented Dec 11, 2019 at 16:59

DeveloperLV · Accepted Answer · 2019-12-12 09:41:08Z

1

From @brunodesthuilliers link in comments MySQL transaction isolation level has helped me find what was wrong!

By running this query in MySQL Workbench:

SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;

Has allowed me to update records from MySQL and run this function below - without a problem!

#Refresh MySQL data to Treeview
    def refresh(self):
        self.table.delete(*self.table.get_children())

        cursor = mydb.cursor()
        cursor.execute("select * from requested order by done")
        for row in cursor:
            self.table.insert('','end', values = (row[8], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[9], row[10], row[12]))

answered Dec 12, 2019 at 9:41

DeveloperLV

1,8013 gold badges20 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

bruno desthuilliers Over a year ago

You probably want to set the transaction isolation level in your own code (cf this post) when opening the db connection, so you're sure you always get it right.

DeveloperLV Over a year ago

That would make sense!

Collectives™ on Stack Overflow

How to refresh MySQL data in Treeview Tkinter?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related