Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from tkinter import *
- import sqlite3
- # def create_db():
- # conn = sqlite3.connect('palabras.db')
- # cur = conn.cursor()
- # cur.execute('create table if not exists words(words text)')
- # cur.execute('insert into words values (?)', ('silencio',))
- # cur.execute('insert into words values (?)', ('hogar',))
- # cur.execute('insert into words values (?)', ('zapallo',))
- # cur.execute('insert into words values (?)', ('รฑeri',))
- # conn.commit()
- # cur.close()
- # conn.close()
- # create_db()
- def fetch_data(word):
- conn = sqlite3.connect('palabras.db')
- cur = conn.cursor()
- cur.execute("select words from words where words like ? || '%'", (word,))
- allw = cur.fetchall()
- return allw
- def on_key_release(event):
- qword = event.widget.get()
- allw = fetch_data(qword)
- listb.delete(0, END)
- for w in allw:
- listb.insert(END, w)
- def on_selection(event):
- ent.delete(0, END)
- ent.insert(0, event.widget.selection_get())
- root = Tk()
- ent = Entry(root)
- ent.bind('<KeyRelease>', on_key_release)
- listb = Listbox(root)
- listb.bind("<<ListboxSelect>>", on_selection)
- ent.grid(row=0, column=0)
- listb.grid(row=1, column=0)
- #first time listbox load
- allw = fetch_data('')
- for w in allw:
- listb.insert(END, w)
- root.mainloop()
Advertisement
Add Comment
Please, Sign In to add comment