omz:forum

    • Register
    • Login
    • Search
    • Recent
    • Popular
    1. Home
    2. sara55

    Welcome!

    This is the community forum for my apps Pythonista and Editorial.

    For individual support questions, you can also send an email. If you have a very short question or just want to say hello — I'm @olemoritz on Twitter.


    • Profile
    • Following 0
    • Followers 0
    • Topics 2
    • Posts 7
    • Best 0
    • Controversial 0
    • Groups 0

    sara55

    @sara55

    0
    Reputation
    752
    Profile views
    7
    Posts
    0
    Followers
    0
    Following
    Joined Last Online

    sara55 Unfollow Follow

    Latest posts made by sara55

    • RE: Ui textfield and SQLite DB

      It works, thank you very much

      posted in Pythonista
      sara55
      sara55
    • RE: Ui textfield and SQLite DB

      Thanks, I will try

      posted in Pythonista
      sara55
      sara55
    • Ui textfield and SQLite DB

      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']
      
      posted in Pythonista
      sara55
      sara55
    • RE: How to save ui.image

      Thank you very much

      posted in Pythonista
      sara55
      sara55
    • RE: How to save ui.image

      Thanks, it worked.
      How would I load a JPG image ?
      Img = ?

      posted in Pythonista
      sara55
      sara55
    • RE: How to save ui.image

      Thank you very much, I will try.

      posted in Pythonista
      sara55
      sara55
    • How to save ui.image

      I am new to python and Pythonista.
      I would like to save ui.image and not create it very time from JPEG.
      Is it possible?

      Thanks

      posted in Pythonista
      sara55
      sara55