# Python Flet + Sqlite

import flet as ft
import sqlite3

# Connect to SQLite database
conn = sqlite3.connect('personal_info.db')
c = conn.cursor()

# Create table if it doesn't exist
c.execute('''CREATE TABLE IF NOT EXISTS info
             (id INTEGER PRIMARY KEY, name TEXT, email TEXT)''')

def main(page: ft.Page):
    # Input fields
    name_field = ft.TextField(label="Name")
    email_field = ft.TextField(label="Email")

    # Save button click handler
    def save_info(e):
        name = name_field.value
        email = email_field.value
        c.execute("INSERT INTO info (name, email) VALUES (?, ?)", (name, email))
        conn.commit()
        # Clear input fields after saving
        name_field.value = ""
        email_field.value = ""
        page.update()
        # Confirm save to user
        page.controls.append(ft.Text(f"Saved: {name}, {email}"))

    # Layout
    page.add(name_field, email_field, ft.Button(text="Save", on_click=save_info))

# Start the app
ft.app(target=main)