I have a problem with the asynchronous functions

[LuciferEwah]

Question

I have a problem with the asynchronous functions

Code sample

from flet import UserControl
import aiosqlite



class BaseDeDatos(UserControl):
    def __init__(self, db_nombre='mi_base_de_datos.db'):
        super().__init__()
        self.db_nombre = db_nombre

    async def inicializar_base_datos(self):
        conexion = await aiosqlite.connect(self.db_nombre)
        cursor = await conexion.cursor()
        try:
            # Lista de sentencias SQL para crear las tablas
            tablas = [
                '''
                CREATE TABLE IF NOT EXISTS usuarios (
                    id INTEGER PRIMARY KEY,
                    usuario TEXT NOT NULL,
                    password TEXT NOT NULL UNIQUE
                )
                ''',
                '''
                CREATE TABLE IF NOT EXISTS prueba (
                    id INTEGER PRIMARY KEY,
                    x TEXT NOT NULL,
                    xx REAL NOT NULL
                )
                '''
            ]

            # Ejecutar cada sentencia SQL
            for tabla in tablas:
                await cursor.execute(tabla)

            # Confirmar los cambios
            await conexion.commit()
            print("Base de datos inicializada exitosamente.")

        except Exception as e:
            # Si ocurre un error, imprimir el error
            print(f"Ocurrió un error al inicializar la base de datos: {e}")

        finally:
            # Cerrar la conexión
            await conexion.close()


from flet import *
from screen.Login import LoginScreen
from screen.dashboard import DashboardScreen
from db.database import BaseDeDatos


async def main(page: Page):
    print("La aplicación ha iniciado")
    # Inicializar la base de datos aquí
    # Uso de la clase
    db = BaseDeDatos()
    await db.inicializar_base_datos()  # Añade 'await' aquí para esperar la inicialización

    def route_change(e):
        page.views.clear()
        if page.route == '/':
            page.title = 'Inicio',
            page.views.append(View('/', [LoginScreen()], horizontal_alignment='center', vertical_alignment='center', bgcolor='#1f262f')
                              )
        elif page.route == '/dashboard':
            page.title = 'Dashboard'
            page.views.append(DashboardScreen())
        page.update()

    page.on_route_change = route_change
    page.go('/')  # Esta línea navegará a la ruta inicial '/'

if __name__ == '__main__':
    app(target=main, assets_dir="assets")

Error message

La aplicación ha iniciado
Base de datos inicializada exitosamente.
Unhandled error processing page session : Traceback (most recent call last):
  File "C:\Users\Luci\Documents\GitHub\proyecto_tesis\venv\Lib\site-packages\flet_runtime\app.py", line 443, in on_session_created
    await session_handler(page)
  File "c:\Users\Luci\Documents\GitHub\proyecto_tesis\app\main.py", line 26, in main
    page.go('/')  # Esta línea navegará a la ruta inicial '/'
    ^^^^^^^^^^^^
  File "C:\Users\Luci\Documents\GitHub\proyecto_tesis\venv\Lib\site-packages\flet_core\page.py", line 524, in go
    self.__on_route_change.get_sync_handler()(
  File "C:\Users\Luci\Documents\GitHub\proyecto_tesis\venv\Lib\site-packages\flet_core\event_handler.py", line 28, in __sync_handler
    h(r)
  File "c:\Users\Luci\Documents\GitHub\proyecto_tesis\app\main.py", line 23, in route_change
    page.update()

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

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

[SKbarbon]

Hi @LuciferEwah ,
You need to replace "page.update()" with "await page.update_async()"

Also replce the "page.go("/")" with "await page.go_async("/")"

[LuciferEwah]

@SKbarbon I was able to correct all the mistakes with your knowledge, I thank you very much.