Подскажите пожалуйста, КАК ИСПРАВИТЬ БАГ: sqlite3.OperationalError: unrecognized token: ""CREATE TABLE IF NOT EXISTS users (

import flet as ft
import sqlite3
def main(page: ft.Page):
    page.title = "Registration"
    page.window_width = 350  
    page.window_height = 400  
    page.window_resizable = False
    page.theme_mode = 'dark'
    page.vertical_alignment = ft.MainAxisAlignment.CENTER
    def register(e):
        ```
        bh = sqlite3.connect('Hello_world.Goodbye')
        cur = bh.cursor()
        cur.execute(""""CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY,
        login TEXT,
        pass TEXT  
        )""")
        cur.execute(F"INSERT INTO users VALUES(NULL, '{login.value}', '{user_pass.value}')")
        bh.close()
        login.value = ''
        user_pass.value = ''
        btn_reg.text = 'Added'
        page.update()
        ```

    def validate(e):
        if all([login.value, user_pass.value]):
            btn_reg.disabled = False
        else:
            btn_reg.disabled = True
        page.update()
    def set_theme_mode_light(e):
        page.theme_mode = 'light'
        page.update()
    def set_theme_mode_dark(e):
        page.theme_mode = 'dark'
        page.update()
        
    login = ft.TextField(label='Enter login', on_change=validate, width=200)
    user_pass = ft.TextField(label='Enter password',password=True, on_change=validate, width=200)
    btn_reg = ft.OutlinedButton(text='Add', width=200, on_click=register, disabled=True)

    page.add(
        ft.Row(
            [
                ft.Column(
                    [
                        ft.Row(
                            [   
                                ft.IconButton(ft.icons.UPDATE, on_click=page.update()),
                                ft.IconButton(ft.icons.SUNNY, on_click=set_theme_mode_light),
                                ft.IconButton(ft.icons.DARK_MODE, on_click=set_theme_mode_dark),
                            ]
                        ),
                        ft.Text('Registration'),
                        login,
                        user_pass,
                        btn_reg
                    ]
                )
            ]
        )
    )

ft.app(target=main, view=ft.AppView.FLET_APP)

Ответы (0 шт):