#! /usr/bin/env python3
__author__ = 'deadmarshal'
import sqlite3 as sqlite
import tkinter as tk
from tkinter import Listbox
from tkinter import Text
from tkinter import Entry
from tkinter import Scrollbar
from tkinter import ttk

#GUI
root = tk.Tk()

frame1 = ttk.LabelFrame(root)
frame1.config(height=200, width=300, text="Words")
frame1.pack(side=tk.LEFT, anchor='nw')
frame1.config(padding=(3, 5))
frame2 = ttk.LabelFrame(root)
frame2.config(height=200, width=300, text="Definitions")
frame2.pack(side=tk.RIGHT, anchor='ne')
frame2.config(padding=(3, 5))

entry = tk.Entry(frame1, width=30)
entry.grid(row=0, column=0)

button = ttk.Button(frame1, text="Search")
button.grid(row=0, column=1)

textbox = Text(frame2, width=60, height=30)
textbox.pack()
listbox = Listbox(frame1, height=30, width=30)
s = Scrollbar(frame1, orient=tk.VERTICAL)
listbox.configure(yscrollcommand=s.set)
listbox.grid(row=1, column=0)



def listboxitemclicked():
    listbox.bind('<Button-1>')

#sqlite
db = sqlite.connect(r'/home/deadmarshal/PycharmProjects/Geologydict/test.db')
cur = db.cursor()
cur.execute('select Esperanto from Words')

for row in cur:
    listbox.insert(tk.END, row)
    if listboxitemclicked():
        for row in cur:
            cur.execute('select English from Words')
            textbox.insert(tk.END, cur)


#db tbl name: Words
##db first field name: Esperanto
##db second field name: English

root.mainloop()