flet build web -vv

[sirozza]

Question

I wrote an application to query data from a database table_name = 'prices'
if I run on a computer from pycharm, everything works, I get the data from the table.
but if I create a command flet build web -vv
and start a local server to check python -m http.server --directory .\build\web
I open it in the browser http://localhost:8000/
when receiving data and database, browser error in console.

python 3.12
requirements : uvicorn, websockets, wsproto, peewee, pymysql, flet
flet 0.21.2

the server with the database is working and can be tested.

Code sample

import flet as ft
import peewee as pe


name_db = 'siroz436_test'
host_db = 's16.link-host.net'
port_db = 3306
user_db = 'siroz436_sirozza'
password_db = '7iFlGmh2Ze'
db = pe.MySQLDatabase(name_db, host=host_db, port=port_db, user=user_db,
                      password=password_db, connect_timeout=100)


class BaseModel(pe.Model):
    class Meta:
        database = db


class Prices(BaseModel):
    id = pe.AutoField(),
    price_prices = pe.DecimalField()
    active_prices = pe.BooleanField()

    class Meta:
        table_name = 'prices'


def get_price_db():
    try:
        with db.atomic():
            t = Prices.select().order_by(Prices.id)
            print(t)
            return t
    except Exception as e:
        return False


class GeneralTable(ft.DataTable):
    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)
        self.column_spacing = 50
        self.sort_column_index = 0
        self.sort_ascending = True
        self.show_checkbox_column = True
        self. adaptive = True


price_table = GeneralTable(
    columns=[
        ft.DataColumn(ft.Text('#')),
        ft.DataColumn(ft.Text('price')),
        ft.DataColumn(ft.Text('active')),
        ft.DataColumn(ft.Text('action')),
    ],)


async def get_prices():
    get_all = get_price_db()
    price_table.rows.clear()
    if get_all == True:
        for price in get_all:
            price_table.rows.append(
                ft.DataRow(
                    cells=[
                        ft.DataCell(ft.Text(price.id)),
                        ft.DataCell(ft.Text(price.price_prices)),
                        ft.DataCell(ft.Text(price.active_prices)),
                        ft.DataCell(ft.Row([
                            ft.IconButton(icon=ft.icons.EDIT,
                                          icon_color='red',
                                          data=price,
                                          tooltip='edit',
                                          on_click=None),
                             ],)),]))
    else:
        ft.SnackBar(ft.Text(f'Error'),bgcolor=ft.colors.RED_ACCENT, open=True)

data_price_table = ft.Row([price_table], alignment=ft.MainAxisAlignment.CENTER)


async def main(page: ft.Page):
    page.vertical_alignment = ft.MainAxisAlignment.START
    page.title = 'Test'
    await get_prices()
    page.add(data_price_table)
    page.update()


ft.app(main, assets_dir='assets')

Error message

python.js:23 Python engine initialized!
pyodide.asm.js:9 WebSocket connection to 'ws://localhost:3306/' failed: WebSocket is closed before the connection is established.

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

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