spacepaste

Paste details

reply | raw

  1.  
  2. import sqlite3 as sqlite
  3. import tkinter as tk
  4. from tkinter import ttk
  7. # GUI Widgets
  9. class EsperantoDict:
  10. def __init__(self, master):
  12. master.title("EsperantoDict")
  13. master.iconbitmap("Esperanto.ico")
  14. master.resizable(False, False)
  15. master.configure(background='#EAFFCD')
  16. self.style = ttk.Style()
  17. self.search_var = tk.StringVar()
  18. self.search_var.trace("w", lambda name, index, mode: self.update_list())
  20. self.style = ttk.Style()
  21. self.style.configure("TFrame", background='#EAFFCD')
  22. self.style.configure("TButton", background='#C6FF02')
  23. self.style.configure("TLabel", background='#EAFFCD')
  25. self.frame_header = ttk.Frame(master, relief=tk.FLAT)
  26. self.frame_header.config(style="TFrame")
  27. self.frame_header.pack(side=tk.TOP, padx=5, pady=5)
  29. self.logo = tk.PhotoImage(file=r'C:\EsperantoDict\eo.png')
  30. self.small_logo = self.logo.subsample(10, 10)
  32. ttk.Label(self.frame_header, image=self.small_logo).grid(row=0, column=0, stick="ne", padx=5, pady=5, rowspan=2)
  33. ttk.Label(self.frame_header, text='EsperantoDict', font=('Arial', 18, 'bold')).grid(row=0, column=1)
  35. self.frame_content = ttk.Frame(master)
  36. self.frame_content.config(style="TFrame")
  37. self.frame_content.pack()
  39. self.entry_search = ttk.Entry(self.frame_content, textvariable=self.search_var, width=30)
  40. self.entry_search.bind('<FocusIn>', self.entry_delete)
  41. self.entry_search.bind('<FocusOut>', self.entry_insert)
  42. self.entry_search.grid(row=0, column=0, padx=5)
  43. self.entry_search.focus()
  44. self.entry_search.bind("<Key>", self.edit_input)
  46. self.button_search = ttk.Button(self.frame_content, text="Search")
  47. self.photo_search = tk.PhotoImage(file=r'C:\EsperantoDict\search.png')
  48. self.small_photo_search = self.photo_search.subsample(3, 3)
  49. self.button_search.config(image=self.small_photo_search, compound=tk.LEFT, style="TButton")
  50. self.button_search.grid(row=0, column=2, columnspan=1, sticky='nw', padx=5)
  51. self.button_search.bind('<Return>', self.search_word)
  53. self.listbox = tk.Listbox(self.frame_content, height=30, width=30)
  54. self.listbox.grid(row=1, column=0, padx=5)
  55. self.scrollbar = ttk.Scrollbar(self.frame_content, orient=tk.VERTICAL, command=self.listbox.yview)
  56. self.scrollbar.grid(row=1, column=1, sticky='nsw')
  57. self.listbox.config(yscrollcommand=self.scrollbar.set)
  58. self.listbox.bind('<<ListboxSelect>>', self.enter_meaning)
  60. self.textbox = tk.Text(self.frame_content, relief=tk.GROOVE, width=60, height=30, borderwidth=2)
  61. self.textbox.config(wrap='word')
  62. self.textbox.grid(row=1, column=2, sticky='w', padx=5)
  64. # SQLite
  65. self.db = sqlite.connect(r'C:\EsperantoDict\test.db')
  66. self.cur = self.db.cursor()
  67. self.cur.execute("SELECT Esperanto FROM Words ORDER BY Esperanto")
  68. for row in self.cur:
  69. self.listbox.insert(tk.END, row)
  70. self.update_list()
  72. def update_list(self):
  73. self.listbox.delete(0, tk.END)
  74. search_term = self.search_var.get().lower()
  75. if search_term == 'type to search':
  76. search_term = ''
  77. self.cur.execute("SELECT Esperanto FROM Words WHERE LOWER(Esperanto) LIKE ? ORDER BY Esperanto",
  78. ('%'+search_term+'%',))
  79. for row in self.cur:
  80. item = row[0]
  81. self.listbox.insert(tk.END, item)
  82. for row in range(0, self.listbox.size(), 2):
  83. self.listbox.itemconfigure(row, background="#f0f0ff")
  85. def edit_input(self, input):
  86. words = ["ĝ", "ĉ", "ĥ", "ĵ", "ŭ", "ŝ"]
  87. char = ["gx", "cx", "hx", "jx", "ux", "sx"]
  88. letter = ''
  89. if True:
  90. user_in = self.search_var.get().lower()
  91. if user_in in char:
  92. if char[0] in user_in:
  93. letter = words[0]
  94. elif char[1] in user_in:
  95. letter = words[1]
  96. elif char[2] in user_in:
  97. letter = words[2]
  98. elif char[3] in user_in:
  99. letter = words[3]
  100. elif char[4] in user_in:
  101. letter = words[4]
  102. elif char[5] in user_in:
  103. letter = words[5]
  104. return self.entry_search.insert(tk.INSERT, letter)
  106. # SQLite
  107. def enter_meaning(self, tag):
  108. for index in self.listbox.curselection():
  109. esperanto = self.listbox.get(index)
  110. results = self.cur.execute("SELECT English FROM Words WHERE Esperanto = ?", (esperanto,))
  111. for row in results:
  112. self.textbox.delete(1.0, tk.END)
  113. self.textbox.insert(tk.END, row[0])
  115. def entry_delete(self, tag):
  116. if self.entry_search.get() == 'Type to Search':
  117. self.entry_search.delete(0, tk.END)
  118. return None
  120. def entry_insert(self, tag):
  121. if self.entry_search.get() == '':
  122. self.entry_search.insert(0, "Type to Search")
  123. return None
  125. def search_word(self):
  126. esperanto = self.listbox.selection_set(0)
  127. results = self.cur.execute("SELECT English FROM Words WHERE Esperanto = ?", (esperanto,))
  128. for row in results:
  129. self.textbox.delete(1.0, tk.END)
  130. self.textbox.insert(tk.END, row[0])
  133. def main():
  134. root = tk.Tk()
  135. EsperantoDict(root)
  136. root.mainloop()
  139. if __name__ == '__main__': main()
  141. # db tbl name: Words
  142. # db first field name: Esperanto
  143. # db second field name: English
  144.  
Powered by spacepaste. Paste removal.