# import pymysql.cursors
# import pymysqlpool
from tkinter import *


# class DBExecutor():
#     def __init__(self, **connection_params):
#         self._connection_params = connection_params
#         self._connection = None
#
#     def _connect(self):
#         self._connection = pymysql.connect(**self._connection_params)
#
#     def execute(self, sql, *args, **kwargs):
#         if not (self._connection and self._connection.ping(True)):
#             self._connect()
#         with self._connection.cursor() as cursor:
#             cursor.execute(sql, *args, **kwargs)
#         self._connection.commit()
#
#
# # использование
# db_executor = DBExecutor(host='127.0.0.1', user='root', password='', db='python', charset='utf8mb4',
#                          cursorclass=pymysql.cursors.DictCursor, autocommit=True)

root = Tk()
root.title('Считыватель Штрих кодов')
root.geometry('900x400')

name = StringVar()
name_label = Label(text="Введите штрихкод:").grid(row=0, column=0, sticky=W, pady=10, padx=10)
name_entry = Entry(root, textvariable=name)
name_entry.focus_set()
name_entry.grid(row=0, column=1, columnspan=2, sticky=W + E, padx=10)
cmp_txt = Text(root, height=6)
cmp_txt.grid(row=2, column=1)
# cmp_txt = Text(root)
#
# cmp_txt.grid(row=2, column=1,columnspan=2 )

# данный код выбирает нажатую вид бутылки и сохраняет данные в этой переменной
def change(event=None):
    if var.get() == 0:
        label = name.get()
        root.bind('<Return>', change)
        if len(name.get()) == 0:
            Label(text='Введите код').grid(row=2, column=1, sticky=W, pady=10, padx=10)
        elif len(name.get()) != 0:
            # Отправка SQL запроса
            # db_executor.execute("INSERT INTO `scaner` (`number`) VALUES (%s)", (label))
            # Label(text= label).grid(row=2, column=1, sticky=W, pady=10, padx=10)

            # вот код ___________________________________________________________________________
            print(name.get())
            cmp_txt.insert(END, label + "\n")
            # ________________________________________________________________________

            name_entry.delete(0, END)
    elif var.get() == 1:
        label = name.get()
        root.bind('<Return>', change)
        if len(name.get()) == 0:
            Label(text='Введите код').grid(row=2, column=1, sticky=W, pady=10, padx=10)
        elif len(name.get()) != 0:
            # Отправка SQL запроса
            # db_executor.execute("INSERT INTO `scaner2` (`number`) VALUES (%s)", (label))

            Label(text=label).grid(row=2, column=1, sticky=W, pady=10, padx=10)
            name_entry.delete(0, END)


var = IntVar()
var.set(0)
t05 = Radiobutton(text="Тара: 0.5", variable=var, value=0).grid(row=1, column=0)
t07 = Radiobutton(text="Тара: 0.7", variable=var, value=1).grid(row=1, column=1)
button = Button(text="Отправить", command=change).grid(row=1, column=2, padx=10)


root.mainloop()