python - update database that connection in flask app

Question

I have a flask app that connects to the database table as shown below

connection = pyodbc.connect('DRIVER={SQL Server};SERVER=x;DATABASE=y; MARS_Connection=yes')
cursor = connection.cursor()

SQL = "select * from data"
table = pd.read_sql(SQL , con=connection)

print(table)

result

id   name
1     v
2     u
3     o

if I update the database manually by adding

4     j

then I print it will not show in my flask app so I have to restart the app to show it.

my question how can I make sure that flask app will update variable based database updated

do I have to read the database again in each route, and save it in the same variable? like

table = pd.read_sql(SQL , con=connection)

or there is another way?

question from:https://stackoverflow.com/questions/65933154/update-database-that-connection-in-flask-app

Answer 1

Waitting for answers