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)




#данный код выбирает нажатую вид бутылки и сохраняет данные в этой переменной
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,  name.get() + "\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)

cmp_txt = Text(root, height=6).grid(row=2, column=1)

root.mainloop()