inglés How to receive data from a db and update it on the screen?

[ErizoKaraka]

Question

Hello, I'm trying to figure out how I can receive data from a database where I'll later store values from some sensors on a board, what I want to do is that I can constantly ask for the data behind the entire execution of the application, and when it's time, display it on the screen, but I still can't get that when I insert a new value from phpMyAdmin, this one is updated in my flet application by itself, I have to give it CTRL+S in VSC for the value to be updated, I already tried a thousand ways but I can't figure out how. Does anyone know how to do it or can guide me?

Code sample

import flet as ft
import asyncio
import aiomysql

async def connect_to_database():
    
        conn = await aiomysql.connect(
            host="localhost",
            user="root",
            password="",
            db="pacientes"
        )
        print("Connected to database")
        return conn
    

async def fetch_data(conn):
    
        async with conn.cursor() as cursor:
            await cursor.execute("SELECT temperatura FROM mediciones ORDER BY fecha DESC")
            temp = await cursor.fetchone()
            print("Fetched data:", temp)
            return temp[0] if temp else None
    

class dato(ft.UserControl):
    def __init__(self):
        super().__init__()

    def did_mount(self):
        self.running = True
        self.page.run_task(self.update_timer)

    def will_unmount(self):
        self.running = False

    async def update_timer(self):
        conn = await connect_to_database()
        if conn:
            while self.running:
                temp = await fetch_data(conn)
                
                self.temperatura.value = str(temp)
                self.update()
                await asyncio.sleep(1)
            await conn.close()

    def build(self):
        self.temperatura = ft.Text()
        return self.temperatura

def main(page: ft.Page):
    page.add(dato())

ft.app(target=main)

Error message

No response

------------------------------------------------------

• I have searched for answers to my question both in the issues and in previous discussions.