spacepaste

Paste details

reply | raw

  1.  
  2. #! /usr/bin/env python3
  3. #GeologyDict by Ali M
  4. import sqlite3 as sqlite
  5. import tkinter as tk
  6. from tkinter import Text
  7. from tkinter import Entry
  8. from tkinter import Scrollbar
  9. from tkinter import ttk
  11. #GUI Widgets
  14. class EsperantoDict:
  15. def __init__(self, master):
  17. master.title("EsperantoDict")
  18. master.resizable(False, False)
  19. master.configure(background='#EAFFCD')
  21. self.search_var = tk.StringVar()
  22. self.search_var.trace("w", lambda name, index, mode: self.update_list())
  24. self.style = ttk.Style()
  25. self.style.configure("TFrame", background='#EAFFCD')
  26. self.style.configure("TButton", background='#EAFFCD')
  27. self.style.configure("TLabel", background='#EAFFCD')
  29. self.frame_header = ttk.Frame(master, relief=tk.FLAT)
  30. self.frame_header.pack(side=tk.TOP, padx=5, pady=5)
  32. self.logo = tk.PhotoImage(file=r'C:\EsperantoDict\eo.png')
  33. self.small_logo = self.logo.subsample(10, 10)
  35. ttk.Label(self.frame_header, image=self.small_logo).grid(row=0, column=0, stick="ne", padx=5, pady=5, rowspan=2)
  36. ttk.Label(self.frame_header, text='EsperantoDict', font=('Arial', 18, 'bold')).grid(row=0, column=1)
  38. self.frame_content = ttk.Frame(master)
  39. self.frame_content.pack()
  41. self.entry_search = ttk.Entry(self.frame_content, textvariable=self.search_var)
  42. self.entry_search.grid(row=0, column=0)
  43. self.entry_search.bind('<Button-1>', self.entry_delete)
  45. self.button_search = ttk.Button(self.frame_content, text="Search")
  46. self.aks = tk.PhotoImage(file=r'C:\EsperantoDict\search.png')
  47. self.small_aks = self.aks.subsample(3, 3)
  48. self.button_search.config(image=self.small_aks, compound=tk.LEFT)
  49. self.button_search.grid(row=0, column=1, columnspan=2)
  51. self.listbox = tk.Listbox(self.frame_content, height=28)
  52. self.listbox.grid(row=1, column=0)
  53. self.scrollbar = ttk.Scrollbar(self.frame_content, orient=tk.VERTICAL, command=self.listbox.yview)
  54. self.scrollbar.grid(row=1, column=1, sticky='ns')
  55. self.listbox.config(yscrollcommand=self.scrollbar.set)
  56. self.listbox.bind('<<ListboxSelect>>', self.enter_meaning)
  58. self.textbox = tk.Text(self.frame_content, width=60, height=27)
  59. self.textbox.grid(row=1, column=2)
  61. # SQLite
  62. self.db = sqlite.connect(r'C:\EsperantoDict\test.db')
  63. self.cur = self.db.cursor()
  64. self.cur.execute('SELECT Esperanto FROM Words')
  65. for row in self.cur:
  66. self.listbox.insert(tk.END, row)
  67. for row in range(0, len(row), 2):
  68. self.listbox.itemconfigure(row, background= "#f0f0ff")
  70. def update_list(self):
  71. search_term = self.search_var.get()
  72. for item in self.listbox.get(0, tk.END):
  73. if search_term.lower() in item:
  74. self.listbox.delete(0, tk.END)
  75. self.listbox.insert(tk.END, item)
  77. # SQLite
  79. def enter_meaning(self, tag):
  80. if self.listbox.curselection():
  81. results = self.cur.execute("SELECT English FROM Words")
  82. for row in results:
  83. self.textbox.insert(tk.END, row)
  86. def entry_delete(self, tag):
  87. self.entry_search.delete(0, tk.END)
  88. return None
  91. def main():
  92. root = tk.Tk()
  93. esperantodict = EsperantoDict(root)
  94. root.mainloop()
  96. if __name__ == '__main__': main()
  98. #db tbl name: Words
  99. ##db first field name: Esperanto
  100. ##db second field name: English
  101.  
Powered by spacepaste. Paste removal.