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('600x400')


name = StringVar()
name_label = Label(text="Введите штрихкод:").grid(row=0, column=0, sticky=W, pady=10, padx=10)
name_entry = Entry(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 = Label(text = name.get())
		root.bind('<Return>', change)
		if len(name.get()) == 0:
			print ('Введите код')
		elif len(name.get()) != 0:
			# Отправка SQL запроса
			db_executor.execute("INSERT INTO `scaner` (`number`) VALUES (%s)", ((label['text'])))

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

			print(label['text'])
			name_entry.delete(0, END)

ck = db_executor.execute("SELECT * FROM scaner2")
print (ck)
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()