Forum Archive

Hi,
I would like to get input from ui.textfields and. Insert the data into SQLite DB.
I have used a button action to read the fields and insert to the DB.Is there a better way of doing it without the button?

import ui
import sqlite3

def button_action(sender):
    #con = sqlite3.connect(":memory:")
    conn = sqlite3.connect('jubk.db')
    #con.isolation_level = None
    c = conn.cursor()
#   c.execute('''CREATE TABLE emploee_db3 
#       (id_num text, first text, last text)''')
    first = first_name_f.text
    last = last_name_f.text
    id_num = id_num_f.text
    print('first name ', first, 'last name ', last, 'id ', id_num)

    c.execute("INSERT INTO emploee_db3 VALUES (:id_num, :first, :last)", {'id_num': id_num, 'first': first, 'last': last})
    for row in c.execute('SELECT * FROM emploee_db3'):
                print(row)
    conn.commit()   

v = ui.load_view()
v.present('sheet')

first_name_f = v['first_f']
last_name_f = v['last_f']
id_num_f = v['idnum']

"TextField.action: A function or method that gets called when text field has finished editing."
So you could check if all textfields have a valid value, insert them to your db and clear the textfield.text

def textfield_action(self, textfield):
    # This is called after pressing RETURN
    if ...
        c.execute...
        self.tf_first.text = ''
        ...

Btw. this is an example of a own view class.

Thanks, I will try

It works, thank you very much